Your channel has the best of Tableau Videos, and are extremely easy to follow. I am having a tough time in understanding LOD expressions. Can you kindly make a Video on LOD expressions and how to use them? It will be very useful to many. Thank You In Advance Andy.

All your videos are great! Please keep them coming. This one is very useful for me.

Andy, thanks for teaching us

Absolutely beautiful

Millions of thanks and It is awesome...Thanks for sharing the video

Thanks it will as very helpful..!!

Wow this is great.

Super helpful!! May I know how to show the variance between target and current year ?

Amazing!

Mind blowing!

Great videos! thanks!

Great video Andy! Being a subscriber I'm a big fan! Quick question. how do I get around the calculation error of Cannot mix aggregate and non-aggregate comparisons?

Hi Andy! I'm struggling on the visual to show current month bar chart after last 12 months spark lines... Can you please post this one as a new video?

what if you're comparing Days of the Week and the Previous day is a Sunday or Saturday in which case you don't have any data? How do you make the Previous Day always a weekday (mon-fri)?

Hi Andy, great tutorial but I have a questionf for you: I was able to do as you showed in the video however I want to measure the count not sum of something. More specifically I want to count the number of support tickets this month and compare it to the prior month in the same fashion you do here, however when I change the measure type from sum to count the values aren't correct. Please could you let me know what I need to do? Thanks!

Hi Andy, @ 3:26, could you please explain why the calculation for YoY is SUM(Latest Year) >= SUM(Prior Year)? Why can't it be simply (Latest Year) >= (Prior Year)? Thanks.

Great video, one of the Andy's best. I tried the same but got stuck at the time when we need to add a multiplier to the - value of Window_Max. Don't know why but my Axis sync lost every time when I add a multiplier (in Andy video it was *0.05). May be some one help me here,

good video but my synchronization doesnt work

Where can I get the dataset ?

great tip, awesome job, love your channel. However, this kind of stuff should work out of the box for the money you pay for a tableau license. thats insane. To go through all that just to line up a KPI is completely ASINIE!

So confusing...too many calculated fields....

Superb... improves the pre-attentive processing of information. There is one more option. Update the Mark Position formula to something like -100. Add it to columns as an Attr. Now its fixed and doesn't change with addition of dimensions.

Thanks for sharing what you know! Knowledge is power!

This helps out tremendously. Thank you.

Great Job Andy Thanks!

Excellent video.... Thanks a lot

Well done! love your videos.

Genius Andy!

very recursive, Excelent! thanks

Hey Andy, good stuff and very relevant to the work I'm doing. Any chance you could switch to decaf and slow down a bit! LOL. I find that I'm constantly having to pause and back up and pause and back up and eventually I just give up and stop trying to follow along. Otherwise, it's all pretty darn helpful. Thanks.

amazing!!! I love it!

very impressive...

Cool Andy

Thanks Andy! Appreciate the video. I was trying to modify this a bit to do it for a current/prior month instead of year. How would you do that?

OMG, OMG. Wow!!!!

Thanks :-)

Can we have same Up-Down arrow toward the end (right end of Bar Graph)on addition and deletion of Measures can the indicator be the same(without any size change)?

Hi! I'm trying to do this with counting unique IDs and by Fiscal year. When I input COUNTD(metric) instead of sales, I can't aggregate. Also, how do I make the "latest year" a fiscal year vs. a calendar year? Any tips would be appreciated. Thank you!

Andy, How would one display KPI's based on another calculated measure? I have a calculation called NPS (%Promoter-%Detractor) where promoter and detractor are values in my data set. I first calculate the percent of promoters/detractors (count of (promoters/detractors) / num. of records) and then calculate NPS. However, when trying to follow this tutorial - You cannot mix aggregates and non aggregates in the IF statement. Nor can u solve the issue by putting ATTR() around the Level of Detail Calculation and/or Date because then the value will always be 0. Any suggestions?

One more question: how can you sort the data in the bar chart?