Using LOD Calcs to Compare Latest Year to Prior Year

#TableauTipTuesday: Using LOD Calcs for Year over Year Comparisons

Download the workbook here -

[hubertasuncion]

wow you make this so easy. i'm an sql / excel user and struggling with tableau, very thankful to have stumbled upon this.

[alps]

Wow spent ages trying to figure this out !!! THANK YPU SO MUCH

[jmwdba]

This video has helped me a lot. I wish I could upvote it 1, 000 times!!!!

[arnabpalit]

This is something I was really looking for. Rather than calculating YoY change though the pill options (table calculation) it's much more robust. Thanks a lot for this helpful content!

[ramaachavan]

Your videos has helped me a lot at work👍

[kyouichi]

Hi Andy,
I have just started to use tableau and moving from excel I found it was very difficult to wrap my head around the autoaggregation. I was looking to do something similar and this is the perfect way of doing it. I was concerned I had to do this in Prep through squeal. Your explanation and the level of detail was easy for me to follow.
I don't usually comment but you definitely deserve all the credit. Just subscribed!
Keep up the amazing work!

[lravikiran]

Hi Andy, This is super awesome way . I knew that LOD were very capable of doing such a thing, but I tried doing it the same way ended up messing it. Alternatively I have used the lookup function to compare the YOY in my dashboard .

[timewithsopy]

Thanks so much for this video. As I am trying to create my plan and forecasting dashboard for 2021, this video really helped simply my LOD thought process.

[uLeabric]

awesome video which helped me solve the problem troubling me for a while, thank you!

[chaitubb]

You are amazing person helping everyone to learn the visualisation in a easier way.. Thank you for giving us so much of knowledge. Keep up the good work 😊

[mse]

Wow Andy, I learned the first and the best from you. A great teacher indeed, genius you are.

[ashbucks]

Hi Andy, what a great video! Could you post another video on how to compare a same day last week comparison of sales? I'd really appreciate if you would since I have been working around this within a week and met a dead-end. Thanks!

[ibraheemsheik]

display KPI's next to bars which is already done by u, but it's always helps me a lot

[delfmu]

Very nice, one of my problems is that I don´t fully understand the level of detail functions. Thanks!

[dharmeshraut]

Excellent video. This solved my YOY problem, but will it solve by MOM (comparing it with the previous month within the same year) for all months? Thanks a lot :)

[srikanthregadi]

Its awesome channel for Tableau, thanks a lot Andy for sharing your valuable stuff. I have to be more familiar at nested LODs and Please explain internal operation for flowing scenarios:
In row shelf: category, Market
1. { FIXED COUNTRY:MAX({ INCLUDE MARKET:SUM(SALES) }) }
2. { FIXED COUNTRY:MAX({ EXCLUDE MARKET:SUM(SALES) }) }

Data source: Global Superstore.

[saidherrera]

gracias bro pase demasiado tiempo buscando esto, muchas gracias!!!

[BillJames]

I had an issue with my YoY calculation because of Leap Year and I would like to share this solution for others who may be having the same issue.
DATEADD('year', -1, DATE({MAX(DATETRUNC('month', [Period]))}))

[andrewvu]

For example: if the date range I selected is 1/1/2018-1/31/2018, I would like to see the YoY growth % for the same period last year, 1/1/2017-1/31/2017.

or 11/11/2017-2/19/2018 YoY growth % from 11/11/2016-2/19/2017.

Would this be possible?

[TheSighlent]

Great explanation!!! Thank you so much!!