Metabase newbie. Trying what I think should be simple but struggling.
- I have a model with rental leases that have 'ActiveDate' and 'InactiveDate' columns.
- I want a card on the dashboard that shows the number of leases active on a given date provided by the dashboard date filter.
I think what I need is an additional filter on the question that says "between([dashboard_date_filter, [ActiveDate], [InactiveDate]), however I can't figure out how to reference the filter value in the expression.
How can I accomplish this?