John Posted June 10 Share Posted June 10 Is there a way i can change the workweek from Monday to Sunday. Thanks! Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted June 10 Share Posted June 10 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 Link to comment Share on other sites More sharing options...
John Posted June 11 Author Share Posted June 11 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! Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted June 11 Share Posted June 11 (edited) 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 Link to comment Share on other sites More sharing options...
503399170 Posted August 26 Share Posted August 26 You may simply use this below calculated column to change it case WHEN DayOfWeek([filename_date])=0 THEN Week([filename_date]) - 1 ELSE Week([filename_date]) END making sure that the format for column [filename_date] is MMMM dd, yyyy 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now