Custom YOY Seasonal Calendar year

My company runs events twice a year, Spring and Winter.

However, these events do not start on the same day every year.

I am looking for a way to do Custom YOY dates in the cards so that I can compare this year with last year or the year before without needing to calculate each year's comparison data into each row using the ETL.

I would like to compare that automatically to a specific date last year instead of using the generic YOY provided in Analyzer.

I have a table with the specific dates. Wondering how to achieve this since my company is seasonal and each event is spaced apart differently and not always starting on the same day.

We would want to compare Winter to Winter and Spring to Spring.

I'm ok to code if required, just need to know where to begin.

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Because how Domo processes data (row-based) and your need to have custom date offsets you'd need to utilize an ETL to process your data. Instead of using the date from 1 year ago to join on you can use the event and the year (this year event) = last year (last years event). This would allow you to compare the custom date offset YoY calculation.

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

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

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Because how Domo processes data (row-based) and your need to have custom date offsets you'd need to utilize an ETL to process your data. Instead of using the date from 1 year ago to join on you can use the event and the year (this year event) = last year (last years event). This would allow you to compare the custom date offset YoY calculation.

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

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