Tableau Tutorial - Top 1-5 LOD Expressions - Practical Examples (Part 1 LOD calculations)

[@PatrickBateman12420]

Absolutely amazing Donabel! Thank you for sharing. You're 10X better at explaining than most paid video courses on LOD's.

[@sqlbelle]

Thank you Franco :) Glad to hear you found it helpful!

[@Nina20157]

i agree . she is best at explaining tha others..

[@manalrassas1566]

Amazing video, this video is a proof that you were born to be a data techniques teacher and also, the information flow in the presentation and screenshots (especially the one putting the Dimension filters in between the FIXED and INCLUDE/EXCLUDE) make the trainee memorize what is the difference between the different types in terms of filter effect and answer any LOD-related question in interviews. Thank you so much

[@sqlbelle]

Thank you Manal, for this very kind and thoughtful note. I appreciate it, and am happy to hear you found the video helpful!

[@Leo-pentos]

Your work for the tableau community is invaluable! Thank you.

[@michafabich4372]

I've been waiting impatiently for something new from you :)

[@sqlbelle]

Thank you Michal! 😅 yea I had a little bit of a break; semester was wrapping up so it's been hectic with marking 😇

[@prashantgupta6850]

I just can't tell how beautifully she has explained everything my all doubts related to LOD are cleared.

[@sqlbelle]

I am so glad to hear that @prashantgupta6850

[@chao-chienchen4393]

This is the best "practical" Tableau usage example by far!

[@Neutronumusprime]

Best Tableau training videos I’ve come across so far! Well done and thank you.

[@sqlbelle]

Thank you Jim! Glad to hear you found it helpful :)

[@jeffersonmazurdasilva2728]

Hi, I have been working in analytics for quite some time. I have worked both as a business analyst and as a BI developer. Also, I had the opportunity to work with the most know BI tools in the market. I have to say this is gold for two reasons: 1) with these analysis a business analysis a analyst can keep a sales or marketing team busy for a very long time. 😁 2) the way you present I am pretty convinced Tableau is (after Excel - 😅) the best tool for those working in the business side. Thank you for sharing

[@ytpariss309]

your way of teaching is simple yet deep, love it.. please do post more videos. I am preparing for my Tableau exam and your videos have been a great source for me to master. Thank you.

[@sqlbelle]

So happy to hear, Ytpari! Thank you so much for sharing!

[@agermoune]

Respect Donabell 👏 Just finished the first part and can't wait to finish this series. I will save them in my favorites for reference. Way simplified compared to Britney's original video. Again, I know how much time you put to make hard easy and hope that you can get more lucrative rewards than ‘likes and thank you’, So THANK YOU!

[@sqlbelle]

Thank you Abderrahim :) Always appreciate your thoughtful and kind feedback. Glad to hear you found it helpful :) Thank you, thank you, for your support and encouragement. Your comments, along with many other supportive positive ones, really motivate me. Take care!

[@SwethaNandyala-sf9lt]

Hi Donabel. I have a small question. at 26.21 when you toggle the segment the Grand Total and SUbtotal by region are not supposed to change but the Sales , % of Region total , % of Grand Total can change because the % of Region total , % of Grand Total depend on sum(sales) which is in turn affected by the "segment" dimension filter.

[@jilanikashif]

This is one of the best tutorial, simply loved it, also explaining pattern is simple, Thanks for sharing.

[@sqlbelle]

Thank you so much for your kind comment, Kashif! Glad you found the video helpful!

[@cococnk388]

LOD is very suitable for visuals and analytic questions.... great channel.

[@sqlbelle]

Thank you :)

[@fabianobiserra1210]

Thank you for keep teaching us Donabel! Loved you classes and more recently your youtube channel as well! Take care!

[@sqlbelle]

Thank you Fabiano! Hope all is well :)

[@AmitGrg_Rakhali]

Very clear and crisp explanation with great examples. Totally relatable. Thank you so much for this tutorial!

[@kranthikumar9231]

You are always the best in explaining. Waiting for more videos.

[@sqlbelle]

Thank you Kranthi!

[@vdn5716]

Great work As always..

[@charlesabboud1613]

What an extraordinary video following on from your wonderful introductory LOD video...Many thanks for sharing this. All the best Charles Abboud

[@sqlbelle]

Thank you so much for your kind comment Charles! So happy to hear you found this follow up video a complementary one to the introductory LOD :) Very much appreciate your time (watching and leaving a thoughtful comment :))

[@TexasGunDude]

I'm new to Tableau. Your videos have great content. I've learned so much from following you.

[@sqlbelle]

