Color Condition within condition

[Strwbryshwty]

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 

[MatheusC]

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