Color code on the basis of measure of pie chart

[ruma_barman]

Hi All,

Kindly help me achieve this functionality in pie chart.

The pie should have the threshold lines of 70%,80%(dotted line) as in the pic and the output %  color code of the chart should be red,yellow,green for  <=70%,>70-80%,>=80%, respectively  .

Input:

Fact:
Load * Inline

[
Employee,Assigned,Completed
A1, 12 , 4
A2, 74 , 74
A3, 5 , 2
A4, 2 , 0
A5, 3, 3
A6, 14, 12
A7, 1 , 1
A8, 12, 12

];

Measure : sum(Completed)/Sum(Assigned)

Thanks in advance,

Ruma

[Alan_Slaughter]

Hi Ruma, could you please review this video and let us know if  this was helpful:

https://www.youtube.com/watch?v=Mrl7GlAM1LE

[ruma_barman]

Hi Alan,

This is good but not fulfilling my requirement. In guage chart we specify colors in different segments/limits and the output is visible in the segment color where it falls to but my requirement is to have the limits and the color of the whole chart should change according to the logic mentioned above,it shouldnot show different colors on different limits.

Thanks ,

Ruma

[Alan_Slaughter]

A pie chart is much more difficult to control the colors, also it isn’t selectable. Suggest trying a treemap.