Historical data for new year with beast mode
Hi
We are coming to a new year, our fiscal year starts Nov, and wondering on how I can see historical data on my dashboard. Most of my beast modes are YTD like these 2 below. On the first month of 2021, my data will all change to just one month. How can I get a full year data for 2020 for historical review. Is possible to save a historical page? Your advise will be greatly appreciated. Thank you in advance.
BM Sample 1: YTD Gross Rev:
SUM(CASE WHEN `Year`= `Year for Today` AND `Month #` <=`Month # for Today`
THEN `Gross Revenue`
ELSE 0
END)
BM Sample 2: YTD Gross Rev % Change:
(SUM(CASE WHEN `Year`= `Year for Today` AND `Month #` <=`Month # for Today`
THEN `Gross Revenue`
ELSE 0
END)/
SUM(CASE WHEN `Year`= `Year for Today`-1 AND `Month #` <=`Month # for Today`
THEN `Gross Revenue`
ELSE 0
END))-1
End
Comments
-
https://www.youtube.com/watch?list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&v=wmMrnPO9ivY
in this tutorial i'm building an AR aging report, but the concept is still the same, just build a card where you can define the point in time you want to use for your YTD value.
What's cool about this is that if you had two rows in your parameter table, you could build a filter card that let's you flick between different points in time.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive