YOY reporting based on Fiscal Week

scpradhan · 2024-11-08T18:39:53+00:00

There was an error rendering this rich post.

Can we create a YOY card similar like this

But based on the date range selected 10/20 to 10/26 which is fiscal week 43. It should compare the previous year fiscal week 43 which is date range 10/22 to 10/28. Currently, what is doing is it is comparing the same date range for 2023 (10/20/2023 to 10/26/2023).

Is it possible to do in Domo in this view.

Find more posts tagged with

Accepted answers

All comments

ArborRose

Creating a Year-Over-Year (YOY) card that compares fiscal weeks, rather than calendar dates, requires some custom adjustments because the default behavior will match the same calendar dates across years, not the same fiscal weeks.

Make sure your dataset has a field for the fiscal week and year. This allows you to create a calculated field that maps each date to the correct fiscal week in both the current and previous years. Then a calculated field something like

CASE 

  WHEN `Year` = YEAR(CURRENT_DATE()) THEN `Value`

  WHEN `Year` = YEAR(CURRENT_DATE()) - 1 AND `FiscalWeek` = <CurrentFiscalWeek> THEN `Value`

END

MichelleH

@scpradhan There is a feature called Fiscal Calendar that you can use to filter and compare dates based on your company calendar. If you haven't already I'd recommend reaching out to your account team to get one enabled.