Rank Function in Tableau and it's variants
Вставка
- Опубліковано 22 лип 2024
- In this video, I cover how the Rank function works in tableau along with its 4 variants, Rank Modified, Rank Dense, Rank Percentile and rank Unique.
0:00 Intro
0:20 Setting up a table to show you rank
2:36 How to use the rank function.
8:05 Rank Dense explained
10:56 Rank Modified explained
13:36 Rank Percentile explained
15:29 Rank Unique explained
17:39 Outro -
#tableau #salesforce #analytics Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
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!
Thanks Tim. I like how you sneak in tips while going over the topic.
Excellent job I was got stuck here for asc and desc, thank you so much god bless you.
Helped elevate my dashboard. Thanks!
Glad it helped!
Thank you for explaining all these details. I love details! 🦋
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
Thank you so much, you always give crystal clear explanations.
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!
The zooming in really helps for those watching on phones. Thanks
Just saved me, thanks !
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
Thank you, I didn't understand quite well the differences but now it's more clear.
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.
@@TableauTim Its me not coming to terms that my love affair with Excel has ended and the need to move on to my new relationship with Tableau. 🤣🤣
@@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.
Thanks!
Can you please show how to do rank based on more than one column ?
Thanks!
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. :)
Great video~! Do you have a video for how to rank comparison periods? For example, most improved Category this quarter?
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
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.
I have dashboard that have rank but it is not sorting it the way I want it. Can you help?
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.
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, Can you please make a video on how to record performance tuning in tableau .
Sure this will come soon. I assume you’re more interested in Tableau desktop performance recordings right?
@@TableauTim yes
Man you made my day! What a great help.
Do you have a discord ?
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
Sure there's help here which you can use with my video to help you out. j.mp/3zzmH4G
Can you please give the link of dataset you used
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 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.
[ '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.
I was walking through the options in Tableau. Are you referring to something outside of Tableau ?
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 :)
@@YTFC2008 ah yes that is confusing ! nice spot thanks for highlighting it !
Nice video, please add your tables link on describtion
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.
How to calculate Rank for subtotal as it is not coming correct
Hi Tim, Thanks for the amazing videos. Could you speak bit louder while recording the videos
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 UA-cam or your device, but it’s definitely not me speaking quietly. Ive caked this video again and audio at medium volume on UA-cam and my device is perfectly clear. If anyone else has this issue let me know.
there are 35 differenct countriesin america so u mean usa.pls fix.
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 UA-cam doesn’t have a replace capability or any way to edit the video.
@@TableauTim video was great and the content is great, thanks!
Thanks for sharing content!
Thanks also for responding!
Where is the table calculation video😢
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.
@@TableauTim appreciate your response...keep up the good work Tim