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

vijayanotny_123 · 2025-02-14T08:35:03+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

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

All comments

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