Get startedGet started for free

Weekly truncations

Often, business reports are run on a weekly to monthly basis with a set date pattern (e.g. run on the Monday of every week).

However, there can be times where a faulty date is added to the report due to human error or some other cause.

How might we correct this? Through the usage of DATETRUNC(). Let's see how we can identify these changes!

If you lost progress, load the workbook 2_2_date_truncation_weekly.twbx from the Workbooks folder on the Desktop.

This exercise is part of the course

Time Series Analysis in Tableau

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise