Tableau Tutorial - Top N & Bottom N

[@mariorest5722]

bro ive been searching for how to this for hours thank you for getting straight to the point 😭

[@petuliaas]

Spent ages looking through over tutorials, this was easily the best one, thanks so much!

[@perlalobera8320]

agree! Me too!!!

[@digwijoymandal8662]

Described in the most shortest and easy to understand possible way. Thanks.

[@maximilianodelatorre2513]

THAAAAAAAAAAANKS sooooooo much!!!! I can't belive it has so many steps in Tableu, but thanks for ther explanation, very clear.

[@aquilar1943]

Omg exactly what I'm looking for. Thanks man!! Super clear and straight to the point

[@matthewhefferon]

Awesome 👍

[@ralucadot7980]

He he! the right tutorial at the right time! Thank you for sharing :) LE: I used this tutorial to filter my data by the last X available days (which are with gaps in my data set). If I have 23Feb, 3Mar, 10Mar and 15Mar, the last 2 available days are 10&15Mar. First I transformed the dates into integer then wraped it into a Fixed calculation at date level in order to obtain a metric which will be the base value for Top N. Since the dates are always increasing, then my fake metric is also always increasing and it doesn't matter the by how much compared to a previous day. Thus I am using the "weight" of the date in the Top N.

[@sushmitajadhav7133]

I wish to like this video at least 10 times!!!.. great help buddy. Many many Thanx

[@abhaivirsingh]

Excellent Quick Tutorial with such clarity. Thanks Mate.

[@Chasam93]

This is just what I needed! Great video!

[@poojathombare7024]

Great tutorial...really too much easy to undestand.thank you...

[@dkliuiko]

Thank you! It's really cool and easy!

[@taeinhee]

so clear explaination on how it works ! thank you so much !!

[@taeinhee]

Can I ask on more detailed condition ? I'm trying this but added 1 more filter of [Year], but seems like this parameter only works ABOVE the [Year] filter, which means, I want to find out top10 & bottom10 of each years, but the result of [Year] filter >> only filters AFTER the Top N, so only includes of 2~3 at last... can you help me how to change the filteration order ?

[@yoobin.y]

Thank you for this tutorial. But I am wondering how to do this in different categories.

[@86Plum]

Great video! Just what I was looking for! Thanks

[@TheS1lentX]

can I ask how did you create the 'Profit Bin Size' parameter?

[@matthewhefferon]

If you pause the video here kzbin.info/www/bejne/eWiVe3uDn8tgnpIsi=32FgpS4BsKHOx6Sd&t=52 this is a copy of it. Hope that helps!

[@manojprabhakar7951]

Hi , thanks a lot for this. I have a requirement where instead of SUM(Measure) it is only Discrete Measure and how to find the Top N and Bottom N for this.My Bottom N has Negative Values,But when i Try it doesn't display it

[@zayhenriquez472]

Thanks this is great but for some reason when I do the filtering as described, some names are skipped , is it maybe I have groups of names? I am not sure why I dont get the same results when I do a simple table. Any ideas?

[@joelegions8957]

This is great! Anyway to make null values not be considered in the bottom n? When I filter them out my bottom n fails to show anything.

[@joelegions8957]

@@matthewhefferon I actually just updated my calculated field that I’m using with a Isnull to set them to 0. Works great. Thanks again!

[@TheJoker91339]

This is nicely explained and helpful. Thank you!

[@amandasalomon8420]

So awesome!!! Thanks! Would you mind showing me how to apply when doing this with percentages? It’s giving me some trouble

[@amandasalomon8420]

Also, once I drag the combined set into the filter box, it takes ages to process the request. I’ve filtered to only 6 mo of data

[@neerajdewangan7256]

simple explanation, Thats Great - thanks

[@99Lovebites]

Thank you, very clear and well explained :D

[@LazyBoy1805]

How about bottom N by category & country?

[@perlalobera8320]

exactly what i needed! thanks so much! Super easy to understand!

[@tugsuu8585]

Very helpful tutorial. Can I make Top and bottom N by changes of previous date (yearly, quarterly, monthly etc.)? Adding table calculation combined with calculated field on this set will work?

[@matthewhefferon]

Thanks! You can filter Top and bottom N by a date no problem. Not sure about your table calculation and calculated fields. Best of luck!

[@ellie5931]

Great tutorial, worked very well. Thank you! When I try to add an additional filter though (to see the same result, but only for a particular year), the view gets distorted and Tableau disregards the number given in the parameter control section on the right. Is there a workaround for this?

[@DarrylBodkin]

Excellent tutorial

[@murattuna3867]

wonderful point

[@triciamcintosh5865]

Super video! I'm new to Tableau but wondering if there is a way to add a line to define top from bottom that will move if the N value changes. Also is there a way to add a rank.

[@АлексейВереник-г1р]

Good stuff guy, thanks a lot

[@sjame11]

