topic Re: Display Values and Percentage in Pie Chart in App Development

Display Values and Percentage in Pie Chart

Kartik2 — Wed, 13 Dec 2023 12:24:55 GMT

I am using Valuelist('Male','Female') as a dimesion and in measures i'm using if(Valuelist('Male','Female')='Male',sum(MaleCount),sum(FemaleCount))

This is displaying values but i want to display percentages too
How can i do that?

Re: Display Values and Percentage in Pie Chart

vincent_ardiet_ — Wed, 13 Dec 2023 13:21:03 GMT

Something like this?
if(Valuelist('Male','Female')='Male',sum(MaleCount),sum(FemaleCount))/Rangesum(sum(MaleCount),sum(FemaleCount)))

Re: Display Values and Percentage in Pie Chart

Kartik2 — Thu, 14 Dec 2023 04:10:31 GMT

Umm .not working

Re: Display Values and Percentage in Pie Chart

Kartik2 — Thu, 14 Dec 2023 05:24:50 GMT

Ok , got the solution
i used this in label

'Male'&' : '&sum(Male Count)/num(sum(Male Count)+sum(Female Count),'#0.0%')&' , ' &'Female'&' : '&sum(Female Count)/num(sum(Male Count)+sum(Female Count),'#0.0%')