title: Google Data Studio filter combining two custom fields
body: <p>I am trying to join data associated with two custom variables in the same Google Analytics dataset for a filter widget. We have institution names for older data in customVarValue2 and after GA changed the use of custom variables, newer data in Institution. I would like to be able to access all that data (back to October 2011) in one pageview chart and I think I can do that with a calculated field. </p>
  
  <p>I saw on a post in the Data Studio forums that the logical operators don't work so I've been trying to do this with individual lines like so:</p>
  
  <pre><code>CASE 
  WHEN REGEXP_MATCH(customVarValue2, '.*Denmark.*') THEN 'Denmark!' 
  WHEN REGEXP_MATCH(Institution, '.*Denmark.*') THEN 'Denmark!' 
  ELSE 'Other' 
  END
  </code></pre>
  
  <p>The goal is to end up with one "Denmark!" field in the widget dropdown where all the data is combined from the two custom fields (customVarValue2 and Institution) to cover the whole date range. I can get it to work with one of the variables and it gives me the choice of "Denmark!" and "Other" with the appropriate date range for the custom variables that I used. But when I put both "WHEN" cases in, I only get "Other" showing in the widget dropdown. I would appreciate any advice you can give.</p>
  
  <p>Thanks,
  Sandy</p>