Long time lurker, first time poster here.
I need to create a metric within either the ETL stage or directly in the dashboard (I suspect it will need to be don at dashboard level) for meetings attended. It is calculated as:
Count of Marked as done date within date range AND Due date within data range
So for example if the dashboard is currently filtered to look at the previous month the metric will be: Count of Marked as done date between 1st Feb 22 and 28th Feb 22 AND Due date between 1st Feb 22 and 28th Feb 22
The marked as done date and due date wont always be the same day as the due date could be 28th Feb and the done date could be 1st March, in which case it wouldn't be counted in the metric.
Is there a way within the dashboard/cards to take two dates into consideration and if not is there a work around?
Also, for the record, I do not agree with how we are calculating this in the first place, but lets gloss over that.