How do I filter on two dates?
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.
Thank you for your response.
That would work if the dashboard was only ever looking at previous month, but they have the ability to change the date range, to anything0
@TheBardsGirl If users can change the month then I don't think an ETL would work cause it would not be fully dynamic. You could try to setup a beast mode that looks at min and max dates so it takes in whatever range they choose.0
It looks as though you are wanting to count when something is done and due in the same month. In which case, I would do this:
CASE WHEN Month(duedate) = Month(donedate) AND YEAR(duedate) = YEAR(donedate) THEN 1 ELSE 0 END
You can then sum this beast mode to get the count.**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
- 7.7K All Categories
- 12 Connect
- 925 Connectors
- 247 Workbench
- 441 Transform
- 1.7K Magic ETL
- 61 SQL DataFlows
- 456 Datasets
- 88 Visualize
- 222 Beast Mode
- 2.1K Charting
- 8 Variables
- 35 Cards, Dashboards, Stories
- 5 Automate
- 349 APIs & Domo Developer
- 85 Apps
- 17 Predict
- 3 Jupyter Workspaces
- 14 R & Python Tiles
- 242 Distribute
- 60 Domo Everywhere
- 241 Scheduled Reports
- 18 Manage
- 39 Governance & Security
- 46 Product Ideas
- 1.1K Ideas Exchange
- 6 Community Forums
- 19 Getting Started
- 6 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 577 日本支部