Dear all,
I'm new to Tableau and just starting out, so I hope you could help me out here.
I'd like to calcualte an overall average I want to show in a table to compare to a regional average.
Using a bar chart it works pretty fine just using the Average line.
But I couldn't manage to create a fiexed overall average I could show in the table or use to compare vs. regian average.
For testing I used the "World Indicators" data source. See here:
In that chart I simply used the Average Line function. I now would want to create a calculated figure that returns the overall average of 70 that I could compare to region on row level. In that example to add another colum that would then show 70 in each row.
How can I achieve this? Tried with WINDOW_SUM but didn't work.
Thanks for helping me out.
BR
Hi @Stefan Riegel
There are 2 ways to get the Overall Average but remember that the
value depends on the Granularity level (Region )
1) Method 1 - Use an LOD calculation like
AVG ( { Fixed [Region] : AVG ( [Life Expectancy] ) } )
2) Method 2 - Use a Table Calculation like
WINDOW_AVG( AVG ( [Life Expectancy] ) ) aggregation is at the [Region] level
Also here is a screenshot :
I have attached the twbx file below (version 2019.2) and let me know if
you have any questions or need further clarity. Take care and Stay safe !
Sincerely,
Soumitra
