Fixed Lod to calculate sales from each customer than repetitive orders from customers.

0 votes
I want to calculate the sales for a region from customer only once without repeating same customer again.If a customer has bought multiple product in a region then show the average of the sales from a customer for a region.
Apr 30 in Tableau by sindhu
8 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi Sindhu,

Create a calculated field with below Fixed LOD.

Cust - sales = { FIXED [Customer ID] : AVG([Sales]) }

Now drop the Region field along with the above created calculated field.

You can observe the sales per region, sales along with avg sales per customer for each region.

Hope it helps you.

answered Apr 30 by CHERUKURI
• 12,780 points

Related Questions In Tableau

0 votes
1 answer

How to calculate weekly average from daily data?

You can create these calculated fields: Unique Weeks ...READ MORE

answered Jun 26, 2018 in Tableau by Atul
• 10,190 points
23 views
0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 28, 2018 in Tableau by Atul
• 5,470 points
258 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
1,862 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by Atul
• 5,470 points
44 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,470 points
54 views
0 votes
6 answers

How to use COUNTIF in Tableau?

I'll give you a brief idea on ...READ MORE

answered Dec 10, 2018 in Tableau by Haider
4,544 views
+1 vote
1 answer

Adding filter to LOD Expression

{ FIXED [Product]:COUNT(IF [Status]=0 THEN [Status] END)} Edit----- ...READ MORE

answered Aug 1, 2018 in Tableau by Atul
• 10,190 points
43 views
0 votes
1 answer

Exclude LOD -Tableau

Hi Nikki, You can try this,  { EXCLUDE : ...READ MORE

answered Apr 2 in Tableau by CHERUKURI
• 12,780 points
11 views
0 votes
1 answer

Show orders from date to a date through parameter.

Hi Sindhu, Follow below steps: 1. Add 2 parameters ...READ MORE

answered Apr 4 in Tableau by CHERUKURI
• 12,780 points
5 views
0 votes
1 answer

Top 5 customer based sales per each region

Hi Sindhu, Follow the below steps: 1. Select Customer ...READ MORE

answered Apr 24 in Tableau by CHERUKURI
• 12,780 points
13 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.