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
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!!
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EW5noebAT7Q.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
Funny you ask, we just published a video surrounding that topic yesterday! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mhzi65CnM9w.html&ab_channel=OneNumberLLC
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
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
