title: COUNTIFS function in Google Data studio
body: <p>I have 2 columns called continent and completion and i would like to calculate completion %  for each continent based on below data.
  This was defined in excel using COUNTIFS() function</p>
  
  <p>Can we achieve this In data studio??</p>
  
  <p>Completion % formula is Total number of  Status in 'closed' / Total number of Status
  Status values are  'open','in progress','service completed','closed'</p>
  
  <pre><code>continent          completion %         
  
  ------------     -------------------       
  
  Asia                  97%(used countifs function to calculate percentage in excel)
  Europe                89%              
  North America         93%      
  </code></pre>