Changing the Workweek

[John]

Is there a way i can change the workweek from Monday to Sunday. Thanks!

[David Boot-Olazabal]

Hi John,

Can you tell us on what level you are looking for a change in workweek?

Also, can you elaborate a bit more on what you want to achieve?

Kind regards,

David

[John]

Hi David, 

currently, when using the Year and Week Function in spotfire, I noticed that this is default from Sunday to Saturday, can I have a formula wherein the Workweek starts from Monday to Sunday? Thanks!

[David Boot-Olazabal]

Hi John,

Thanks for the explanation.
Normally, the starting day of the week is defined in the regional settings. So, if possible of course, that could be the first thing you may want to check.

Next, as I have found some articles around this topic, you can try one of those to change the starting day of the week:

- https://support.tibco.com/s/article/How-to-show-the-first-day-of-each-week-on-the-x-axis-of-a-chart
- https://support.tibco.com/s/article/How-to-set-the-First-day-of-the-Week-and-the-First-Week-of-Year-used-in-week-functions-in-Spotfire (Note that this isn't applicable as of Spotfire 11.7 though! And you need to calculate it.)
- https://support.tibco.com/s/article/With-scheduled-updates-the-first-day-of-the-week-in-the-visualization-is-always-showing-as-Sunday-irrespective-of-the-browser-regional-setting-in-Web-Player

Also, as of Spotfire 12.2, Spotfire offers ISO Year and ISO Week functionality (if that fits your use case):

Kind regards,

David

Edited June 11 by David Boot-Olazabal