Colors in pie chart

[raZor]

I have this expression in a table where I am showing percentage of this expression

sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value))

I want to show pie chart as red,green,blue if the result

Dimension-

if above expression's result is  more than 111% then red

if above expression is less than or equal to 90% then yellow

if above expression's value is between 91-110% then green

Measure-

Count (profile)

[Claudiu_Anghelescu]

if(sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) > 1.11 , red(),

if(sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) >= 0.9 , yellow(),

if(sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) > 0.91 and sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) > 1.11 , green()

)))

[Claudiu_Anghelescu]

This solution helped you?