Mastering Tableau Date Calculations | For Intermediate Users

Connect with us!
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric Parker on LinkedIn:   / eric-parker-37513249  

Thanks for checking out this video! To learn more, check out our upcoming classes, webinars and office hours here: https://www.eventbrite.com/o/onenumbe...
------
Access the Tableau Workbook Referenced:
https://public.tableau.com/profile/er...

Access all the calculations here:
https://onenumber.biz/blog-1/2021/4/1...

Description:
Tableau provides flexibility when working with dates, but sometimes getting it to do exactly what you want requires a custom touch.

We've built multi-day courses surrounding calculations in Tableau, and for this 30-minute webinar, we've distilled the highlights of the "Date Calculations" chapters.

If you've ever gotten stuck writing date calculations, join us for this webinar, and come prepared with your own hurdles for the Q&A at the end.

Here are some examples of what we'll be covering:
0:00 Intro
4:15 Year to Date vs. Previous Year to Date
12:12 Month to Date vs. Previous Month to Date
15:15 Week to Date vs. Previous Week to Date
17:27 Month Over Month (LOOKUP) Comparisons
22:00 Max Date Filtering (FIXED LOD)
29:22 Quarter to Date vs. Previous Quarter to Date
32:42 How to Account for Leap Day in Year to Date
34:00 Comparing Year over Year Progress
22:00 Keeping Data only From the Latest Date (in a data set)
If time permits:
Dynamic Date Parameters
32:43 Accounting for Leap Years in Year to Date Calculations
37: 22 Calculating Against "Hidden" Data
42:05 Calculations for Fiscal Years
47:49 Eric's Secrets