This is super helpful! I found tableau’s table calculations to be confusing and impossible to understand but I was finally able to achieve the calculations I wanted after watching this video. THANK YOU!!!!
The look up hack (9.54) to keep the underlying data is the highlight of the tutorial! In fact we can replicate this into various calcs. Will try it on my dashboards to see to it myself.
Thanks for the video Anthony! Just wondering, would you say that this is still the recommended method to compare values of a different dimension value (eg. comparing sales by year, or comparing sales between divisions) ? What I normally do is create separate metrics, but that usually means having a large list of calculated fields and doesn't scale well. For example, I would have a Sales Price (current year), Sales Price (prev year) and then a Sales Price diff. Then I'd only show current year metrics and diff. But, like I said, I think your method is less convoluted. Thanks again for sharing your knowledge!!
How to lookup dates for the min value of a column, with conditions? I have a dataset with weekly planned and actual progress of a project which is categorised by Work type and Tasks(hierarchy), I want to calculate the start date and duration for creating a Gantt chart.
![Tableau LOD Expressions [Overview of Tableau Level of Detail Calculation]](/img/n.gif)
Hey Anthony, I thank God for coming across you video. The way you explained the topic is super helpful. Its really appreciated.
This comment made my day, thank you for sharing!
This is super helpful! I found tableau’s table calculations to be confusing and impossible to understand but I was finally able to achieve the calculations I wanted after watching this video. THANK YOU!!!!
Please upload more of such videos. It was very helpful
The look up hack (9.54) to keep the underlying data is the highlight of the tutorial! In fact we can replicate this into various calcs. Will try it on my dashboards to see to it myself.
Amazing Explanation
I appreciate the comment!
best tableau tutorial on TH-cam, thanks man!
I appreciate the complement; thanks!
where were you bro.......absolutely amazing you got one more subscriber. :)
I've been here for years! Glad you liked the video and thanks for subscribing.
Simplified but very effective tutorial, Thanks!
Much appreciated!
So easy to follow. Thanks!
Thanks for the comment!
This explanation was fantastic! Thank you! 🙌
Thank you for the kind words!
Thanks for the video Anthony! Just wondering, would you say that this is still the recommended method to compare values of a different dimension value (eg. comparing sales by year, or comparing sales between divisions) ?
What I normally do is create separate metrics, but that usually means having a large list of calculated fields and doesn't scale well.
For example, I would have a Sales Price (current year), Sales Price (prev year) and then a Sales Price diff.
Then I'd only show current year metrics and diff. But, like I said, I think your method is less convoluted.
Thanks again for sharing your knowledge!!
Great video
nice trick!
I don't comment much, but you deserve a thank you!
Thanks and I appreciate the comment!
Hi Anthony, Would you be able to share the link to the dataset please?
How can I filter the view without the data (what you showed) and link the filter to always the start the view with the current week?
You are Genius man!!!🙏🙏
Great!!👍👍
I'm am humbled, thank you for watching!
Please do a video on LODs.
Hi, have question. How to create calculated field from two different data source using blend.
How to lookup dates for the min value of a column, with conditions?
I have a dataset with weekly planned and actual progress of a project which is categorised by Work type and Tasks(hierarchy), I want to calculate the start date and duration for creating a Gantt chart.
I have a video on how to create a Gantt chart. Check that out.
The background music in the beginning is a bit distracting. Awesome tutorials still!!