Coloring bars in drill down dimension using Class function

[kaifi_nadeem]

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)

[Anil_Babu_Samineni]

Can you provide sample application?

[ychaitanya]

use the Background Color option  for the Expression and use the respective RGB's for the categories.

[kaifi_nadeem]

Hi Anil,

Attached is the test application.

Thanks