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!

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!

Thanks Tim. I like how you sneak in tips while going over the topic.

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.

@TableauTim

2 жыл бұрын

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

Excellent job I was got stuck here for asc and desc, thank you so much god bless you.

Thank you for explaining all these details. I love details! 🦋

Thank you so much, you always give crystal clear explanations.

The zooming in really helps for those watching on phones. Thanks

Helped elevate my dashboard. Thanks!

@TableauTim

4 ай бұрын

Glad it helped!

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!

@TableauTim

2 жыл бұрын

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.

@TableauTim

3 жыл бұрын

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

3 жыл бұрын

@@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. 🤣🤣

@PatrickBateman12420

3 жыл бұрын

@@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.

Just saved me, thanks !

Thank you, I didn't understand quite well the differences but now it's more clear.

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?

@TableauTim

2 жыл бұрын

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?

@TableauTim

3 жыл бұрын

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.

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?

@TableauTim

2 жыл бұрын

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!

@TableauTim

3 жыл бұрын

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.

I have dashboard that have rank but it is not sorting it the way I want it. Can you help?

Hi Tim, Can you please make a video on how to record performance tuning in tableau .

@TableauTim

3 жыл бұрын

Sure this will come soon. I assume you’re more interested in Tableau desktop performance recordings right?

@nbkwdpu

3 жыл бұрын

@@TableauTim yes

Man you made my day! What a great help. Do you have a discord ?

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

@TableauTim

Жыл бұрын

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.

@TableauTim

3 жыл бұрын

I was walking through the options in Tableau. Are you referring to something outside of Tableau ?

@YTFC2008

3 жыл бұрын

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

@TableauTim

3 жыл бұрын

@@YTFC2008 ah yes that is confusing ! nice spot thanks for highlighting 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

@TableauTim

2 жыл бұрын

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

@TableauTim

3 жыл бұрын

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.

Nice video, please add your tables link on describtion

@TableauTim

3 жыл бұрын

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

@TableauTim

3 жыл бұрын

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 KZread or your device, but it’s definitely not me speaking quietly. Ive caked this video again and audio at medium volume on KZread 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.

@TableauTim

2 жыл бұрын

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 KZread doesn’t have a replace capability or any way to edit the video.

@davidfeldman603

2 жыл бұрын

@@TableauTim video was great and the content is great, thanks! Thanks for sharing content! Thanks also for responding!

Where is the table calculation video😢

@TableauTim

11 ай бұрын

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.

@hpujari

11 ай бұрын

@@TableauTim appreciate your response...keep up the good work Tim