Google-sheets – Google Data Studio – Sum of 2 fields from different data sources

google sheetsgoogle-data-studioworksheet-function

I'm just getting started with Google Data Studio. I have connected 2 different Shopify stores to it, which worked totally fine.

Now I try to show the sum of the revenue of both stores, but the calculated field option only let me choose the field of 1 store connected.

How can I create the sum of the revenue field of 2 different data sources?

Best Answer

  1. Insert a first scorecard with Shopify n°1 as a data source.
  2. Insert a second scorecard with Shopify n°2 as a data source
  3. Select both > Right-click > Blend data

You create a blended data source by joining the records in one data source to the records of up to 4 other data sources. To join the data, each data source in the blend must share a set of one or more dimensions, known as a join key. Blended data sources include all the records from the leftmost data source in the Blend Data panel, and the records from the data sources to the right that share the same values across the join key.

How blending works - support.google.com

Related Topic