Period over period cards interactions with filters
Hi All,
In one of my reports we're using a dataset that refreshes daily but at the end of the month we have to wait a few days for pricing on accounts to settle so the report will re-run the prior month position until rolled forward. The issue I'm having is when it comes to the end of the month all of my cards that are using "This Month" as the reporting period don't work (data still running for Feb with a Feb date but we're now in March).
To try to rectify this I've changed my cards to "All time" and added a reporting date filter at the top of the dashboard so I can select the prior month for all of my MTD cards, however for my multi value cards I have lost my comparison to the prior month - does anyone know if there's a way around this?
Additionally I want to send out the report as a scheduled report but with particular filters cards on, is this achievable?
Thanks in advance!
Best Answer
-
I do year to year, month to month comparisons using formulas.
The results can then be easily added to a bar chart or table chart. Or a bar chart with the numbers below. Each day the numbers move based on the data. Today March is empty. When the end of day numbers come through, March will start to appear.
Filters that are applied will just update the numbers as long as the field your filter on is part of the dataset.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
I do year to year, month to month comparisons using formulas.
The results can then be easily added to a bar chart or table chart. Or a bar chart with the numbers below. Each day the numbers move based on the data. Today March is empty. When the end of day numbers come through, March will start to appear.
Filters that are applied will just update the numbers as long as the field your filter on is part of the dataset.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive