Pie chart beginner struggles

Looker Q&A Looker Studio
,
1

PleaseHelpMe_0-1726036139377.png
PleaseHelpMe_0-1726036139377.png265×305 7.94 KB

I am new and trying to recreate a chart similar to the one above for a video game. The issue I am running into is that only one slice of the pie chart will show and not two. I tried making a new dimension that distinguishes between the two and then adding the 2 columns together for the metric like “t4killsGain + t5killsGain”. My raw data has no null values or anything and it shows the correct sum when I simply drag out the columns on their own. I just can’t get both slices of the pie chart to show. I want this chart to be updated when I select different IDs in an input box and already have that working. I will show part of the data I am using from a google sheet below. Any help is greatly appreciated, thank you.

PleaseHelpMe_2-1726036417811.png
PleaseHelpMe_2-1726036417811.png270×321 16 KB

2

Hi @PleaseHelpMe

you data needs to be in a different format - I have done a quick example for you:

You essentially need to pivot your data. IDs will have two rows, then the killsgain type, then the amount
You essentially need to pivot your data. IDs will have two rows, then the killsgain type, then the amount302×390 7.47 KB

Using this, you can have an ID selector and a donut chart showcasing what you are looking for
Using this, you can have an ID selector and a donut chart showcasing what you are looking for838×418 9.65 KB

dimension for that chart is going to be the killsgain type and the amount is the metric
dimension for that chart is going to be the killsgain type and the amount is the metric276×360 7.77 KB

Thanks
Marc

1 Like