Calculate Previous Year metrics in DOMO

yogesh_1

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.

Input:

Sales Date	Amt
10-01-21	10
11-01-21	20
12-01-21	30
10-01-22	60
11-01-22	70
12-01-22	80

Output: User Chooses 2023 as year

	Month
	Oct-22	Dec-22	Dec-22
Current Year	60	80	80
Previous Year	10	30	30

Something like this. User have flexibility to choose the Year.

pauljames

@yogesh_1 Here is a post I answered a few weeks ago. You can manually in the date filter select date range then a compare to date range.

https://community-forums.domo.com/main/discussion/comment/78715#Comment_78715

pauljames

@yogesh_1 Here is a post I answered a few weeks ago. You can manually in the date filter select date range then a compare to date range.

https://community-forums.domo.com/main/discussion/comment/78715#Comment_78715