Data shows on one chart type but not the other

[#1]

Hi,

On the attached were are trying to populate different types of deceny levels (decent, potentially non decent, non decent).

I have achieved this on a pie chart and this looks ok but really wnat to populate same data on chart above (stick gauge chart); however, attempts so far have  not worked.

Is it possible to show this data on the other chart? If so, can anyone provide any pointers?

Cheers

Chris

[Gysbert_Wassenaar]

See attached qvw. If you want the counts instead of the percentages and the chart title just chat that expression to

='Decent = ' & count({<Decency={'Decent'}>}Decency) & ', Potentially Non-decent = ' & count({<Decency={'Potentially Non-decent'}>}Decency) &', Non-decent = ' & count({<Decency={'Non-decent'}>}Decency)

[#3]

Hi Gysbert

Thanks very much for this.

Inserted expression above so got numbers now; however, do you know how to get values onto the gauge and not just above? Simailrly, do you knwo how to get a legend on there to identify which colour relates to which decency reason?

At the minute you can see its not clear wihich % or numbers applies to which colour on the gauge? (i.e pie chart does both of these)

Please get back to me.

Thanks

Chris