Line Graphic with YTD Data (cumulative total each month)

bp_paulo_fernandes

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

etc...

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?

MarkSnodgrass

@bp_paulo_fernandes have you looked at @GrantSmith 's post regarding running totals in beast mode?

https://dojo.domo.com/discussion/52681/domo-ideas-conference-beast-modes-running-totals#latest

He lays this out pretty nicely.

bp_paulo_fernandes

Wonderful!!!!!!!!!

Thank you very much!!!!!