So happy to hear you are finding the videos helpful Phillip! Thank you for sharing it :)

[@Aynaras_Life]

Your explanations are very clear and on point. Thank you 😊

[@sooryaprakashverma6044]

Perfectly described the LOD...I request you to bring the video on hierarchies in tableau. I really love your playlist.

[@sqlbelle]

So happy to hear that, thank you Soorya!

[@kanikaarora368]

Great explanation! Please release second part soon

[@sqlbelle]

Thank you Kanika!

[@angelav7999]

One comment at minute 7:50: Why do we have the same numbers for every year at the most frequent level (17, 13)? I interpret this report as follows: one customer bought 17 orders every year. If I add customers to the tooltip, I see the one who bought 17 orders every year, which seems incorrect. Do you think the calculated field should be modified like this: {FIXED [Customer ID], [Year Order Date]: COUNTD([OrderID])}?

[@zeeshanahmed9719]

"we have the same numbers for every year at the most frequent level (17, 13)" 13 7 17 1 consider 13 first: For this row grand total is 7, it means there are 7 distinct customers each ordered through 13 distinct order IDs. and for every year countd(customerID) is 7, means all these 7 customers ordered in 2017, 2018, 2019 and 2020. Similarly for 17 1.

[@lavaforce-overwatchmoments9848]

Very deep and clear explanation, thanks a lot!!!

[@Yatish90]

This was brilliant! Kudos to you for making such comprehensive video's!

[@sqlbelle]

Thank you Yatish!

[@fazlayelahi29]

Ma'am, I don't know how to thank u. Best Wishes to u. God Bless u. Love from Bangladesh.

[@sqlbelle]

Aww. Thank you Fazlay, I hope this video was helpful for you. And your note is more than enough - thank you for taking the time to leave a comment. I appreciate it very much.

[@fazlayelahi29]

@@sqlbelle My Pleasure Ma'am, u r so much sincere. It's hard to learn a intuitive software like Tableau only from online resources. I am just a High School Graduate in Bangladesh, recently I got a lot of curiosity to Data Analysis that's why I started to learn Tableau. Thank u so much for your tremendous videos on Tableau. Your contents are just 10/10... Hopefully I will watch all of your videos and thus have a good ability on Tableau. Thanks again...!!! Best Regards.....!

[@vijayarjunwadkar]

Happy to see a video after gap, and the wait was worth it! Very nice explanation of LOD with practical examples, liked it! Awaiting next ones eagerly! Thank you Donabel! 😊👍

[@sqlbelle]

Vijay! Thank you, yes there was a little bit of a break 😅 I am trying to plan out the next videos now. Will be calculations heavy for the next little while. Thank you, as always, for your support! 😊

[@chukkeycheese]

You know tableau very well. Great video. Subscribed. Looking forward to learning more from you

[@sqlbelle]

Thank you Projesh!

[@shwetabharti5389]

I must tell you, through your videos i'm learning actual tableau

[@sqlbelle]

I am so glad to hear, thank you for sharing Shweta!

[@Guna_cocktail]

Another great presentation. thank you so much. awaiting for the next part.

[@sqlbelle]

Thank you Guna!

[@nallelybalderasacatitla9102]

wow I really love your videos. Your explanations are so easy to understand. In the past i did those exercises but i didn't understand some things but now i get it. Thank you so much for share.

[@sqlbelle]

Thank you so much for your comment Nallely - happy to hear you found the video helpful :)

[@anujtomar19]

Proper organized detailed video !! Thanks a lot !!

[@zeeshanahmed9719]

Thank you Ma'am, your explaination are excellent. I understood everything explained in the video except @ 30:00 in the acquisition trend chart, I got the same chart, but when I changed week (First order date fixed) to day(First order date fixed) to check the counts manually on Excel sheet, I see difference in the way in which countd(customer_id) and count(customer_Id) is calculated. countd(customer_id) calculation is intuitive and it counts distinct customer_id on that particular date only. whereas, in count(customer_id) calculation it counts all rows of that customer_id including the particular date as well as other dates. Please explain why count(customer_id) counting rows of customer_Id for other dates also?

[@Vikasgadre]

Simply fantastic. very very useful video

[@sqlbelle]

Thank you Vikas!

[@AliTwaij]

This is amazing. Really impressive. Thankyou v much

[@Nick-xu2hh]

You are very quickly becoming my number one go to for help 😃. Really really good content and explanations

[@sqlbelle]

Thank you Nick :)

[@sayandas1826]

Best tutorial available on the web regarding LOD. I have subscribed to your channel for future guidance. But a little upgradation may help visualization of videos. Your channel logo overlaps several times which is an obstacle to visualization.

[@sqlbelle]

Thank you Sayan! And thank you for the suggestion! I just realized that as well too, and will make sure to make adjustments next time. Thank you :)

[@oluremiabayomi5924]

Thank you for your videos. I am very very grateful!

[@sqlbelle]

Thank you Oluremi, I hope you found them helpful

[@rajeshtukdeo]

Absolutely informative and easy to understand !!

[@sqlbelle]

Thank you Rajesh!

[@saurabhkhare3315]

Amazing Donabel! Your lectures are really helpful to get crystal clear understanding of Tableau Concepts. Your simple amd effective approach of explaining concepts are really cool. Will be waiting for new upcoming videos on SQL & Power BI. Love from Indian BI Developers & Happy New Year

[@sqlbelle]

Thank you Saurabh!

[@swathikilaru]

Very well explained ,Thank you so much mam

[@PawanKumar-bt7vo]

Easy to understand...please make more videos...Could you Please one video on Tableau Bridge

[@sqlbelle]

Thank you Pawan! And thank you for the suggestion!

[@ajaykulkarni576]

how are you writing FIXED and other TEXT with your mouse for annotation? i use presentity as well, but not sure how you write with it. do you use any digital tablet and a pen to write it ? (time at 16:03 where you write FIXED)

[@sqlbelle]

Thanks Ajay. I use a free tool called ZoomIt from Microsoft.

[@ram_qr]

(11:43) Why we cannot use Cohort-Fixed = {FIXED [Customer ID]: MIN([Order Date])} ? The result is the same as shown in this video

[@sqlbelle]

Thanks. The result is slightly different, and may affect other use cases. MIN([Order Date]) returns an exact date field. May not be obvious when you drag this because Tableau rolls up to YEAR right away. MIN(YEAR([Order Date])) returns an integer. In the specific use case in the video - may not matter since we are just displaying. For other calculations, it will.

[@nadeemraja655]

thx for the series of LOD much needed.

[@sqlbelle]

Thank you Nadeem, hope you will find it helpful

[@nadeemraja655]

@@sqlbelle I could not find 6-10 or 2nd part. thx

[@garyv2500]

Excellent video, honestly

[@sagarmano8858]

Great video.Waiting for the Next part

[@sqlbelle]

Thank you Sagar!

[@Ab_Jannadi]

Amazing as always, thanks for your efforts. I just want to say in this exact time 26:23 It's not working as you said

[@mostafaeidemg]

This video is fantastic and I like the way you simplify the complex points however at 26:23 the numbers are changed in % of region total and % of Grand total despite you using fixed expression and as per my understanding Fixed overrides any dimension that encounter , can you please correct me if I am wrong or explain why its changed,, Thank you for your amazing effort

[@lalitpatil974]

The number of % is changed, The reason behind the formula contains the sum of sales, which is why the sum(sales) change affects on %, although ma'am spoke wrong there.

[@ameliawang8619]

Can you please share the data so we can build these charts ourselves by following along with your tutorial? Thanks!

[@sqlbelle]

Thank you Amelia, I am planning to release the data sets in the videos. I will provide details once the page is ready.

[@fajarryanto1577]

Fixed its able if we use some filter to exclude non sales performance? or some product with non sales item?

[@sqlbelle]

Thanks Fajar. You can embed logic statements in the FIXED LODs, so you can technically address these cases.

[@felipepinilla7306]

In use case 4 min 26:40 when the filters are added the % of region and % of total DO change. It sounds like you are saying that the percentages should NOT change. Any clarity on this would be appreciated.

[@nidhisingh4973]

As per my understanding, % of total country sale should be calculated as "sum of each country sale / Grand total sale" and % of total region sale = "sum of each region sale / Grand total sale" But here she has taken "sum of sale " which is at state level

[@anduamlaktadesse9284]

Well done and can you drop the link for downloading the dataset.

[@pradeepp9126]

Hi sqlbelle, I tried the other way before checking the video Just by understanding the question , the calculation for checking profitable and non profitable days as follows : Profitable : COUNT({fixed [Order Date] : IF SUM([Profit]) > 0 THEN SUM([Profit]) END}) Not Profitable : COUNT({fixed [Order Date] : IF SUM([Profit])

[@sqlbelle]

Thanks for trying this out. You are absolutely correctly, there are multiple ways to achieve something similar in Tableau. But each could have their own nuances.

[@peterparker4358]

Thanks Mam I was eagerly waiting for this really nicely explained as always ❤️❤️❤️

[@sqlbelle]

Thank you Peter! :)

[@youmunna6452]

Thanks to this...mam I vl learn easy 👌

[@sqlbelle]

Thank you You!

[@srt5806]

Wonderful Video! Please make videos on Use Cases of Parameter Actions

[@sqlbelle]

Thank you!

[@GFXHDTV]

thank you for this amazing video, is there any way you could share the data so that i could practice along ?

[@TheElementFive]

Great tutorial, but to me, viz software should be abstracted away as much as possible from the data wrangling aspect of things. That is more efficiently achieved with SQL, pandas, etc..

[@rnchueng6402]

8:10, why does each column and row add up not the equal to the grand total? I don't understand the quick explanation in the video. Thanks.

[@sqlbelle]

Hello. Because the number is not additive. For example, if you bought 5x in 2018, and in 2019, and in 2020 as well as 2021 ... you wont be counted as 4x in the grand total because you are still just one, unique, distinct customer.

[@rnchueng6402]

@@sqlbelle Hi Belle, than you, I got it!

[@shashankworldpeace]

As usual good explanation. I have one point here regarding Case 3 i.e. profitable vs unprofitable. Instead of creating 2 calculated fields - one for LOD and other for conditional grouping based on LOD, we can directly create single field where LOD and condition for profit can be used. IF { FIXED [Order Date]: SUM([Profit]) > 0 } THEN 'Profitable' ELSE 'Not Profitable' END I have checked the result and got the same viz as u created. Are there any problems or drawbacks with my approach? pls highlight.

[@sqlbelle]

Thanks Shashank. Some of the questions around nested calculations are around clarity, reusability and manageability. If you ever need to use the total profit per order date again in another view, it's better to put it in a different calculation. Otherwise you will have to embed this expression every time you need it. It will make it harder to update as well, in case it needs to change. For clarity and for teaching, and especially for folks who are new to LODs, it is easier to explain and understand if we break up the logic into simpler expressions first, rather than using a nested expression right away. For clarity when you are working with other members in your team, having separate expressions may be easier to understand as well. As with anything, everything is relative. There is no one right answer, and you have to go with what works with you and your team.

[@shashankworldpeace]

@@sqlbelle Perfect! Makes sense. Also do you have any course where tableau is taught by you from the start to advance level? If not, what course do you recommend where uses cases are also taught well.

[@zeeshanahmed9719]

In customer acquisition trend use case, countd(customer_id) at a given min(order date) can also include those customer_ids that placed its 2nd or 3rd order on that day. Example: On 1st March 2017 five customers placed order for the very first time, including HR-14770. Tableau showing countd(customer id)=5 On 2nd March 2017 two customers placed order for the very first time. countd(customer_id)= 2. Now I added a row for one more order of HR-14770 on 2nd March 2017. This count should not be included for 2nd March 2017 because this is not HR-14770's very first order and HR-14770 is not a new customer on 2nd March 2017. But after addition of this row, countd(customer_id) for 2nd March 2017 changed from 2 to 3.

[@sushmithac5110]

Hey hi I wanted to make a cohort for employee retention how do I do that I used the same logic what you have used here i am getting diagonal matrix but not getting upper matrix. Can you please help me

[@anujtomar19]

I have one query , when you drag and drop [Order date] , tableau ask for continuous and discrete column value, but not in my case when i work on my machine, Do i need to enable any setting??? Please suggest....

[@ashisharora9649]

Hey, great work. I have one doubt. When you talk about the acquisition of customers, why did you consider those customers which we already had on that day, why did we not exclude them? I mean old customers should be deducted first and then the running total should be calculated such that we can know how much have we gained each day cumulatively to get the trend. If there is a problem in my understanding or there is no need for it then plss correct me. okay okay, you have also done the same by using the fixed level of details where you have only selected the customer's first purchase only hence only new customers are getting captured. great got it now thanks!

[@sqlbelle]

Thank you Ashish

[@AyeshaKhan-v2y]

hey can you help me how to show that drop feild bcz in my tabluae its not showing

[@youmunna6452]

i am very glad to say thanks mam...and can u explain to me LOD functions where ,when and why should we use please mam....

[@sqlbelle]

Thank you You! Please do check out my first LOD video (the link is in the description). It goes into detail as to what LODs are, and why and when we would use them. Hope you will find that video helpful!

[@sandrahu7122]

Thank you so much. I have been learning it on my own to build these 15 examples, and when i had questions, I didn't know where to ask, and I was so frustrated, i wish I had seen these videos before. But i will go over the series videos as going over LOD again.

[@sqlbelle]

Thank you for sharing Sandra. Happy to hear that. I haven't published Part 2 and Part 3 yet, but they're coming :) Hope you will find them helpful!

[@anai3187]

This is so helpful omg thank u

[@black-yn1cz]

Can you please create a video about YoY comparison or YTD vs PY_YTD. Thank you for your time. You helped me a lot

[@sqlbelle]

Yes, for sure. Thank you for the suggestion! Will definitely look at including that in future videos.

[@agelee89]

Is there something new introduced by Tableau like LOD editor (where you don't need to remember the syntax for LOD)? I saw it somewhere mentioned but cannot find any video presenting it.

[@sqlbelle]

You may be referring to the Quick LOD? It is a new feature, but has limited use at this point. Here is a reference: help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm#use-a-quick-lod-expression

[@Neutrino-xw6jl]

This is so useful!! Thank you so much

[@sqlbelle]

Thank you :)

[@laythkal-shblawi7101]

Excellent , how I can download the dataSets

[@PratikVora-ts7xn]

where is the link for dataset? can you please post it here?

[@deepakmr8248]

Can I have the data used for this as download? So that I can try this on my own

[@aniljhurani8289]

hey this is good example of Lod - Fixed , but one question i had at question 4 , mins 26 in the video , you mentioned that after adding all the calculations in the map , only the sales value should change with Segment , but , percentage of region total and percentage of grand total also changes , could you clarify please

[@jyothihosamani]

I am facing the same issue as well. Her contents are really good, but the only downside is , when you have doubts you cannot get it cleared. That's where probably structured courses / MOOC's might come in more handy. Nevertheless her courses are still a value add

[@paulocarapinheiro8739]

Excellent, thank you!

[@sqlbelle]

Thank you Paulo!

[@avinashdubey7941]

You said value should not change at 26:21 but % of grand total and % of subtotal are changing

[@sqlbelle]

Thank you for your feedback Avinash, I appreciate it. I just realized I had the filter I had in the video was for segment but it should have been region as per 22:07. I will make a note in the description.

[@avinashdubey7941]

@@sqlbelle Most welcome. I love the style of your teaching and I am learning from your video while giving interview. Today is my interview. Thanks a lot for giving so much valuable knowledge ☺️

[@onambhanot7088]

Can you please provide data sets for the same?

[@ambujrai7355]

Could you please help for custom SQL query implement in tableau environment..??

[@sqlbelle]

Thank you for the suggestion Ambuj!

[@gthxyz780]

Can u help vth currency conversion???

[@rahul1994negi]

where can i find dataset?

[@shobanaranjan2408]

how to get the unique customer id and unique order id

[@ajaykulkarni576]

Great contents, best explanation. BTW, is there a way I can get the PPT's? What microphone do you use to record the audio?

[@sqlbelle]

Thank you Ajay! I use a Blue Yeti mic 🙂

[@oren2010T]

Great video !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :-)

[@sqlbelle]

Thank you Avi!

[@oren2010T]

@@sqlbelle Noo !! Thank you !!!!! :-) , can you do a video about how to mix an aggregate argument e.g. sum(Sales), avg(Profit), Profit Ratio with non-aggregate arguments e.g. Discount ? please :-)

[@ShubhamTiwari-bi8ox]

Wooooooooooowwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww Thanks and respect to you

[@user-ri4ei2is6c]

Can you provide the dataset?

[@sheruns8579]

Its the sample superstore already in tableau

[@MrAstonmartin78]

Adorable.

[@16-hemalatha26]

How to show kpis and sparklines in a single sheet , make a vedio on it mam.

[@sqlbelle]

Thank you Hemalatha. I have another video that tackles it, and I also discuss some pros and cons of building it in single sheet vs separate sheet. I am curious to the reasons for needing it in a single sheet? kzbin.info/www/bejne/m2ncgnqagKxpmqs

[@lathbotti5497]

Hello, can I get your email please ? do you offer classes?

[@alagesancaptain]

That man coming for power BI ad is most irritating face while we are involving the session.

[@subhapandusubha2577]

ueuuuuuuuuuuuuuuuuoueù €

[@xuantungnguyen9719]

Hi Donabell, how did you organize your use cases into Folder in the data tab, and how Tableau decide where a calculated field will be displayed (attached to a table of at the end below the Measure Names). I'm new to tableau and have trouble navigating these things. Thanks for your great lessons

[@sqlbelle]

Hello Xuân! You can click on the dropdown in your side bar (beside search and data grid) and select "Group by Folder". Once you have that you can create a folder on the side bar (right click on an empty space, or right click on a field > Folders). Hope this helps!