Date Picker & Period Over Period Chart Enhancements
We have end users who want to set a date range and see the change compared to the corresponding previous period. Currently, in PoP cards, you can:
Set a comparison period on the cards that overrides the dashboard date picker
OR
Use variables and Beast Modes to create current and previous period calculations and add the Variable Control to your dashboard.
Note that there is no date picker style Variable Control, so you have to also set start and end date variables and use those in your Beast Modes.
If you try to set a custom date range / period for your PoP cards at the dashboard level, the comparison breaks.
PoP cards set to MoM:
PoP cards set to MoM, but user selects a date range with the dashboard level date picker:
Another example where a different date range is selected. In this case, the cards are set to Current Month, but still show the correct values when you select a different date period in the Date Rnage. Selecting the corresponding Chart by has no effect, and PoP breaks:
On top of the inherent complexity for a dashboard developer, this is clunky for end users and dramatically limits the self-serve utility of a dashboard, for a few reasons:
- PoP comparisons break when you use the dashboard level date picker
- PoP comparisons are locked into the setting on the card, inflexible
- Why is there a date picker, and why can I set a Graph By option, but I still have to enter the dates I want to compare in these control boxes?
It would be much more intuitive and user friendly if the dashboard level date picker could set the current period and then show the corresponding previous period change.
This might be accomplished a few ways:
- by a setting on the cards themselves that allows dashboard date picker override
- inherent override without a setting
There are some elegant examples in the BI application space. Data Studio solves the problem well, by basing the comparison period on the dashboard date picker selection:
In all 3 screenshots, the end user selects the date period they want to view data for, and the scorecard tile natively understands to compare to the previous period.
There is no additional programming required for the dashboard developer, and the end user can self serve by viewing all the data for a given time period.
Comments
-
also, i've read the forums / guides posted - this one for example -
which is helpful, but really unwieldy when you have multiple clients and datasets - and still requires a ton of development work for each Domo developer, as compared to having it implemented as part of the dashboard date picker. it also doesn't really allow the flexibility end users expect - unless we somehow come up with all the possible combinations and end user prefers (impossible).2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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