Dynamic Conditional Coloring of KPI Object

[Anonymous]

Hello Everyone!

Can anyone tell me please on how to dynamically change the color of a KPI object, I know it has a limit with an expression but unless the value is static (i.e. 100) the conditional coloring will not work for some reason here is what I use in my expression to set the limit:

num((Count({$<Duration= {'>=0<=8'}>} distinct ReqID)) /(Count(Distinct ReqID)), '#,##0%') < 0.6

Thanks for your help in advance!

[Chanty4u]

num((distinct Count({$<Duration= {'>=0<=8'}>} ReqID)) /Count (ReqID)), '#,##0%') < 0.6

[Anonymous]

Thanks Sureshqv, I have tried you expression, however, it gives an error in expression. Any ideas?

[sunny_talwar]

Not sure I understand this?

but unless the value is static (i.e. 100) the conditional coloring will not work for some reason

Would you be able to elaborate?

[Anonymous]

Sure, what I mean is that if I use an expression like the one I mentioned above it will not work correctly; however, if I put in the expression field a static value like 50 or 100 the coloring will work perfectly. I hope it is clear now.

[divya_anand]

Hi,

Did you find a solution for this?