Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've created a KPI, and I need to designate if the KPI is good, okay, or bad (green, yellow, red). I'm looking to have the KPI indicator (arrow) point up if the measure is greater than 100%, have it point to the right if the measure is between 90% and 100%, and have it point down if the measure is less than 90%.
I had no problem getting the "Target color expression" to work properly, but my "Icon direction expression" isn't working properly. The expressions are exactly the same, except one is for colors and the other is for arrow direction. I tried looking up how to indicate arrow direction in an expression, and I found the chr() values, but those aren't working. I've also tried pasting in arrows, like '▲', into the expression, but that didn't work either.
Does anyone know how to fix my Icon direction expression so that it works properly? I'm guessing it's a simple fix and I just don't know the proper syntax...or maybe I set something up incorrectly with the target mode.
Thanks.
Target Color Expression (works just fine):
=if([Expression %]>= 1.00,'green',if([Expression %]< 1.00 and [Expression %] >= 0.90,'yellow','red'))
Icon Direction Expression (not working):
=if([Expression %] >= 1.00,chr(9650),if([Expression %] < 1.00 and [Expression %] >= 0.90,chr(9658),chr(9660)))
Hi @AdamAlls
i think this is what you need
=if([Expression %] >= 1.00,chr(9650),if([Expression %] >= 0.90,chr(9658),chr(9660)))
you can try using icon directly
=if([Expression %] >= 1.00,'▲',if([Expression %] >= 0.90,'►','▼'))
you dont need to specify [Expression %] < 1.00 as you are already in the "else" section.
hope this helps.
Best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂
Yeah, your expression is definitely simplified, but they do the same thing. I tried both the chr() and '▲' icons, but neither worked.
Hi @AdamAlls
try pasting here a couple of records as an inine example and the formula for measure [Expression %]
best,
Below are some simplified dummy numbers...basically I just Sum([Packaged]) (call it [Total Packaged]) and Sum([Plan]) (call it [Total Plan]), and then the [Expression %] = [Total Packaged]/[Total Plan], pretty straightforward.
[Packaged]:
LOAD *
Inline
[
Packaged, Date
2, 9/1/2023,
4, 9/2/2023,
8, 9/3/2023,
7, 9/4/2023,
5, 9/5/2023
];
[Plan]:
LOAD *
Inline
[
Plan, Date
10, 9/1/2023,
12, 9/2/2023,
14, 9/3/2023,
18, 9/4/2023,
20, 9/5/2023
];