Line Graphic with YTD Data (cumulative total each month)
Hi People! I'm here again!
We have a dataset in DOMO like this:
And we need to create a vision like this:
where "LY" is "Last Year" and the "YTD" is the acumulated SALES of the month of the line plus the previous month.
Jan = Total SALES of Jan
Fev = Total SALES of Fev + Total SALES of Jan
Mar = Total SALES of Mar + Total SALES of Fev + Total SALES of Jan
But... here's the catch, we need to do this in BeastMode...
I try to use LAG function, but with no success...
The graph we need to create is like this:
Actually with the growth percentage and will be 3 lines, comparing 3 years:
2022vs2021 | 2021vs2020 | 2020vs2019
Any ideas if it's possible?
@bp_paulo_fernandes have you looked at @GrantSmith 's post regarding running totals in beast mode?
He lays this out pretty nicely.**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
Thank you very much!!!!!0
- 7.7K All Categories
- 5 Connect
- 921 Connectors
- 244 Workbench
- 479 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 49 Visualize
- 202 Beast Mode
- 2K Charting
- 8 Variables
- 21 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 37 Product Ideas
- 1.1K Ideas Exchange
- 2 Community Forums
- 15 Getting Started
- 2 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 579 日本支部