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
Retrieving data ...