Tableau ISO week

https://en.wikipedia.org/wiki/Talk%3ASeven-day_week

Week in Tableau is not the european ISO week. Calculate it yourself in a variable

ROUND((DATEADD('day', 3, DATETRUNC('week',[Date]))-
DATEADD('day', 3, DATETRUNC('year', DATEADD('day', 3, DATETRUNC('week',[Date])))) +
DATEPART('weekday', DATEADD('day', 2, DATETRUNC('year', DATETRUNC('week',[Date]))))
-4) / 7 + 1,0)

Source: Falsche Wochennummer für europäische Gebietsschemata | Tableau Software

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s