Hello! thanks, very usefull! one question, how can I put a condition to apply the Top N based on only year 2020? In the datasource we have several years and I am comparing profit of 2020 vs 2019 for top 10 clients but the Top10 seems to be calculated based on all years....thanks for your help!

[@sjame11]

@@matthewhefferonYes! thank you!

[@christianplan509]

@@sjame11 did he reply? same question

[@robmaclennan9469]

do you have the workbook that I can use to replicate

[@matthewhefferon]

I don't - sorry about that!

[@amoldeshmukh5350]

How can we implement this power bi report ?

[@matthewhefferon]

No idea. I've never used Power BI :)

Many thanks! Video is a good help to create top and bottom by profit. What about if you want to create top and bottom by calculated field? Let's say, I need to create top and down by change in profit (%). In such a case, I am not allowed to set my measures when I create I set.

[@icchung]

Thanks for this video . Is it possible to show an option to just have top 10 and ZERO for bottom? My error msg: Unable to complete action The filter limit must be greater than zero. Error Code: AC6CC624

[@sha2133]

Hi how did the 0 appeared in the middle of x axis? My 0 is at the first part of the x axis

[@gautamsehgal5653]

wonderfully explained!

[@stevefiler9328]

superb!!

[@Shiva-zi9nw]

Thanks man..... U saved me

[@nadiachebbale1695]

Why I can' find the parameters in the left hand side!!!

[@matthewhefferon]

There is a down carrot to the right of the Search field and if you click that you will see "Create Parameter".

[@claraliu5870]

How to show middle customer profit except top N & bottom N ? Thanks.

[@wllymchng]

Awesome tutorial!

[@evertlizama1021]

Hey I put this together and it worked! So thank you for that, however, when I apply filters to the view it only takes into consideration the same top and bottom values just filters out the values within that set. Is there a work around where the filter can make this dynamic?

[@evertlizama1021]

@@matthewhefferon Perfect it worked!!! Thank you so much!!!

[@christianplan509]

@@evertlizama1021 did he reply?

[@yishaktaye1951]

find it very helpful..Thank You Sir.

[@michaelsmith1076]

When I do this my top value disappears. Any idea as to why?

[@matthewhefferon]

I created the workbook on my Tableau public profile if you want to check it out tabsoft.co/3HS9A4B

[@maggietang1369]

Good explain! How to make the final top histogram at the right side and bottom at the left side? Mine just show at the same side. Thank you!

[@wllymchng]

You're set parameters may be set up incorrectly. By nature of the profit field...the bottom should be negative values and the top should be positive...so if you're correctly pulling both range of values, they should never be on the same side? If they are, to me...that sounds like you are pulling data that have nothing but the same direction of values.

[@seanjames8126]

How do i do this with excel?

[@matthewhefferon]

No idea haha

[@mariannafricska8073]

Thanks, it was a great help!

[@babuji93]

Nice mathew

[@rileylow648]

Thanks, super helpful.

[@meghanad]

This picks top N rows and makes a data set. How to pick all rows carrying top N values in a column of entire data set? e.g. values are 90 5 times, 89 5 times - this method picks only 10 rows and values are 90 and 85 - these are top 2 values - looking for top 10 values

[@barathbks]

Thanks for the tutorial

[@Kinson09]

Good work thanks!

[@mohanrao-fw9ix]

It's awesome ❤️

[@agatawidomska562]

It works,thank you very much! :)

[@clarke6814]

I love this video, but everytime I try it, it gives wrong values. I'm not sure why. For instance, for the bottom 5, it always skips ranks, and it shows 5 lines for 'bottom n', but only 4 lines for 'top n', when n=5. anyone else having this issue?

[@matthewhefferon]

I created the workbook on my Tableau public profile if you want to check it out tabsoft.co/3HS9A4B

[@tittybojangles1864]

Why is it that the tutorials using the Tableau datasets always work but applying the exact same steps to real world data always causes issues. Literally followed this step by step and my data looks nothing like this

[@matthewhefferon]

Too bad real company data isn't perfectly structured like the sample superstore data :)

[@tittybojangles1864]

@@matthewhefferon well I have a list of countries, a list of states, a list of payment amounts and a list of dates. Doesn't really get anymore simple than that.

[@matthewhefferon]

@@tittybojangles1864 your username just made me lol. Yeah that sounds like a very simple dataset.

[@devi.elvira]

Not working on me TT

[@sathiyalekha3830]

super....

[@jacobs4985]

It does not really work on the positive numbers

[@marianag8043]

the best

[@mutalukanyinemalili9201]

Mine brings back blanks ,

[@matthewhefferon]

I created the workbook on my Tableau public profile if you want to check it out tabsoft.co/3HS9A4B

[@Rhitzz21]

This guy sounds like Chris from Family Guy :')

[@veerandarla9147]

Good

[@agape13]

🏆

[@janagamasanthosh1087]

its lengthy try to say easy method

[@matthewhefferon]

Ok. Thanks