Making a Pie Chart with 4 columns of data

Looker Q&A Looker Studio
1

Hi,

I’m trying to make a pie chart with 4 categories: opened on desktop, opened on mobile, opened on tablet, and opened on unknown. My data has these as columns, with individual entries for each email campaign.

How do I make a pie chart with total percentages referring to which platform these emails were opened on?

Here’s a picture of my data:

alistairjones_0-1737592377430.png
alistairjones_0-1737592377430.png569×1133 67.2 KB

Thanks so much!

2

I think this is possible, but the workaround is pretty involved.

Basically, we would need to get your data in a form a pie chart can accept. To that end, we’d need a Platform dimension and a single Opened metric that can be grouped by the Platform dimension. So your data would need to take this shape:

Platform Opened
desktop 542
mobile 213
tablet 82
unknown 9

How to get your data into that shape? It’s pretty tricky. You’d need to create 4 data sources from your spreadsheet, one for each platform, and then blend them all together. To do this:

  1. Create a new datasource based on your spreadsheet.
  2. Create a new field “Platform” and give it a constant value “Desktop”.
  3. Create a new field “Opened” that calculates the desktop opens: SUM(desktop)
  4. Create a new field “key” and give it a constant value 1. (We’ll use this as a dummy value for the blend.)
  5. Repeat steps 1-4 three more times - for “mobile”, “tablet”, and “unknown”.
  6. Blend together the four data sources. Use the “key” field to join them together using an inner join. Make sure to select the “Platform” and “Opened” fields.
  7. Using your blend, create a new pie chart with “Platform” as the dimension and “Opened” as the metric.