Parameters/Filters to select two dates to compare
I have a situation where we are creating a snapshot of a dataset and want to perform two types of comparisons:
- By default, compare the latest snapshot to the previous snapshot
- Allow for the consumers of the cards to choose the two date fields to compare
Here is an example of the snapshot data (simplified):
Snapshot Date | Value |
9/15/2019 | 1 |
9/15/2019 | 1 |
9/15/2019 | 1 |
9/20/2019 | 1 |
9/20/2019 | 1 |
9/20/2019 | 1 |
9/25/2019 | 1 |
9/25/2019 | 1 |
9/25/2019 | 1 |
9/30/2019 | 1 |
9/30/2019 | 1 |
9/30/2019 | 1 |
Does anyone know a way to create parameter type filters for the two snapshot dates in a visual which will allow us to calculate and compare the dates chosen? Also, I would need a way to set the default to the latest value as the defaults?
Thanks,
Jim
Comments
-
How many days of data do you need to be able to compare to? There are a few approaches here. Do you always want to look at a set group of dates to compare to? For example, you always want to compare the value from one snapshot date with the previous date, with the value from 30 days ago, the value from 90 days ago, and the value from 1 year ago?
If you truly need it to be dynamic, meaning that you have to be able to select the data from any date, and then compare that with the data from any other date then I think the solution becomes much more complicated.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
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