Compare average with Top n regions

0 votes
How to compare average profit of all regions with top n regions using filter?
May 2, 2019 in Tableau by akshay
562 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, 2019 by Cherukuri
• 33,030 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 4, 2018 in Tableau by ffdfd
• 5,550 points
4,264 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,820 points
474 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 ffdfd
• 5,550 points
1,135 views
0 votes
0 answers

Issues with the Tableau server extracts

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

Apr 21, 2018 in Tableau by Atul
• 10,240 points
682 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
9,832 views
+2 votes
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
1,561 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, 2019 in Tableau by Cherukuri
• 33,030 points
872 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, 2019 in Tableau by Cherukuri
• 33,030 points
650 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP