Mastering Tableau Date Calculations | For Intermediate Users

Connect with us!
•Subscribe to the OneNumber Newsletter: 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: www.eventbrite.com/o/onenumbe...
------
Access the Tableau Workbook Referenced:
public.tableau.com/profile/er...
Access all the calculations here:
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

[@onenumbertableau]

Need help writing your date calculations? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163

[@omelturk4609]

Great Job Eric! Thank You!

[@onenumbertableau]

I'm glad it was helpful!

[@romanvasiura6705]

Thank you for this video 🤠

[@onenumbertableau]

Sure thing!

[@hoangthanhle2505]

this video is amazing!!, keep it up Eric
Waiting for other mastering topics!!!!!!!

[@onenumbertableau]

Thank you so much!

[@parthivsinhgohil1228]

Hi could you please make a vlog on how to exclude weekends between Start date and End date? I have seen your how to exclude weekend video that was awesome!!

[@onenumbertableau]

Hi Parthivsinh. Do you mean to exclude weekends entirely? Or just to only compare the difference between a start date and end date in business days? If you're looking for the latter, this may help. Business Date Calendar: ua-cam.com/video/EW5noebAT7Q/v-deo.html&ab_channel=OneNumber-TableauExperts, Otherwise, you can calculate weekends like this and then filter them out of your visuals: onenumber.biz/blog-1/2021/11/28/how-to-calculate-weekends-in-tableau

[@michafabich4372]

amazing explanation

[@onenumbertableau]

Thank you Michal!

[@NyxView]

Insightful!!
Can you make a video on the difference between Data Blending and Cross Data base joins?
Keep posting...

[@onenumbertableau]

Funny you ask, we just published a video surrounding that topic yesterday! ua-cam.com/video/mhzi65CnM9w/v-deo.html&ab_channel=OneNumberLLC

[@brookedavison1043]

Hello, Realy enjoyed this Video! Very useful. Do you know how i could fix TODAY() to the max date in the dataset? My dataset is always a month behind. Thank you Brooke

[@onenumbertableau]

Thank you Brooke! Yep, the easiest way to do that is with a Level of Detail expression. Here's a post on how to do that: onenumber.biz/blog-1/2018/8/15/using-tableau-to-only-display-data-from-the-latest-date