how to compare the sum of two columns?

[Enri]

Hi! Please/// Help! 

My Google data studio data source returns a list of users. Each row has the user name, id, and two metrics. For example, the table might look like this:

​id name count1 count2
1  Joe  16     12
2  Bob  4      18

​I want to display the sum of count1 as one piece of a pie chart and the sum of count2 as the other piece. For example, the total of the count1 column is 20 and the sum of count2 is 30, so the pie chart would show 40% for count 1 and 60% for count2 since the total is 50. How would I do this?

[sam8]

Unfortunately, the pie chart in Looker Studio can only accept a dimension and a metric.

We have an open feature request about comparing 2 (or more) metrics on a pie chart, I recommend adding your use case there! https://issuetracker.google.com/issues/145840679