Hello,
I have a requirement for a visualization that looks something like this
The main focus is city A. and I want to display the health for that measure in city A if it is 10% less than the same measure in city B or C
ex : if population of city A is 10% less than population of city B
then 'Red'
else 'Green'
same goes for the other measures
I only need to compare A against the others and display the health
Any idea how can i do this ?
thanks
Hi Advait,
Find my initial approach as reference below and stored in attached workbook version 10.5 located in the original thread.
My approach is based on individual formatting explained here
Tableau: Advanced Conditional Formatting - YouTube
1. 01 M Pop City A: {min({fixed [City]:sum(if [City]='A' then [Pop] end)})}
2. 01 M Pop City B: {min({fixed [City]:sum(if [City]='B' then [Pop] end)})}
3. 03 M %: [01 M Pop City A]/[01 M Pop City B]
4. 01 D Colour Indicator Pop: if [03 M %]-1<=-0.1 then 'Red' else 'Green' end
Thanks,
Norbert
