emergingbytes.com Technology blog for data warehousing, business intelligence, iPhone Apps Development, Android Apps development and facebook applications

Tableau Get Last Week Automatically

Below is the snippet to get last week automatically for dashboards to show all days of last week or values from last week only.


[Week]=str(
DATEPART('week',
DATEADD(
'day', -8,
DATETRUNC('week',TODAY())
)
)
)


[Week] Dimension can be added in filters and in filters under condition above snippet can be used.