Year filter on YOY comparison
Hi All,
I have card that I need filtered by chosen years. I have a 5 year data (2017-2021) and need be able for users to compare 2 chosen years using a filter. I tried the min/max function but does not seem to return the right result. I used the below BM:
To show recent year: case when `Year`= MAX(`Year`) then sum(`Gross Revenue`) end
To show older year: case when `Year`= MIN(`Year`) then sum(`Gross Revenue`) end
I am new to Domo and do hope someone can help. Thank you in advance.
Comments
-
In order to do what you want to do in a Beast Mode, you will have to get a feature turned on by your CSM that isn't on by default. Ask them to turn on Window Functions for Beast Modes.
Alternatively, you could accomplish this by using a pivot table card and put your Year field in the columns list. This would break up the totals by year. You could also add the Year field to the Filters section and select Turn on Quick Filters and then let the user select which years they want to view.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Hi Mark,
Thank you for the quick response.
I am looking to be able to use a year filter in a dashboard. I do have other BM within the dashboard like % Change, share, and variance. I am hoping to have a dynamic dashboard instead of recreating the dashboard every year. User can choose 2 years i.e. 2019 & 2020 and be able to compare the 2. Do you know of a way to accomplish this?
I understand the quick filter pivot table solution you suggested. How will the % Change beast mode look like?
Thank you in advance for your help.
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
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 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