I am building a KPI based on turnaround time (average, median and 75 percentile) for 5 cases categories. Each "Case Category" has its own benchmark. (b1=10, b2=7 etc..)
Is there a way to color code the values based on both dimensions and aggregate measures. For example, IF [case category] = "xx" and median, median and percentile [TAT] <= "##" then ###.
Message was edited by: Majed M
It takes a bit of work but sample workbooks and information for how to do this sort of conditional formatting may be found here - Older But Still Useful – Conditional Formatting | Drawing with Numbers
Thank you and Happy New Year
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...