Calculate Previous Year metrics in DOMO

yogesh_1 · October 2023

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.

GrantSmith · October 2023

You can have Domo configure a fiscal calendar and you can then use the standard period over period charts:

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

Alternatively I'd recommend utilizing a custom date dimension where you can a define your fiscal years and also custom offsets. I've written up an article on how to do this here:

https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

GrantSmith · October 2023

You can have Domo configure a fiscal calendar and you can then use the standard period over period charts:

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

Alternatively I'd recommend utilizing a custom date dimension where you can a define your fiscal years and also custom offsets. I've written up an article on how to do this here:

https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

Calculate Previous Year metrics in DOMO

Best Answer

Answers

Categories