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.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive