forums

Use these forums to ask questions and discuss Tableau.

Shifting Day for Start of Week

Posted December 6th, 2007 by brentyak
in Dates & Times

I have utilized a quick filter on a date field that is displayed and set to select a single value of a week number showing only those days for that week in the cross-tab. The problem I have is that the days of the week being displayed in the cross-tab start on a Sunday (eg. Nov 18 - 24 for Week 47) and I need it to start on the Monday (eg. Nov 19 - 25 for Week 47). Any suggestions?

Add new comment

Comments

On December 6th, 2007 brentyak said:

Solved it myself after much toying.
Created a Calculated Field that is discrete utilizing the following equation:
Date(DATETRUNC('week',[Date]))

reply
On May 7th, 2008 rblaiklock said:

I'm a new user and have some feature requests related to this ...

1. Our head office has the business week ending on Fridays. It would be nice to be able to specify the start (or end) day for the week for purposes of filtering/displaying data by Week Number.

2. Our financial month ends on the last Friday of each calendar month, so a month has either 4 or 5 weeks in it.
I'd like a Date filter option called FiscalMonth which would let me specify the logic for month end.
I need to play with creating a set to see if I can do it, but I suspect the logic to capture days at the end of last month will be tricky.

reply