@hsent12 You are using a simple Date filter. You need to use Field Filters if you want date ranges:
https://www.metabase.com/learn/sql-questions/field-filters
Otherwise you need to use two single-date filters on the dashboard.
@hsent12 Yes, those are SINGLE DATE variables, so you can only use Single Date filters on the dashboard to connect to those:
https://www.metabase.com/learn/dashboards/filters
https://www.metabase.com/docs/latest/users-guide/08-dashboard-filters.html
On this picture, the v1 homepage dashboard is the one we are trying to connect with the single dates, however it's greyed out, how can we proceed? Thank you!
Here is the code:
with desired_cohort as (
select
id
from orders_order
where 1=1
and is_order_authorized = 'true'
and is_order_using_elyn = 'true'
and order_date >={{start_range_date}}
and order_date <{{end_range_date}}
)
, status_desired_cohort as (
select distinct
order_id
, status
, updated_at as start_date_status
, coalesce(lead(updated_at,1)OVER (PARTITION BY order_id ORDER BY updated_at), current_date) as end_date_status
from orders_orderstatus
join desired_cohort on desired_cohort.id=orders_orderstatus.order_id
)
select
status
, count(distinct order_id)
from status_desired_cohort
where 1=1
and start_date_status <={{selected_date}}
and end_date_status >{{selected_date}}
group by 1
order by 2 desc
@hsent12 Post the question metadata output by going to the URL /api/card/34
And just create a new empty dashboard with just that question and a Single Date filter.
And then post the dashboard metadata by going to the URL /api/dashboard/123, where 123 is the dashboard ID.