Additional Functionality when charting by Week

RobertPenridge

When charting by week it would be nice to have the following additional options:

1. Ability to choose the method that determines 'Week 1'. For example, is it the first Monday of the year? The first Tuesday of the Year? The Tuesday that includes the 1st day of the year? Is it simply whichever date is the 1st day of the year? Many external systems use different approaches for calculating week, so the default domo week selection is usually not particularly useful.
   
2. The ability for weeks to show as date values on the Axis of charts. Rather than showing Week 1, Week 2, etc… it would show 1/1/2024, 1/7/2024, etc… For this you should also be able to choose whether you want it to show as the start date of the week, or the end date of the week.
   
   The current issue with showing Week 1, Week 2, etc… is that nobody knows what dates those periods cover. Did an important event happen that week that affected the data? Was there a bank holiday in that week? Unless you know how weeks are determined in Domo, you can't even back into the dates covered by the week, and that's too much to expect of everyone that could be looking at a card.

The above additional options would only show when using the date selector and choosing 'Week'.

This will results in many beastmodes being made redundant. As well as add really nice functionality that allows Domo to represent data in the same periods as the external systems it's pulling data from.

Thanks

JasonAltenburg

@RobertPenridge Great ideas! Wanted to add some info here for you or others that might find this thread:

For option 1, if your business has a rule for which day of the week your weeks start, or has specific week boundaries for a fiscal calendar, check out this article, Domo can get your fiscal calendar installed into your instance for use in charting: Using a Fiscal Calendar (domo.com)

I think for some charts part of Option 2 is already available by using the Date output format in the Chart properties, hopefully this is helpful!

I do think it would be nice to have those other options there too, to change whether starts/ends are displayed, and show some sort of week begin/end messaging alongside the axis.

RobertPenridge

Thanks for the tips Jason - definitely helpful.

While the fiscal calendar option is useful, unfortunately it doesn't address all our issues as we have multiple week starting methodologies that need to be shown. For example we have our fiscal week, then we also have a different week start for media spend. On a side note - we also changed our fiscal week at a certain point in time so we have our new fiscal week and our old fiscal week. We also deal with many external companies many of whom may also have their own week definitions that we may want to adopt when building charts.

JasonAltenburg

@RobertPenridge Whoa that sounds incredibly complex! With that context added really shows how implementing these ideas would help enhance the value your stakeholders would get from Domo!