title: Display previous month data in bigquery
body: <p>How do I filter previous month data from Google big query (ex: Jan 1st - Jan 31)</p>
  
  <pre><code>select count(distinct hits.customDimensions.value,20000000) as TotalUniqueUsers, 
         count(distinct IF(visitnumber=1, hits.customDimensions.value, NULL),20000000) as TotalNewUsers
  from TABLE_DATE_RANGE([90461009.ga_sessions_],
                        DATE_ADD(CURRENT_TIMESTAMP(), -2, 'MONTH'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'MONTH')
                       )
  where hits.customDimensions.index=4
  </code></pre>
  
  <p>I am trying something like the above query. Could somebody help please</p>
  
  <p>Thanks!</p>