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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive