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

Options
vijayanotny_123
vijayanotny_123 Member
edited July 7 in Calculations & Variables (Beast Mode)

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

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    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

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • vijayanotny_123
    vijayanotny_123 Member

    Team,

    Please help, Provide some ideas

  • vijayanotny_123
    vijayanotny_123 Member

    Team,

    This needs to be done in BEAST Modes

    thanks

    M. Vijay Antony

  • b_rad
    b_rad Contributor
    edited February 14

    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
    DavidChurchman Coach
    Answer ✓

    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

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • vijayanotny_123
    vijayanotny_123 Member

    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,

    image.png

    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
    vijayanotny_123 Member

    Team,

    Please help on this

    regards

    M. Vijay Antony

Categories