I have synced this query in metabase as a simple question by creating a view in Bigquery.
Now I want to apply OUID as a category filter and date as relative date filter but I ain't getting any option in filters. Can anyone help?
with data1 as (SELECT D,OUID,DateVal,C FROM
X), data2 as (WITH
set1 AS (
set2 AS (
Group by C )
set1.A = set2.A
AND set1.C = set2.C)
select data1.D,data1.OUID,data1.C,data1.DateVal,data2.B from data1 left join data2 on data1.C = data2.C