Page 1 of 1

Dashboard - pie chart calculate percentage

Posted: Wed Apr 21, 2021 7:32 am
by user2000
Hello,

I am evaluating the Dashboard and I am trying to create a pie-chart like in the image from table. In the chart Editor for Value => Sum(Value)
Series=>Product Name
The problem is I don't know how to calculate target. The Target should be 225.
I searched in examples but in all pie-charts the percentages are calculated using two columns and not the only one.
pieChart.jpg
pieChart.jpg (39.77 KiB) Viewed 3175 times
Thanks in advance.

Re: Dashboard - pie chart calculate percentage

Posted: Fri Apr 23, 2021 8:21 pm
by Lech Kulikowski
Hello,

Please check the sample report in the attachmnt.

Thank you.

Re: Dashboard - pie chart calculate percentage

Posted: Mon Apr 26, 2021 5:39 pm
by user2000
Thank you for your help,

the idea is to create a new data transformation. Very useful your example, I found answers for other questions.

Re: Dashboard - pie chart calculate percentage

Posted: Mon Apr 26, 2021 8:27 pm
by Lech Kulikowski
Hello,

You are welcome!