#Tableau

[@olamideogundiran6892]

Amazing andy. such a blessing to the tableau community

[@SSJwalker]

Agree

[@macc4544]

This channel deserves at least a million subscribers

[@vizwiz]

Spread the word! 😊

[@jordantoups3248]

For the DATEDIFF Days Delayed example, I think you said the the logic backwards (starting around 8:10). It looks like the first order was actually shipped 1 day early (on September 18, 2021 instead of September 19, 2021), not delayed by 1 day. On the third line, the product was expected to be shipped September 20, 2021, but was not shipped until October 6, 2021 (making it delayed by 16 days). ** I am still trying to learn so please correct me if I am wrong, but I want to make sure I am comprehending correctly. Thanks for all your work, Andy!

[@jordantoups3248]

Then in the final calculation for "which weekdays have the most delays", it seems you used the logic of negative days = delayed orders, which is what I was thinking.

[@andriykabanets4493]

Thank you for this video, great explanation as usual ) To make calculation based on integer comparison is better to use DatePart - always returns Integer Task Case: Select all the orders with the ShipDate after 10th of each Month: // iif([DateName_Day] > 10,'Ship after 10th','Other') // >> returns mistake message - can't compare string and integer values // until type conversion will be applied: // iif(INT([DateName_Day])>10,'Ship after 10th','Other') // While DatePart works well from the start: iif([DatePart_Day]>10,'Ship after 10th','Other')

[@vizwiz]

Yes that’s correct. In the video I say datepart returns an integer and datename returns a string.

[@peacelovebella09]

Thank you so much!! Was looking for help with date diff for so long and this was by far the most straightforward and helpful explanation

[@vizwiz]

Great to hear!

[@sowmya6471]

It was very easy to understand on the date function and effective.

[@ramkrishna133]

Thank you Andy for the amazing introduction to the different date functions. I always used to struggle with date functions. Your video and cheat sheet really helps to simplify a lot of things. You are a gem 😊 Also, kudos to the video editing, it looks very refreshing and cool 👍😊

[@vizwiz]

Thank you.

[@PradeepKumar-wi4ws]

Thanks andy , for yr great efford, labour , u are the blessing of people that standing in the last of the row . Made by abs( ❤❤❤) . #india .

[@vizwiz]

Thank you

[@1973youness]

Thanks .... Once again Andy Very well explainedd !

[@vizwiz]

Very welcome

[@CerealMJ]

Very helpful!! Question: shouldn't the "Is Delayed" calculated field be > 0 and not less than?

[@ranadeepghosh1891]

I also have the same question

[@vizwiz]

Could be. Either way, you get the idea.

[@ranadeepghosh1891]

@@vizwiz i have been following u for a long time and i look forward to ur videos. Watever i have learnt in tableau its all bcoz of u. I adore ur technical skills and i tell this to everyone. Keep making videos and help us to be good at it.

[@pardhasaradhik9234]

Andy your best tutor , thank you somuch

[@vizwiz]

I appreciate that 👍🏻

[@hnjonesf]

Cheat sheet is a simple and powerful way to communicate. Great idea.

[@longyanchen3755]

Amazing video, thanks a lot Andy. I feel much more confident to use them now😊

[@vizwiz]

Yay!!

[@alainponroy2621]

Thank you Andy for this very interesting video 😀 mastering dates is so important in Tableau, your help is really appreciated

[@vizwiz]

My pleasure.

[@vaibhavkamble3325]

You are underrated sir. I like your content.

[@vizwiz]

Share away! That helped even more people learn. 👍🏻

[@leoooo11646]

That cheat sheet is awesome!!!

[@vizwiz]

Thank you. I’m glad you find it useful. 👍🏻

[@romanvasiura6705]

Andy, thank you! Great channel and amazing advices)

[@DrJuanTaco]

Thanks Andy! Your videos are great!

[@vizwiz]

My pleasure!

[@FamilyDad5760]

Andy, this is very helpful! Can you address how or if the values would change if you change the Fiscal Year Start feature to say October? Or how to otherwise manipulate the dates vis-à-vis a Fiscal Year. Thank you!!

[@vrdsp1]

Thank You Andy 🙂

[@vizwiz]

My pleasure!

[@prashantyadav6915]

Awesome Andy 👍🤞

[@JD_018]

Hi Andy, amazing video. Is there a method I can use to control say order date and return date using a single date parameter? I want to do a count of both orders and returns using the corresponding date field but using a single date parameter. Many thanks

[@ronenTheBarbarian]

Thanks Andy! Great video. Can you do a simple LOD vs window_functions video?

[@vizwiz]

What do you mean? What’s the use case?

[@apaumichael954]

Thanks Andy

[@engineermajidd]

Hats off to you!

[@manishagrawal417]

Hello !. Amazing as usual. But one thing caught my eye. The datepart - Week is shown as 38, however, as I checked my outlook calendar shows week num as 37. Please shed some light on this.

[@vizwiz]

Your starting day of week is probably Sunday. Mine is Monday.

[@jakubg1267]

Really nice video Andy! It's getting a bit more complicated when we want to exclude weekends.

[@25070410]

Thanks for the video. But cheat sheet is not accessible any longer.

[@vizwiz]

Fixed! docs.google.com/presentation/d/1j-GiwmWOhSCF4GqHfM-M3910OjrXWTL9/edit?usp=sharing&ouid=109813978585042026440&rtpof=true&sd=true

[@TalhaParkarTech]

Thanks a lot! This was helpful!

[@MissTopDJ007]

I have a data source that shows the MONTH Column in integers. So when I tried to use the Calculated Field DATENAME('month', MONTH) it converts to DATENAME('MONTH!,MONTH) and it won't change the month numbers to month names. Why is that?

[@vizwiz]

Because the second part of the function requires a date field. Have you tried makedate to change your month # to a date?

[@aniketjamode5290]

What is Start of week in datepart function?

[@vizwiz]

Datepart(‘day’,[Date]) = 0

[@angelinajames9230]

Thanks for this helpful video. This is exactly i what I wanted... I struggle a lot with date functions. Could you please make a video on MAKEDATE and how to create a date field when we don't have any date . Kindly help me on this

[@vizwiz]

Makedate needs three numbers passed to it. Year,month,day. So if you want to make up a date, you could have MAKEDATE(2022,9,1) to get September 1, 2022

[@angelinajames9230]

@@vizwiz Thanks a lot ... 👍

[@wwpharmacist]

Awesom

[@markkligman7177]

If I may say one thing, it would be nice if everything done was a tad slower. Between the quick talking and fast movement and clicks, its difficult to follow.

[@vizwiz]

Got it 👍🏻 Thanks for the feedback. The more recent videos should have a better pace.