Adding 3+ measures in a donut or pie chart

Question & Answer
, ,
1

Hi,

I am trying to create a donut/pie chart where I can add multiple measures in the chart. I am aware that a calculated field has to be created to support this but I am not sure where and how I start?

I don’t want to add anything in the color/group field - I just want to get the split of each measure in the donut/pie chart

Thanks

2

Hi @akshaym, can you elaborate more on the values you are wanting to put in the value field?

Here is a similar question that may help: Multiple FIELDS in VALEU section of Pie Chart - #4 by David_Wong

3

Hi @Kelseykl,

Thank you for directing me to a similar question. I did take a look into it before reaching out to the community. But I have a different scenario

Let me re-explain my question again. So I have 4 columns each being a measure. I want to create a pie chart showing each measure as a slice for the current year. But the pie chart only supports 1 measure. In that case how can I get the desired result.

image
image1524×613 47.1 KB

Thanks

4

it needs some data transformation to achieve this as it needs to combine 4 measure column and show their proportion in a pie chart. Need to transform the data in this format.

If the data source supports SQL, then you can use a SQL like this to transform the data

SELECT Year, Group, Column 1 from table union all
SELECT Year, Group, Column 2 from table union all
SELECT Year, Group, Column 3 from table union all
SELECT Year, Group, Column 4 from table

image