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
36 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
118 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
27 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
39 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
37 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
671 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
73 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
230 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
22 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
32 views