Using Last Year Data on a Card Filtered to the Current Year
I have a card that shows This years Sales by month v Budget - works fine.
I want to show a summary number that is YoY% - formula wise, this is not a problem - except that as the date filter on the card is set for current year...meaning last years sales are not available to use in the YoY formula.
Any ideas?
Comments
-
Adam,
We do something similar here with a YoY % change in the summary number. What we ended up doing was just disabling the date filter for the users by checking the "Hide Date on Card Details" option when in the Analyzer.
We thought about using a "Selector" date field, but when users change the time frame, say to Last 2 Years, there's no way to account for the change if our selector is only set back 1 year. We would need some kind of calculated variable field.
What would be beneficial would be for us to set the Variance from the Period-over-Period card type in the Summary Number. If they had that option, it would take care of it automatically.
Probably not the answer you were hoping for, but hope it helps.
-ValiantSpur
0 -
@Valiant Thanks for the reply. I sort of managed to bash it to make it somewhat workable in the end. I'll share in a while...
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive