CODEWITHSUNDEEP
looker-studio
Cristian Alonso
Cristian Alonso

Reputation: 41

How to create Calculated Field Filters in Google Data Studio?

I am making a web analytics dashboard with Google Data Studio and I would like to show the conversion rate funnel; to find this, I have to divide the number of Unique Pageviews from the bottom of the funnel vs the number of Unique Pageviews at the top of the funnel; for example:

Page= www.test.com/page-funnel-1 -> 100
      Filter: Page = */page-funnel-1
Page= www.test.com/page-funnel-end -> 10
      Filter: Page = */page-funnel-end
CR: 10/100 = 10%

My problem is that in Google Data Studio I cannot use graphic fields to make calculated fields. I have tried to make a calculated field where I apply the necessary filters but Google Data Studio does not allow me to mix metrics with dimensions:

CASE
  WHEN REGEXP_MATCH(Page, ".*home-type") THEN Unique Page View
  ELSE 0
END

This field is the one you would need to calculate in Google Data Studio:

Upvotes: 4

Views: 13060

Answers (1)

Nimantha
Nimantha

Reputation: 6482

One way that it can be achieved is by using Ratio Metrics:

  1. Select the /page-funnel-end Scorecard;
  2. Ctrl + Select the /page-funnel-1 Scorecard (so that both Scorecards are selected);
  3. Blend Data: Right click on one of the selected Scorecards and click on Blend data from the Drop-down to create a new Scorecard, a Ratio Metric.

Editable Google Data Studio Report and a GIF to elaborate:

Upvotes: 4

Related Questions