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

Thanks for sharing what you know! Knowledge is power!

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

Andy, thanks for teaching us

Absolutely beautiful

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?

Wow this is great.

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

Amazing!

Thanks it will as very helpful..!!

@vizwiz

3 жыл бұрын

Glad to hear that...thanks!

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!

@awilkerson10

6 жыл бұрын

Daniel, Did you figure out how to do this? I'm interested as well.

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,

@vizwiz

7 жыл бұрын

That's probably because they are no different number types. One is whole numbers and one is decimals. They have to be the same to sync.

@MrMaiqbal

7 жыл бұрын

Many thanks for the quick reply, they are actually both whole numbers. I am still investigating the issue. Will update.

@MrMaiqbal

7 жыл бұрын

I have finally fixed it after checking all number formats. Thanks. Just another query, can we somehow put in dynamic month names in Tooltip, ex "Prior Month"

Where can I get the dataset ?

good video but my synchronization doesnt work

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.

@huytruong2026

3 жыл бұрын

Never mind. I got it. Aggregation is the correct thing to do here. Otherwise, when I drag YoY into the view, Tableau will aggregate it as SUM(Latest Year >= Prior Year), which is just a sum of a bunch of 1's, because the inside part is a boolean comparison. Sorry for the confusion!

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!

@JI9131

7 жыл бұрын

Agree with you, should be done by Tableaau as standard

@joefromdc

6 жыл бұрын

Joe JG Agreed, reason why so many ppl say with excel

@GurunathHari

3 жыл бұрын

So true. Try seeing how to get a doughnut graph. Lol! It's a standard in Power BI. DISCLOSURE. Am not connected with Microsoft in any way other than being a user.

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

This helps out tremendously. Thank you.

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.

Well done! love your videos.

Excellent video.... Thanks a lot

Great Job Andy Thanks!

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.

very recursive, Excelent! thanks

amazing!!! I love it!

Genius 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?

very impressive...

OMG, OMG. Wow!!!!

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)?

Cool Andy

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!

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.

@vizwiz

7 жыл бұрын

You realize I do these for free on my own time, right? The reason for a video is so that you can pause and follow along. I don't have a recording studio nor editors.

@Romdryl

7 жыл бұрын

Andy Kriebel uh, ok then. Well, keep up the good work. Thanks for doing them.

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?

Thanks :-)

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