Pie chart: Creating two fields - Group with max group sum and sum of all other groups

lmcarter — Wed, 26 Sep 2018 13:45:45 GMT

Hi all

I have data that looks like the following:

Group	Amount
Group 1	1
Group 1	2
Group 1	3
Group 2	2
Group 2	3
Group 3	1
Group 3	2
Group 3	3
Group 3	1

I am wanting to create a pie chart (as a KPI) that shows the sum of all amounts for the max group compared to the sum of the rest of the groups added together - obviously the 'max group' will change when more data gets added to the data set so the pie chart needs to be fluid.

The way I am wanting to get the data to graph looks like this:

Group	Amount
Group 3	7
Other	11

The pie would look something like this (Where the orange is the added amounts for all other groups and the grey is the added amounts for the group that has the max added value amounts for it's group)

Re: Pie chart: Creating two fields - Group with max group sum and sum of all other groups

Ivan_Bozov — Wed, 03 Oct 2018 19:11:42 GMT

Hello! Do this:

Dimension: Group

Measure: Sum(Amount)

Apply this settings in the Data tab:

topic Pie chart: Creating two fields - Group with max group sum and sum of all other groups in App Development

Pie chart: Creating two fields - Group with max group sum and sum of all other groups

Re: Pie chart: Creating two fields - Group with max group sum and sum of all other groups