Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create a KPI card that displays Yes or No if my cost = delivered. I am trying to display it so that if it’s Yes it’s in blue and if it’s No it’s in Red. However I cannot figure out how to change the color depending on Yes or No. please advise
Maybe this, in your script, creates a status field through your cost field.
In the KPI you will need a numeric expression to enable the configuration of conditional colors, so work with the Match() function, it returns numeric values from your Status field.
dual(only(Status),match(Status,'Yes','No'))
- Enter the expression and change it to Measure expression
On the Color tab, set the color to 1 – Yes, 2 – No
Result:
Note the solution above is just an example according to the information provided, so you will certainly need to make some adjustments.
- Regards, Matheus