Compare average with Top n regions.

0 votes
How to compare average profit of all regions with top n regions using filter?
May 2 in Tableau by akshay
18 views

1 answer to this question.

0 votes
Hi Akshay,

1. Create a calculated field to find the avg of all regions using fixed lod.

2. Now drop region in filter shelf and select Top and enter N with max sales.

3. Drag and drop avg(profit) in sheet and regions in the sheet.

4. Now add the calculated field in step1 into the sheet or create a reference line against all regions using a bar chart.

Hope it helps you.
answered May 2 by Cherukuri
• 25,660 points

Related Questions In Tableau

+1 vote
1 answer

How to perform top N fields with nested sort in tableau

You can use the following steps: Sort 'State' ...READ MORE

answered Aug 3, 2018 in Tableau by Atul
• 5,530 points
340 views
0 votes
1 answer

Replace missing dates with 0

Create a calculated field for your dates ...READ MORE

answered Apr 6, 2018 in Tableau by QueenBee
• 1,810 points
12 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,530 points
92 views
0 votes
0 answers

Issues with the Tableau server extracts

A tableau developer had successfully created dashboard ...READ MORE

Apr 20, 2018 in Tableau by Atul
• 10,240 points
48 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,786 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
76 views
+2 votes
1 answer
0 votes
1 answer

Compare grand average with individual average using Exclude LOD

Hi Anitha, Follow below steps: 1. Create a calculated ...READ MORE

answered Apr 17 in Tableau by Cherukuri
• 25,660 points
28 views
0 votes
1 answer

How to compare sales of today with previous year?

Create a calculative field as, IF YEAR(TODAY())=YEAR([DATE_FIELD]+1 AND ...READ MORE

answered Apr 5 in Tableau by Cherukuri
• 25,660 points
36 views