Big fan of all your videos. The way you explain has made it so much easier to understand. Wondering if some day you can make a video on how to manage the data security/access of Tableau? :)
Great explanation! Just a comment. I think it's not correct to say that TOTAL is the minimum of the minimums (06:03). Actually it is, but it's not the way tableau works with TOTAL. Under the hood it is looking at the entire table (data underlying the current view) and is finding the minimum. If you used AVG as aggregation, it should have returned the AVG considering the underlying data to the view, NOT the average of the averages.
Thank you for this great explanation. Do you offer training? I need help with Tableau calculations.. especially how to create calculated fields out of any requirement.
The result of WINDOWS_SUM we can achieve by usinf LOD functions also... What is the difference and what are the correct scenario to use LOD and windows functions?
LODs are used when you don't need the calculation to be affected by other fields/filters in the canvas. LODs also don't get affected by scope and direction. For example computing table across/table down/pane across etc. For example if you need to calculate a running total - this will be harder to do in an LOD because you may choose to change the fields in your running total (for example, running total along days, or weeks, or months, or years). Or to even reset this per year. Much easier to accomplish in table calcs. Does this help? There are a number of other common use cases. Perhaps I can create some samples in another video.
@@sqlbelle @sqlbelle I really appreciate you, spending your valuable time answering my question. Yes, it would be helpful if you create another video for different scenarios. Thanks
Big fan of all your videos. The way you explain has made it so much easier to understand. Wondering if some day you can make a video on how to manage the data security/access of Tableau? :)
Among all the Tableau teachers I’ve encountered in 2 years, I prefer your teaching style and content the most!
Thank you for such kind words, @SebAnt !
Great explanation! Just a comment. I think it's not correct to say that TOTAL is the minimum of the minimums (06:03). Actually it is, but it's not the way tableau works with TOTAL. Under the hood it is looking at the entire table (data underlying the current view) and is finding the minimum. If you used AVG as aggregation, it should have returned the AVG considering the underlying data to the view, NOT the average of the averages.
I still didnt get it, do you have another example?
Thanks you so much, @sqlbelle! I'm looking more video like this.
Thank you for this great explanation. Do you offer training? I need help with Tableau calculations.. especially how to create calculated fields out of any requirement.
Great explanation as always 👍
Thank you @DataVizcovery!
The result of WINDOWS_SUM we can achieve by usinf LOD functions also...
What is the difference and what are the correct scenario to use LOD and windows functions?
LODs are used when you don't need the calculation to be affected by other fields/filters in the canvas. LODs also don't get affected by scope and direction. For example computing table across/table down/pane across etc.
For example if you need to calculate a running total - this will be harder to do in an LOD because you may choose to change the fields in your running total (for example, running total along days, or weeks, or months, or years). Or to even reset this per year. Much easier to accomplish in table calcs.
Does this help? There are a number of other common use cases. Perhaps I can create some samples in another video.
@@sqlbelle
@sqlbelle
I really appreciate you, spending your valuable time answering my question.
Yes, it would be helpful if you create another video for different scenarios.
Thanks
Great explanation!
Glad it was helpful!
This is great 😃. I am practically sleeping on your chamnel 😅😅😅
half understood, but what I mostly don't understand is why is this useful?
Thank you for this very interesting video 🙂
Thank you @alainponroy2621 :)
Awesome 👍
Thank you 🤗
Your explanation was perceptive and enlightening!!!
Thank you @yashishkarkera5543
So happy to see this type of video created by a woman ❤ the explanation is wonderful! thank you so much for this @sqlbelle
Thank you so much Larissa! Your comment means a lot :)
Belle, you are the best teacher! Please consider opening a member channel, I’ll pay ❤🫶🏻
Thank you so much @jackieyu5675 ... this means a lot. I very much appreciate the kind thoughts and words.