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.
Thanks in advance.
Dashboard - pie chart calculate percentage
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Dashboard - pie chart calculate percentage
Hello,
Please check the sample report in the attachmnt.
Thank you.
Please check the sample report in the attachmnt.
Thank you.
- Attachments
-
- ReportSample.mrt
- (17.72 KiB) Downloaded 222 times
Re: Dashboard - pie chart calculate percentage
Thank you for your help,
the idea is to create a new data transformation. Very useful your example, I found answers for other questions.
the idea is to create a new data transformation. Very useful your example, I found answers for other questions.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Dashboard - pie chart calculate percentage
Hello,
You are welcome!
You are welcome!