Need to show the last 12 months data along with previous year data

vijayanotny_123

Team,

Need to display last 12 months data with below calculations , Kindly guide on this,

Last 12 Months	Last 12 Months Data	Previous Year Months	Previous Year Data	Final Data Should Show in Chart
Feb-25	2	Feb-24	1	1
Jan-25	3	Jan-24	2	1
Dec-24	4	Dec-23	3	1
Nov-24	5	Nov-23	4	1
Oct-24	6	Oct-23	5	1
Sep-24	7	Sep-23	6	1
Aug-24	8	Aug-23	7	1
Jul-24	2	Jul-23	8	-6
Jun-24	3	Jun-23	9	-6
May-24	4	May-23	1	3
Apr-24	5	Apr-23	2	3
Mar-24	6	Mar-23	3	3

Finally i need to show Last 12 Months and Final Data Should Show in Chart columns data in Bar Chart,

Please help me on this

regards

M. Vijay Antony

DavidChurchman

Here's a recent discussion of someone working through the same issue:

https://community-forums.domo.com/main/discussion/69044/need-help-changing-to-last-12-months-and-sorting-in-proper-order#latest

vijayanotny_123

Team,

Please help, Provide some ideas

vijayanotny_123

Team,

This needs to be done in BEAST Modes

thanks

M. Vijay Antony

b_rad

My recommendation will be to do this in Magic ETL.

Otherwise you might want to refer this and see if it works for you.

https://domo-support.domo.com/s/article/360043430133?language=en_US

DavidChurchman

Here's a recent discussion of someone working through the same issue:

https://community-forums.domo.com/main/discussion/69044/need-help-changing-to-last-12-months-and-sorting-in-proper-order#latest

vijayanotny_123

Hi Team,

Thanks for the response,

I almost calculated all the columns in beast mode except find the difference between current year-month and previous year-month as below,

Example: 2024 Nov - 2023 Nov : 9,227,552.00-813,539.62 and the MOM_Difference should show : 8,414,012.38, same way need to do for other rows as well.

Thanks

M. Vijay Antony

vijayanotny_123

Team,

Please help on this

regards

M. Vijay Antony