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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
