Filtering Report Data by Multiple Dates
So, I have a dataset, Appointments. An appointment has a Created Date (the date the appointment was made by a scheduler) and a Scheduled Date (the date the customer is scheduled to come in). These dates are used for different metrics: Created Date is used for Conversion (to see how many customer interactions in a period resulted in an appointment) while Scheduled Date is used for Show Rate (to see how many appointments we scheduled had the customer actually show up and receive service in a given period).
One natural problem that occurs is that a customer may have their appointment Created at the tail end of, say, May, but they might not be scheduled to come in until the first week of June.
What I want to know is: is it possible to have the Date filter in DOMO work off of both date fields? As in, if I select May for the month, I can see both all appointments created in May, plus all the appointments scheduled for May?
Best Answers
-
@Brightsider you can but you would have to restructure your dataset. You'd need a single date column to filter off of, so you'd want to pivot your data to create a single date column, and then have a new label column that holds the value of "Created" or "Scheduled"
2 -
I figured that would be the case, but that is A-OK. Thank you, mhouston. :)
0
Answers
-
@Brightsider you can but you would have to restructure your dataset. You'd need a single date column to filter off of, so you'd want to pivot your data to create a single date column, and then have a new label column that holds the value of "Created" or "Scheduled"
2 -
I figured that would be the case, but that is A-OK. Thank you, mhouston. :)
0 -
You could concatenate the months of the two columns, and then use the "contains" filter. For example, the cell value would be "May, June" (concatenated from the two date columns), and the filter would be "Contains May"
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
That's possible, though I worry about both the performance of such a thing, plus the fact that this report is used for year-over-year comparison a lot.
Thankfully, I asked this question while I was designing the dataset rather than after I had already imported it, so I'm in the middle of updating it now. :)
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive