Tableau Tutorial - Practical LOD #12 - Relative Period Filtering (YTD, QTD, MTD, YoY) (Part 4)

[@SummerWasGone]

Those are the best video I've found on Tableau LOD expressions. Thank you so much! Everything is explained in such a clear and thorough way and the examples are most useful. I've watched quite a number of videos so far but only after yours I've got a clear understanding of how LOD really works.

[@chanuchan2765]

You remind me of my favourite teacher in school , friendly lecturer at college and the best professor in my university. Simple , straight and superb explanation . Thank you Belle

[@sqlbelle]

Thank you Chanu :)

[@ExilesAnalysis]

You have an incredibly digestible way of presenting concepts and solutions, thank you 🙏

[@sqlbelle]

Thank you!

[@jnhay]

Thanks!

[@sqlbelle]

Thank you jnhay, much appreciated!

[@mohammedaltantawi1545]

Impeccable delivery, as always. We're lucky to have you!

[@sqlbelle]

Thank you Mohammed!

[@agermoune]

Worth the wait! You did it again with a great comeback :-) Watched the whole video while exercising on the Stair Master at the gym. Didn't see 40 minutes go that fast. I will have to watch it again for sure. Thank you!

[@sqlbelle]

Thank you Abderrahim! I sincerely appreciate your support and your every thoughtful comment. I take your suggestions to hear, and I am happy to hear you find the videos helpful. I hope you and your family are all doing well.

[@shashankworldpeace]

A very imp and practical use case is discussed, great work. Also thanks for highlighting the corrections in shorts :) Always looking forward to your learnings!

[@sqlbelle]

Thank you Shashank!

[@tailethanh8074]

really really informative video, learn a lot from it. THANKS.

[@yifanyu6554]

I feel like the Leap Year Day of Year condition if simply using the +1, would it also change the day of year for Jan? (in this example, 2018, 2019 and 2021, the first day of year would be 2 whereas the first day of year of 2020 would be 1)

[@sqlbelle]

You are absolutely right!!!! I can't believe I missed that. I had another version where I had another condition where I considered the month but somehow I missed it in the edit. IE if leap year and month > 2 .... Thank you Yifan, you are right. hmm now I need to figure out how to correct this video.

[@krishnasharmacool]

Hi, the way you explain is so good, thanks a ton.

[@sqlbelle]

Thank you Krishna!

[@dhruvzanzrkiya6801]

PLease create a video on how to calculate YoY,QoQ,MoM,WoW, pleaseeeeeeee

[@sqlbelle]

Will do! :)

[@akshayravi1629]

Thanks a lot Belle !! You are the best !! Would love to have a Q and A session !!

[@sqlbelle]

Thank you Akshay :)

[@chetanms1270]

You just explained everything very well.. learnt so much things! Thank you!!

[@sqlbelle]

Thank you Chetan!

[@ailn-ug4jn]

ञ़पर ऑॉॉॉॉॉॉ

[@AdrianaPerez-ev5cj]

You are a great teacher!!

[@sqlbelle]

Thank you Adriana! Happy New Year!

[@SachinKumar-qo6ut]

Thanks for your effort , it is very informative and useful.

[@sqlbelle]

Thank you Sachin!

[@tattwatripathy3619]

Great video. Please make a video about how to calculate YoY,QoQ,MoM,WoW when we are dealing with an aggregated field like profit ratio using LODs instead of a table calc.

[@sqlbelle]

Thank you!

[@yvettecordero1813]

Amazing thank you so much!!!!

[@hanmanthkageru7870]

So detail video thank for sharing

[@sqlbelle]

Thank you Hanmath

[@michafabich9213]

very informative, thank you

[@sqlbelle]

Thank you Michal :)

[@black920135]

Amazing video!!! Thank you so much!!

[@sayakpalit3615]

Very helpful tutorial.. 👍👍

[@sqlbelle]

Thank you Sayak!

[@shivangsharma2329]

by creating the calculated field(within date range ,time - 9:33),error is popping up - "cannot mix aggregate and non-aggregate arguments with this function. why and what to do?kindly help, btw i'm using the superstore dataset which is updated(as it showing year from 2020 to 2023).

[@giuliko]

Awesome lessons as always. Thank you.

[@sqlbelle]

Thank you Guiliko!

[@madhugadodia5250]

You are the best!

[@sqlbelle]

Thank you Madhu!

[@gnomesukno]

Very useful 👍 great job

[@sqlbelle]

Thank you Chris!

[@cococnk388]

Thanks sqlbelle

[@AliciaMarkoe]

Thank you 🦋

[@paulocarapinheiro8739]

Excellent, thank you. Regards.

[@sqlbelle]

Thank you Paulo!

[@angelinajames9230]

Very useful... thank you

[@sqlbelle]

Thank you Angelina

[@sandrahu7122]

As always, you delivered the best. I have one thing can't solve on my own, when I dragged the year to the color panel, the filter is scale, not a color button, I don't know how to fix it.

[@sqlbelle]

Hi Sandra! You can change the year to a blue pill (Discrete), and it will give you access to the discrete colors (not gradient)

[@MrStark-zy6cd]

Great, really appreciate!!!!

[@sqlbelle]

Thank you Mr Stark :)

[@gritmanish]

Thank you

[@farrukhkidwai]

You are just awesome

[@sqlbelle]

Thank you Farrukh!

[@himachaudhary5531]

Very well explained! Thank you so much, incredibly helpful However, I coudn't get MAKEDATE function to work with a live connection. Is there a way around it?

[@MrOmaralamri]

Beautiful , thanks 🙏

[@sqlbelle]

Thank you Omar!

[@YusrilSabillaAshar]

thank uu for your amazing video, but after follow your instructions, why my choose duration can't move from YtD to QtD and MtD??

[@peterparker4358]

Nice one really nice 👍 leap year issue I will not address as it has been corrected anyway🙂👍 thanks for posting 😃

[@sqlbelle]

Thank you Peter!

[@user-re5uv2mm2h]

Hi @sqlbelle, not related to the video, but... I have many tables and it has a column name "Client". The problem is I need to create a filter wherein ALL clients will be on that so whenever I filtered the dashboard, it will filter all tables. Not just depend the filter coming from one table only. Haven't tried that yet though, but I might need to get into that later...

[@agger0083]

Also for part 2. At the very start when you were solving the issue with having sperate lines for each year (creation of the normlaised order date) ? Why couldnt we just place week number on the axis like we did in part 1 ? Was thias just hsowing us another way of doing the samething ? Edit I feel like you did it a different way in part 2 becuase we will be using parameters ?

[@leonguyen3264]

I have a question about the Leap year issue. From your Field Calculation, for Non-leap Year, we add 1 to the DayOfYear. But the discrepancy only starts from 02/29. Eventhough adding 1 will create the discrepancy from 01/01 to 02/29, because it is now off by 1?

[@tonylu718]

Wonderful presentation - clear yet concise. When I dragged the second instance of the same measure (my own workbook) to the table nothing happened. Any idea why?

[@sqlbelle]

You will need to ensure that these are two different measures first. For example, make sure the first instance has a table calculation first (hence transforming it into a different measure) before dragging a second instance of that measure.

[@yomama20000]

Is there a workaround for MAKEDATE function for a "Live" database? MAKEDATE function isn't available for live connections.

[@KaunteyaShaw]

Hello, can you plase share the link to the workbook? Thanks in advance, @sqlbelle !

[@chao-chienchen4393]

Hi, I am 2 years late to this amazing tutorial, but hopefully you notice my question. I followed along with my own datasets, and I found that if `quick table calculation - different from` contains NULL, the bar/area chart below will not show. for instance, 2017 || 10 | 20 | | | 2018 || | 10 | 30 | | The table calculation will results in some weird empty area. Is it possible that I make NULL values into 0s? Much appreciated!

[@agger0083]

hmmm. Whats the reason for making max record date fixed ? how would it change if we only aggregated it to max order date without fixing it ? Thanks !

[@sqlbelle]

Thanks. If we use the "regular" aggregation, it means that the field will respond to the level of detail of the view - for example if you add dimensions, or add filters etc - all those will influence the "max date". So a "max date" can become "max date" per category, per subcategory, per date range selected etc.

[@agger0083]

@@sqlbelle thanks for replying. I learned by trying to answer my own question, and found out. I guess I'm à real « Learn by doing » person :) Merci.

[@sqlbelle]

@@agger0083 That's great, thank you :)

[@yanjihadi8529]

Hi, I wanna ask how to calculate Ytd growth? for example (stock price in 13/02/2022-stock price in 30/12/2021)/stock price in 30/12/2021)*100. I confused what's the formula to calculate it... I hope you can help me :)

[@sqlbelle]

Thank you Yanji - there is a Quick Tableau Calculation for YoY and YTD .. you will need to make sure you have a discrete date part fields in your view (for example, Year, Quarter and Month), and the YTD and YoY options should be enabled

[@sandrahu7122]

Would you be able to make the videos for the rest 3 LOD? 13-15

[@sqlbelle]

Thank you Sandra, I will!

[@BenCombes]

Great video - just wondering how I would incorporate the leap year adjustment into the YTD, QTD, MTD example that you provided? Thanks

[@BenCombes]

Also - how could we compare say 3Q 2018 to 3Q 2017, or 2Q 2017 to 2Q 2016 given that the quarter to date is based on the most recent records that might not fall in those quarters? Thanks!

[@RIVASCOSTA]

Hello Belle, I am having a problem, when I am trying to create "Normalized Order date" tableau is showing a error = Cannot mix aggregate and non-aggregate arguments with this function. I understand it, because I choose YEAR from MAX RECORD DATE it is a aggregate value, and Month and Day from normal Order date they are non-aggregate arguments. Do you know how to fix it? I really appreciated your videos. Thank you so much.

[@themantien]

Why do you use the LOD max order date instead of just doing a normal max order date?

[@sqlbelle]

It depends on whether you want an "absolute" max date. A "regular" aggregated max date will be influenced/affected by the dimensions in a canvas, so there is no guarantee it wont change.

[@nimrodzaphnath5495]

Note to self in 79 years: remember that leap years are ignored if the year is divisible by 100, so write a special case for that in your logic.

[@sqlbelle]

Great point.

[@ismailshaikh1741]

Very nice teaching mam..... But you didn't practiced LOD 13,14,15 😀..... Please give us the explanation 👍

[@yashlokhande2859]

@sqlbelle Can you please create a dashboard containing bins, sets, groups, parameters ?

[@ballyb1]

How to show To date period differences by Category/Subcategory? when I drop in categories it only shows the total overall difference per line not by individual category/sub-category. I followed this video: kzbin.info/www/bejne/h4Sshpegm9preJI Appreciate any help on this as not sure how to fix it?

[@anthonyburns7278]

Thanks!

[@sqlbelle]

Thank you so much Anthony!