Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Need to color bars of chart according to drill down (With calculated dimensions). Below are my requirement and attached is the screen shot of desired result.
Within 24 : Green
24-36 : Yellow
36-48 : Orange
>48 : Red
Expression for Dimensions:-
1) =IF(Round([TpT Act based on time diff]/60)<23,'0-20',dual(Replace(class(Round([TpT Act based on time diff]/60),4),'<= x < ','-'),class(Round([TpT Act based on time diff]/60),4)))
2) =dual(Replace(class(Round([TpT Act based on time diff]/60),.5),'<= x < ','-'),class(Round([TpT Act based on time diff]/60),.5))
Measure:-
count({1< Process={'Total Time*'}>} Process)+ Sum({1}0)
Can you provide sample application?
use the Background Color option for the Expression and use the respective RGB's for the categories.
Hi Anil,
Attached is the test application.
Thanks