YOY reporting based on Fiscal Week

scpradhan
scpradhan Member
in Charting

Can we create a YOY card similar like this

image.png
image.png

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.

Answers

  • ArborRose
    ArborRose Coach

    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



    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • MichelleH
    MichelleH Coach

    @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.

Categories