Hi all,
I have a simple dataset in BigQuery, which consists of 3 columns: Customer ID (many values), store ID (only has 2 values: store A and store B) and transaction date (all date of 2024).
I want to display the unique customer bought only from store A, store B and both, which can be updated following the date filter on the page.
For examples: If I set the time range filter to be June 2024, the data will display how many unique customer made a purchase from store A only, from story B only and from both store, from June 1 to June 30.
My previous approach is to create an extra column called type with value 0, 1, 2 corresponding to store A only, B only and both. However, if the date changes by the filter, then the "type" value might not be correct any more.
Is there a way to create a graph by writing an SQL query with a field can be changed by the outside filter? Is there any other recommendation?
Thank you very much for the support,
LinkedIn
Twitter
