Compare grand average with individual average using Exclude LOD

0 votes
Compare average for complete subcategory vs each subcategory avg. How to compare them in a bar chart for different region using Exclude LOD?
Apr 17 in Tableau by anitha
38 views

1 answer to this question.

0 votes

Hi Anitha,

Follow below steps:

1. Create a calculated field to find the total avg for subcategory using Fixed LOD.

2. Create another calculated field to create comparison using Exclude LOD. 

3. Now drop the above field and avg(sales) in the sheet.

4. Drop avg(sales) in to label and below Chart would be shown. The image shows category sales and difference with respect to total average.

( Green bar shows required comparison using exclude lod and red shows avg for each subcategory )

5. To show more difference i have also added a dual axis beside to show the comparison. ( Orange show the total avg and blue shows avg for each subcategory )

Hope this helps you.

answered Apr 17 by Cherukuri
• 31,840 points

Related Questions In Tableau

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
119 views
0 votes
1 answer

How to Add a Grand Average bar to an existing bar chart.

Hi Anitha, Its easy and simple, follow below steps: 1. ...READ MORE

answered Apr 4 in Tableau by Cherukuri
• 31,840 points
29 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
• 31,840 points
40 views
0 votes
1 answer

How to perform a calculation using one variable with an aggregation in calculated field?

Hi, You can use the calculative field and ...READ MORE

answered May 20 in Tableau by anonymous
• 31,840 points
39 views
0 votes
1 answer

Want to hide the Bar for Grand Total in the bar chart in Tableau

Tableau treats the whole visualization uniformly.  If you ...READ MORE

answered Aug 10, 2018 in Tableau by AwesomeSauce
• 860 points
678 views
0 votes
1 answer

Displaying Aggregations across bar chart in Tableau

Hi Sindhu, 1.You can use average lines to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 31,840 points
75 views
0 votes
1 answer

How to sort stacked bars in Tableau?

Hi Nithin,  In Stacked bar chart, sorting is ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 31,840 points
234 views
0 votes
1 answer

Compare average with Top n regions.

Hi Akshay, 1. Create a calculated field to ...READ MORE

answered May 2 in Tableau by Cherukuri
• 31,840 points
23 views
0 votes
1 answer

Exclude LOD -Tableau

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

answered Apr 2 in Tableau by Cherukuri
• 31,840 points
33 views