Тёмный

#Tableau 

Andy Kriebel
Подписаться 65 тыс.
Просмотров 15 тыс.
50% 1

In this tip, I take you through the 5 most common date functions in Tableau:
1. DATEPART
2. DATENAME
3. DATETRUNC
4. DATEADD
5. DATEDIFF
By the end of this video you will understand when to use them to meet your use case.
Here's a link to the cheat sheet - docs.google.com/presentation/...

Наука

Опубликовано:

 

1 сен 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 59   
@olamideogundiran6892
@olamideogundiran6892 Год назад
Amazing andy. such a blessing to the tableau community
@SSJwalker
@SSJwalker Год назад
Agree
@vaibhavkamble3325
@vaibhavkamble3325 3 месяца назад
You are underrated sir. I like your content.
@vizwiz
@vizwiz 2 месяца назад
Share away! That helped even more people learn. 👍🏻
@romanvasiura6705
@romanvasiura6705 Год назад
Andy, thank you! Great channel and amazing advices)
@hnjonesf
@hnjonesf Год назад
Cheat sheet is a simple and powerful way to communicate. Great idea.
@peacelovebella09
@peacelovebella09 5 месяцев назад
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
@vizwiz 5 месяцев назад
Great to hear!
@longyanchen3755
@longyanchen3755 Год назад
Amazing video, thanks a lot Andy. I feel much more confident to use them now😊
@vizwiz
@vizwiz Год назад
Yay!!
@engineermajidd
@engineermajidd 5 месяцев назад
Hats off to you!
@DrJuanTaco
@DrJuanTaco Год назад
Thanks Andy! Your videos are great!
@vizwiz
@vizwiz Год назад
My pleasure!
@macc4544
@macc4544 Год назад
This channel deserves at least a million subscribers
@vizwiz
@vizwiz Год назад
Spread the word! 😊
@ramkrishna133
@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
@vizwiz Год назад
Thank you.
@alainponroy2621
@alainponroy2621 Год назад
Thank you Andy for this very interesting video 😀 mastering dates is so important in Tableau, your help is really appreciated
@vizwiz
@vizwiz Год назад
My pleasure.
@1973youness
@1973youness Год назад
Thanks .... Once again Andy Very well explainedd !
@vizwiz
@vizwiz Год назад
Very welcome
@TalhaParkarTech
@TalhaParkarTech Год назад
Thanks a lot! This was helpful!
@vrdsp1
@vrdsp1 Год назад
Thank You Andy 🙂
@vizwiz
@vizwiz Год назад
My pleasure!
@prashantyadav6915
@prashantyadav6915 Год назад
Awesome Andy 👍🤞
@apaumichael954
@apaumichael954 Год назад
Thanks Andy
@leoooo11646
@leoooo11646 Год назад
That cheat sheet is awesome!!!
@vizwiz
@vizwiz Год назад
Thank you. I’m glad you find it useful. 👍🏻
@pardhasaradhik9234
@pardhasaradhik9234 Год назад
Andy your best tutor , thank you somuch
@vizwiz
@vizwiz Год назад
I appreciate that 👍🏻
@PradeepKumar-wi4ws
@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
@vizwiz Год назад
Thank you
@JD_018
@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
@jakubg1267
@jakubg1267 Год назад
Really nice video Andy! It's getting a bit more complicated when we want to exclude weekends.
@FamilyDad5760
@FamilyDad5760 5 месяцев назад
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!!
@wwpharmacist
@wwpharmacist Год назад
Awesom
@jordantoups3248
@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
@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.
@ronenTheBarbarian
@ronenTheBarbarian Год назад
Thanks Andy! Great video. Can you do a simple LOD vs window_functions video?
@vizwiz
@vizwiz Год назад
What do you mean? What’s the use case?
@CerealMJ
@CerealMJ Год назад
Very helpful!! Question: shouldn't the "Is Delayed" calculated field be > 0 and not less than?
@ranadeepghosh1891
@ranadeepghosh1891 Год назад
I also have the same question
@vizwiz
@vizwiz Год назад
Could be. Either way, you get the idea.
@ranadeepghosh1891
@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.
@MissTopDJ007
@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
@vizwiz Год назад
Because the second part of the function requires a date field. Have you tried makedate to change your month # to a date?
@manishagrawal417
@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
@vizwiz Год назад
Your starting day of week is probably Sunday. Mine is Monday.
@angelinajames9230
@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
@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
@angelinajames9230 Год назад
@@vizwiz Thanks a lot ... 👍
@25070410
@25070410 5 месяцев назад
Thanks for the video. But cheat sheet is not accessible any longer.
@vizwiz
@vizwiz 4 месяца назад
Fixed! docs.google.com/presentation/d/1j-GiwmWOhSCF4GqHfM-M3910OjrXWTL9/edit?usp=sharing&ouid=109813978585042026440&rtpof=true&sd=true
@aniketjamode5290
@aniketjamode5290 Год назад
What is Start of week in datepart function?
@vizwiz
@vizwiz Год назад
Datepart(‘day’,[Date]) = 0
@markkligman7177
@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
@vizwiz Год назад
Got it 👍🏻 Thanks for the feedback. The more recent videos should have a better pace.
@andriykabanets4493
@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
@vizwiz Год назад
Yes that’s correct. In the video I say datepart returns an integer and datename returns a string.
Далее
#Tableau - Logic Functions
8:09
Просмотров 11 тыс.
▼КОРОЛЬ СОЖРАЛ ВСЕХ 👑🍗
29:48
Просмотров 445 тыс.
Построил ДЕРЕВНЮ на ДЕРЕВЬЯХ!
19:07
How I Calculate Day Over Day Change in Tableau
11:44
Просмотров 15 тыс.
Create 10 ACTIONABLE & IMPACTFUL KPIs in Tableau
15:28
Лучший браузер!
0:27
Просмотров 665 тыс.
iPhone 16 - 20+ КРУТЫХ ИЗМЕНЕНИЙ
5:20