Dynamically Compare the Value of two periods


I would like to be able to dynamically change between two periods, such as in this forum post on the PowerBI forums, what would be the best way to accomplish this in Domo?
Use case might be:
As a sales manager
I want to compare sales between two non-consecutive periods (ex. Jan 1 - 4 2023 compared to Mar 19 - 22 2023) using a slider slicer control for ranges of original and comparison dates.
To determine effectivity of promotion or explore data between non-consecutive and/or differently shaped date periods
I attempted using Beast Mode vs original but this results in both cards responding to the slider (undesired) and I would like to be able to calculate the difference ($original - $comparison = $result) as a single value card
Then attempted via Magic ETL to duplicate into a Date → Comparison Date Sales → Comparison Sales using formula tiles and experimenting with card interactivity:
I would expect that I would see $41,799,783 as my comparison $ amount below, but I cannot get it to work this way.
Any help is appreciated!
Best Answer
-
Separate variables would be a good use case here. Two for the stats and two for the ends and then just compare within a beast mode if the date is between what was supplied
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Separate variables would be a good use case here. Two for the stats and two for the ends and then just compare within a beast mode if the date is between what was supplied
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive