topic Dynamic Conditional Coloring of KPI Object in App Development

Dynamic Conditional Coloring of KPI Object

Anonymous — Tue, 16 Feb 2016 06:44:51 GMT

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!

Re: Dynamic Conditional Coloring of KPI Object

Chanty4u — Tue, 16 Feb 2016 08:51:18 GMT

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

Re: Dynamic Conditional Coloring of KPI Object

Anonymous — Tue, 16 Feb 2016 08:58:14 GMT

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

Re: Dynamic Conditional Coloring of KPI Object

sunny_talwar — Tue, 16 Feb 2016 09:07:11 GMT

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?

Re: Dynamic Conditional Coloring of KPI Object

Anonymous — Tue, 16 Feb 2016 09:11:07 GMT

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.

Re: Dynamic Conditional Coloring of KPI Object

divya_anand — Fri, 10 Mar 2017 09:14:04 GMT

Hi,

Did you find a solution for this?