Hands down the best Tableau teacher on youtube! Any time i hit a roadblock youre the first channel i come to! If i make it in the field soon Ill be sure to donate, cheers!
Fantastic video! I hit upon this video trying to solve a specific problem, but ended up watching the whole video because you're a fabulous teacher. Looking forward to checking out more of your tutorials.
Glad it helped and welcome to the channel! I have quite a few playlists and videos so absolutely get stuck in and shout if something is missing here tableautim.canny.io/suggestions
Looking forward to more content from you. Good job with the pace, the clarity of the visuals and for not over complicating things in delivering the message. Great job!
Thank you for the video Tim. I like the way you structure the videos I've watched. Did you ever make a video reviewing the table calculations you talk about at the end of this one? I tried searching but couldn't find it. Cheers!
On my to do list. Add a comment or bookmark to this thread and you can track it. tableautim.canny.io/suggestions/p/table-calculations-follow-up it’s the new way I’m tracking community requests
Nice video. Good job. I am transitioning from an excel head to Tableau and I always do the mental gymnastic of comparing the two. Ranking a table or range is way easier in Excel. I am sure I am missing some technical bits but that's my first impression.
To be honest I don’t think excel and Tableau are comparable and I would expect there to be more to understand in Tableau as excel is relatively basic. The better comparison would maybe be to Power Bi in terms of comparable tools but the philosophical differences are there. Also I think your over over complicating the concept because the rank function works well beyond tables it’s a fundamental function. What you’re talking about in excel sounds more like Index() which is sort of similar but works in the same simplistic way as excel. I’ll get to that video soon.
@@tj6544 We hear you. However, you're not abandoning Excel for good, just use it much less. In Data Science, all people I know still use Excel, even though they work mostly with Tableau, R, or Python.
Newbie in Tableau here and I just wanted to ask something. Supposedly you want to sum all that is in rank x(considering it has the same values), is it possible to do that? By the way, watching your vids as my reference. :)
I don’t but I’m fairly certain others do. It’s a fairly simple calculation and rank wouldn’t be what I would actually use. The best way to answer that is to break it down. First I’d find out how to define most improved this quarter? You might want to rank the percentage change or just index from largest to smallest. Then for the second bit of the calculation you need some logic to define the quarter. If you did this manually you would just use a parameter with a drop down to choose the quarter and year or you could do it dynamically using the date part function on today() function to figure out the current quarter for the user
[ 'asc' | 'desc' ] or [ a | b | c ] is a grammar convention that means "You can choose any or none of the options divided by pipes. Another convention is to use curly braces as in { a | b | c }. This means that you MUST chose one of the options divided by pipes.
Hi Tim, I was just highlighting that the use of [ and ] in the Tableau help of functions may be confusing as it means Optional when describing the syntax and is also used to indicate a [FIELD] or parameter. PS: Great videos :)
I have a question. Is there anyway to actually find the maximum and minimum for rank percentiles? I would like to create cost buckets so a user can view the range within a specific percentile. Any help would be possible!
You could use a parameter to control the percentile you like to pick and from that filter the percentile column then apply a min and max to the remaining values giving you a set of items. But if you wanted to highlight them thats a bit more involved. Let me know if you figured this out.
Hi Tim, I want product wise top 10 sales without non aggregated sales In text table & Another thing is scatter plot which shows Top 10 products as per non aggregated sales on scatter with x -Axis -Profit Y- Axis- Discount?? How to achieve this???
Is this related to the rank function? I don't believe it is. I think you'll find solutions to all of those already in blogs and other on youtube. Let me know if you can't find any searching and I'll point you in the right direction.
Thanks Tim. Could you help me? When I select top 10 I only get 8. I'm using a date selector to filter and filtering top 10. I have the date filter added to context. How do I get 10 results?
Your date filter and rank are clashing. Check out my video on order of operations for more detail but i would set the date filter to context then do your top 10. What's happening at the moment is you do the filter to the top 10 then your date filter runs because dimensional filters run before the data filter so from 10 you go to 8.
The data set is the dault one in tableau. Watch the start of the video to see how I open the data source. It should be installed with your copy of tableau. I use a saved data source. let me know if you still cant find it in you copy of tableau.
hi Tim, thank you for the vidoe, can I please sk you a query? i have sales data by month by customers, i need to create a table for top 10 customers by category, the table should have customer name, monthly sales (in column) and sum total of all the month. the rank should be on the total of all the months. i am trying to use the rank function, but it is not picking up rank by sum of month instead it is picking up at month level rank. can you please help?
You need an LOD (sum) on the customer and then rank that calculation. Check out my video on level of detail expressions. all the videos are on youtube but this page has them int he correct order. www.tableautim.com/playlist/tableau-level-of-detail-calculations the fixed video show syou how to do an LOD and then you can rank the LOD and use that as a sort.
Its superstore sales, the default data set in Tableau. If you watch the beginning of the video, I show you how i open it from tableau. It should be installed with tableau. If not Let me know and i can share the excel file but you should already have it.
HI Can i do a Rank or Rank_Dense on Dimension. I have a coloum which has 10 names of contries which are spread multiple times in 20 rows. so know i want rank_dense on this dimension.. can anyone help
Don’t think that’s me with the issue. All my audio is level checked at -10db so I don’t think I’m too quiet. You might need to up the volume on RU-vid or your device, but it’s definitely not me speaking quietly. Ive caked this video again and audio at medium volume on RU-vid and my device is perfectly clear. If anyone else has this issue let me know.
Non existent. I'm just 1 person with a ton of areas and topics to cover but i think its already well covered by others so hoping you find those repsurces. I'll be redoing these older videos again soon to be more complete and clear.
In the Uk if you refer to all the American countries you would say ‘Americas’ rather than America but recognise America is a lazy use of words to describe USA. Guess when you record videos unscripted late in the day, these things happen. I hope you at least got some value from the free video. I can’t fix the upload as RU-vid doesn’t have a replace capability or any way to edit the video.
