title: How to create Calculated Field Filters in Google Data Studio?
body: <p>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 <code>Unique Pageviews</code> from the bottom of the funnel vs the number of <code>Unique Pageviews</code> at the top of the funnel; for example:</p>
  <pre><code>Page= www.test.com/page-funnel-1 -&gt; 100
        Filter: Page = */page-funnel-1
  Page= www.test.com/page-funnel-end -&gt; 10
        Filter: Page = */page-funnel-end
  CR: 10/100 = 10% 
  </code></pre>
  <p>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:</p>
  <pre><code>CASE
    WHEN REGEXP_MATCH(Page, &quot;.*home-type&quot;) THEN Unique Page View
    ELSE 0
  END
  </code></pre>
  <p><strong>This field is the one you would need to calculate in Google Data Studio</strong>:</p>
  <p><img src="https://i.stack.imgur.com/ykHJW.png" alt="" /></p>