#TableauTipTuesday: How to Display KPIs Next to Bars This tip shows you how to perfectly position KPIs next to bars irrespective of the dimensions in the view. Download the workbook here - www.vizwiz.com...
Пікірлер: 51
@megj31548 жыл бұрын
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.
@brennenmm7 жыл бұрын
All your videos are great! Please keep them coming. This one is very useful for me.
@rajsamant14 жыл бұрын
Andy, thanks for teaching us
@lekanadenusi4622 жыл бұрын
Absolutely beautiful
@zubairahmed-nt8ml7 жыл бұрын
Millions of thanks and It is awesome...Thanks for sharing the video
@meetalipandey80733 жыл бұрын
Thanks it will as very helpful..!!
@vizwiz3 жыл бұрын
Glad to hear that...thanks!
@michellebannon6744 жыл бұрын
Wow this is great.
@honghuang1843 жыл бұрын
Super helpful!! May I know how to show the variance between target and current year ?
@GurunathHari3 жыл бұрын
Amazing!
@eloyeligon66768 жыл бұрын
Mind blowing!
@BeccaL20167 жыл бұрын
Great videos! thanks!
@illusivegator6 жыл бұрын
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?
@mohanr95223 жыл бұрын
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?
@JamesBond-pm7th6 жыл бұрын
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)?
@danielc71656 жыл бұрын
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!
@awilkerson106 жыл бұрын
Daniel, Did you figure out how to do this? I'm interested as well.
@huytruong20263 жыл бұрын
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.
@huytruong20263 жыл бұрын
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!
@MrMaiqbal7 жыл бұрын
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,
@vizwiz7 жыл бұрын
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.
@MrMaiqbal7 жыл бұрын
Many thanks for the quick reply, they are actually both whole numbers. I am still investigating the issue. Will update.
@MrMaiqbal7 жыл бұрын
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"
@benjay127 жыл бұрын
good video but my synchronization doesnt work
@ibanguniverse8114 жыл бұрын
Where can I get the dataset ?
@JoeG23248 жыл бұрын
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!
@JI91317 жыл бұрын
Agree with you, should be done by Tableaau as standard
@joefromdc6 жыл бұрын
Joe JG Agreed, reason why so many ppl say with excel
@GurunathHari3 жыл бұрын
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.
@ryangarland2515 жыл бұрын
So confusing...too many calculated fields....
@vigneshiyer58638 жыл бұрын
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.
@illusivegator7 жыл бұрын
Thanks for sharing what you know! Knowledge is power!
@willtoler16 жыл бұрын
This helps out tremendously. Thank you.
@omelturk46095 жыл бұрын
Great Job Andy Thanks!
@narasa127 жыл бұрын
Excellent video.... Thanks a lot
@matthewrisley90707 жыл бұрын
Well done! love your videos.
@PatrickBateman124205 жыл бұрын
Genius Andy!
@delfmu8 жыл бұрын
very recursive, Excelent! thanks
@Romdryl7 жыл бұрын
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.
@vizwiz7 жыл бұрын
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.
@Romdryl7 жыл бұрын
Andy Kriebel uh, ok then. Well, keep up the good work. Thanks for doing them.
@pag46976 жыл бұрын
amazing!!! I love it!
@TheAcelsin6 жыл бұрын
very impressive...
@arrs56427 жыл бұрын
Cool Andy
@paulgustafson24366 жыл бұрын
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?
@BrennerRick7 жыл бұрын
OMG, OMG. Wow!!!!
@patrickrolis9926 жыл бұрын
Thanks :-)
@shreem77216 жыл бұрын
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)?
@allysonfullmer52487 жыл бұрын
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!
@matthewrisley90707 жыл бұрын
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?
@qili27807 жыл бұрын
One more question: how can you sort the data in the bar chart?