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.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 133 Manage
- 130 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive