title: Find Percentage Of Total With Filters In Tableau
body: <p>The following is easily done in SQL, but i am having a little trouble doing the same thing in tableau just from the raw data.</p>
  
  <p>The raw data is in the following format.</p>
  
  <p>Date | Crimetype | Crimes</p>
  
  <p>2015-06-01 | Violent | 5</p>
  
  <p>2015-06-01 | Violent | 5</p>
  
  <p>2015-06-02 | Misdemeanor | 3</p>
  
  <p>2015-06-03 | Parking Related | 2</p>
  
  <p>What I want to do is get by date, show the number of all crimes and the number of crimes that are 'Violent' or 'Misdemeanor', and then the percentage of crimes that are 'Violent' or 'Misdemeanor.'</p>
  
  <p>This is super easy to do in SQL but I want to be able to do this in tableau from the raw data.</p>