Custom Filters - YoY, MoM, Last Year
Hello Folks,
I understand we can do comparison in terms of YoY, MoM, Last year etc on a graph chart. But can I have those calc as Filters on the dashboard?
Please guide me, Also can we add any other customer filters specific to scenario?
TIA.
Best Answer
-
Hi @LearningNinja Maybe Variables is the feature you are looking for? The use cases in the YouTube video are available on the Community Domo instance if you wanted to look at the "guts" of the variables / calculations. Jump to 17:25 if the link doesn't take you there, and see if this is what you're envisioning.
0
Answers
-
If you want to filter on the actual numbers that it needs to be part ofyour dataset. An alternative method for doing period over period is to restructure your data calculate the period over period in a beast mode save it to the dataset and then filter that value. I’ve done a write up how to do this here:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith - Thanks for the detailed guide. I believe this solution would require the ETL to run every day to ensure Last week, Last 3 weeks etc etc to be adjusted with my Data to real-time.
Having around 10+ million rows of data, I think, this is would make an impact on the performance. Do you think I can write some formula to derive the filters in custom way in Beast mode?
0 -
Hi @LearningNinja Maybe Variables is the feature you are looking for? The use cases in the YouTube video are available on the Community Domo instance if you wanted to look at the "guts" of the variables / calculations. Jump to 17:25 if the link doesn't take you there, and see if this is what you're envisioning.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 613 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 726 Beast Mode
- 52 App Studio
- 40 Variables
- 676 Automate
- 173 Apps
- 450 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
- 9 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 107 Community Announcements
- 4.8K Archive