Line Graphic with YTD Data (cumulative total each month)

bp_paulo_fernandes
bp_paulo_fernandes
in Charting

Hi People! I'm here again!

We have a dataset in DOMO like this:

image.png

And we need to create a vision like this:

image.png

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:

image.png

Actually with the growth percentage and will be 3 lines, comparing 3 years:

2022vs2021 | 2021vs2020 | 2020vs2019

image.png

Any ideas if it's possible?

Best Answer

Answers

Categories