Last Modified Date: 06 Jun 2017
- Tableau Desktop 9.2
- Google BigQuery
Extract the data, if an exact amount is needed. However, due to the large volume of data on BigQuery this is not recommended.
Using EXACT_COUNT_DISTINCT() or COUNT(distinct field, 1000000).
Option 3Alternatively, follow the workaround described in this external article: https://www.interworks.com/blog/aball/2015/09/29/tableau-tip-count-distincts-google-bigquery
CauseGoogle BigQuery provides a statistical approximate for CNTD queries.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials