title: Google Data Studio Sum with Conditions
body: <p>I have one metric and one dimension
  I need to create a calculated field like SQL Query:</p>
  <pre><code>sum(new_users) where event_action= &quot;manual_widget_click&quot; / Total_new_Users
  </code></pre>
  <p>I can not understand the logic of formulas in Data Studio.
  Not here standard functions like 'sumif' or 'where'....
  only 'Case When'. But I can not put together a formula...</p>
  <p><a href="https://i.stack.imgur.com/OKMDg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OKMDg.png" alt="enter image description here" /></a></p>