title: Google Big Query Flatten table and use table_range function
body: <p>Does anyone know how to use multiple FLATTEN function and Table_date_range at the same time? Now I can only get one day data, but I would like to have all the data that are available. Is there a way to do it?</p>
  
  <pre><code>select 
  Date,COUNT(DISTINCT FULLVISITORID),hits.product.v2ProductCategory
  FROM FLATTEN((FLATTEN (table, hits.product.v2ProductCategory)) ,customDimensions.value)
  group by Date
  ,hits.product.v2ProductCategory
  </code></pre>
  
  <p>Thank you</p>