Pie chart beginner struggles

[PleaseHelpMe]

 

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. 

[marcwo · Accepted solution]

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 amountUsing this, you can have an ID selector and a donut chart showcasing what you are looking fordimension for that chart is going to be the killsgain type and the amount is the metric

Thanks
Marc