-
45. Re: Top N, with everyone else as "Other"
Joe Mako Oct 3, 2011 2:29 PM (in response to Andy Cotgreave)Matt, go ahead and start a new thread, mention that you need the workbook made in 6.0, and it is okay to make up sample data, as long as it is representative of your situation, and I or someone else can provide help.
-
46. Re: Top N, with everyone else as "Other"
Matthew Feliciano Oct 3, 2011 2:33 PM (in response to Andy Cotgreave)Thanks Joe,
Our upgrade should happen this week so no need for the 6.0 workbook. I'll post a new thread if I run into challenges in the Re: Top n vs the rest thread.
-
47. Re: Top N, with everyone else as "Other"
Matthew Feliciano Oct 3, 2011 2:48 PM (in response to Andy Cotgreave)Lizz45ie
I managed to make it work with a countd if you would like to email me directly (so as not to add to this thead) feel free to do so. the way I did it may not be optimal (and I may change it once we upgrade to 6.1) but it works for now.
-
48. Re: Top N, with everyone else as "Other"
Matthew Feliciano Oct 3, 2011 2:50 PM (in response to Andy Cotgreave)Problem solved.
-
49. Re: Top N, with everyone else as "Other"
Rossella Blatt Vital Oct 1, 2013 2:47 PM (in response to Andy Cotgreave)Hi,
thanks for your posts. I learned a lot. I am trying to do the same thing, but I have an additional dimension on the rows shelf. For example, I need to display 20 clients and the top 10 exchanges of each client with the corresponding measure for that exchange. Anything that is not in the top 10 exchange should fall in the "OTHERS" category and being rolled up.
The image below show an example with two clients. The first dimension is called LEVEL 1 (it is actually a parameter that will correspond to different dimensions based on the user's selection). The second dimension is the SPLIT with OTHERS grouped.
I defined the calculated field Index (INDEX()) that ranks each SPLIT by addressing LEVEL 1 and SPLIT and sorts by T1 LOTS - GIVE IN:
"In top 10?" is a boolean calculated field defined as:
[Index] <= 10
and with the same Table Calculation configuration as Index.
The calculated field [SPLIT with OTHERS grouped (CLIENT OR EXCHANGE )] is defined as:
IF [In top 10?] THEN ATTR([SPLIT]) ELSE "OTHERS" END I can't figure out how to roll up all the others to 1 row and to sum the measure of all the "OTHERS".
Any idea?
Thanks in advance for your help.
Rossella
-
50. Re: Top N, with everyone else as "Other"
Chris Pham Feb 20, 2015 11:26 AM (in response to Richard Leeke)Is there a way to put an Index with and a color mark with a "Top N, with everyone else as 'Other'" view? I'm trying to get the columns similar to your workbook but have a barchart and rank in the view. (See attachment for example viz).
-
Example.PNG 14.4 KB
-
Top n RL with condense option.twbx 975.6 KB
-
-
51. Re: Top N, with everyone else as "Other"
Alexander Mou May 31, 2015 7:03 PM (in response to Chris Pham)Chris,
Still need a solution? This can be done.
Start a new thread and attach a mock up.
-
52. Re: Top N, with everyone else as "Other"
Chris Pham Jun 10, 2015 4:24 PM (in response to Alexander Mou)Alexander Mou Thanks for the follow up. I have figured this one out.
-
53. Re: Top N, with everyone else as "Other"
John Adubufuor Apr 29, 2016 10:21 AM (in response to Andy Cotgreave)Hi Everyone,
This thread is very impressive. I've posted a new discussion as many here were advised to. Here's a link to it.
Top N Group with Other Ranked By Max Date Group Record Counts (Not Total)
I've hit a wall and am hoping someone can help me overcome this.
I have Groups in my row and Dates (YrMo) in column. My end goal is to have a Top N with Other Groups where the ranking is based on the sum of records in the max date column only.
What I find is the Top N is always ranking based on the row grand total... where as I need it on the max yrmo column alone.
I've attached a sanitized workbook and screenshots to try and hope.
I'm hoping someone with greater Tableau skill then I can help
Thanks a tonne in advance
ja
This expanded view shows the Top 4 I actually want to return. Note the row total of the 5th > 4th
This collapsed view shows the current yrmo 5th Rccs in the Top 4. I want PtO) as above instead.
Sample Sanitized Workbook
-
54. Re: Top N, with everyone else as "Other"
John Adubufuor May 4, 2016 10:02 AM (in response to John Adubufuor)1 of 1 people found this helpful -
55. Re: Top N, with everyone else as "Other"
Christian Geuer Jun 8, 2016 8:30 AM (in response to Joe Mako)Hi Joe,
I have tried to add a percentage of total table calculation on sales. It returns the correct values for Top N, but does not aggregate the percentage for others. It actually shows the percentage of the 11th rank when Top N N=10.
any idea how can do a workaround calculation to display the correct percentage of others?
Thanks so much
Chris
-
56. Re: Top N, with everyone else as "Other"
Jothsna Rao Aug 30, 2016 11:20 AM (in response to Joe Mako)Hi Joe -
I applied what you did with Top_vendors_and_Other_example to my data and I was able to get upto the point where Tableau is separating out my top 10 agents from the "others". However, when I try to "condense Others", it is just picking out the one agent just below the top 10 instead of condensing all the others and showing me the total of Others. Can you please help?!
Thanks!
Jo
-
57. Re: Top N, with everyone else as "Other"
Kyle Boyce Aug 31, 2016 11:48 AM (in response to Jothsna Rao)I did the same thing. Make sure you're using the "Customer" measure and not the "Customer Name" Dimension. "Customer" will just list as "Others".
-
58. Re: Top N, with everyone else as "Other"
Kyle Boyce Aug 31, 2016 11:50 AM (in response to Christian Geuer)I have a similar issue. I want to show percent of total business as well for each of the top 10. then on the 11th or the Others line I want to show the percent of total minus the sum of the % from the Top N Customers. Having some issue with that calculation however. HELP!
I've tried this, but it doesn't work:
IF [In Top N?] THEN
[% of Total Rev]
ELSEIF ([Others?]) THEN
WINDOW_SUM([% of Total Rev]) - [% of Total Rev]
END
-
59. Re: Top N, with everyone else as "Other"
Kyle Boyce Aug 31, 2016 11:51 AM (in response to Kyle Boyce)the % of Total Rev calculation is an LOD:
SUM([Revenue])/MIN({SUM([Revenue])})