Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
New week, new questions for me 😂
I want to understand how this limit in conditional coloring in KPI works.
Say that i have the following measure that counts the amount of IDs with a max date declared.
=count({1}distinct [ID]) - count({<[date]= {'$(=max([date))'}>}distinct [ID])
This number i want to be RED if not 0,
Green if 0.
In the limit condition, shall i write count({1}distinct [ID]) - count({<[date]= {'$(=max([date))'}>}distinct [ID]) <>0 and check red color for the area to the right of the limit range and green to the left of it?
In KPI--> Color---> Conditional color---> Set Limits---->Add Limits---> after you add limits---->you can click on the limit to change the color...
Regards
Kumar
@Rajesh5kumar but my logic for
-lets quote my above post-
"In the limit condition, shall i write count({1}distinct [ID]) - count({<[date]= {'$(=max([date))'}>}distinct [ID]) <>0 and check red color for the area to the right of the limit range and green to the left of it?"
is correct?