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.