title: Tableau - Similar function to SQL Group by
body: <p>I have recently started using Tableau but am still very new to it. I don't know enough of the Tableau vocabulary to be able to find this answer through brute force googling. Hopefully some one here can help point me in a good direction. </p>
  
  <p>I have a simple table of data, containing the columns and types: Date (Date), ID (Numerical), and Status (Text)</p>
  
  <p>I want to be able to generate a report that has: Date, and Percent of the IDs on that date where the Status is "Complete."</p>
  
  <p>In SQL I could do this by running a query along the lines of:</p>
  
  <pre><code>select date, (count(status like "Complete")/count(status)*100) from table
  group by date;
  </code></pre>
  
  <p>Where can I look for this in Tableau? I tried creating a new Calculated measure in the sheet I am working on, but I couldn't find any built in functions that would add this ability. Thanks for any assistance. </p>