Calculate Previous Year metrics in DOMO

yogesh_1 Member
edited October 17 in Magic ETL

I have a requirement to calculate previous year's data (in monthly format - Month Over Month).

So if user selects Fiscal year 2023, he should be able to get data for 2022.

Only catch is that 2023 means Oct-22 to Sep23.

So 2022 would mean data comparison between Oct-21 to Sep22.

Any help would be greatly appreciated.


Best Answer