I’m using a Redash instance in GCP. Data is loaded into couple of BQ tables. I created a query like below:
select s.segment Segment, sum(e.sales_amt) Sales
from sample.lookup_segment s, sample.redash_example e
where s.customer = e.customer
group by s.segment
Now I want to include a dashboard prompts or filters for Segment and Customer fields. Noticed a checkbox to activate dashboard filter but not sure how I accomplish it for the above query. Can someone help please?