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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 373 Beast Mode
- 20 Variables
- 484 Automate
- 102 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive