Hi ,
I have requirement to show in doughnut chart :
Chart metrics : Quantity of Producers where Measure1/Measure2 > User selected Value
Pie slices Colour should be as below:
Green : Measure1/Measure2 <=0
Yellow : Measure1/Measure2 >0 and Measure1/Measure2 <= User selected Value
Red: Measure1/Measure2 > User selected Value
Please help as i am not getting desired result as in my fact table column measure 2 has many 0 values so i am getting pie slice colour a blue instead of green.
Thanks
Chitra