I'm trying to set week beginning to Monday 8 am. Is this possible?
I know with: DATEADD('day', 1, DATETRUNC('week',DATEADD('day', -1, [timestamp]))) you can set the beginning to Monday. But my calendar week starts on Monday 8 am.
the dimension timestamp contains also hours, minutes and seconds.
The following should be able to help:
DATEADD('hour', 8, DATEADD('day', 1, DATETRUNC('week',DATEADD('day', -1, [Datetime]))))
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...