How to create Calculated Field Filters in Google Data Studio?

Question

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:

user_12892553 · Answer

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

Select the /page-funnel-end Scorecard;
Ctrl + Select the /page-funnel-1 Scorecard (so that both Scorecards are selected);
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:

How to create Calculated Field Filters in Google Data Studio?

1 Answers