-
1. Re: Top 10 Category Within Category.
Shinichiro MurakamiJan 28, 2016 4:43 PM (in response to jitan.chainani)
Jitan,
In sheet 2,
Filter "Trafficsourced"
Top 10 By Field, Views, Sum
Change Trraillertitle Filter to "Context" // this keeps top 10 after filtering.
Done.
Shin
-
Sample (2) rep.twbx 42.6 KB
-
-
2. Re: Top 10 Category Within Category.
Tableau kumar Jan 28, 2016 9:09 PM (in response to jitan.chainani)Hi,
check whether the following links help you.
Tableau Viz: Calculating Ranks in Tableau
Tableau BI: How to Create Ranks in Tableau
Best Regards
Kumar
-
3. Re: Top 10 Category Within Category.
jitan.chainani Jan 28, 2016 9:10 PM (in response to Shinichiro Murakami)Thank you Shinichiro!
One more questions - Can I do Top 10 as well as combine the remaining in same chart as Others?
Thanks again for your help,
Jitan
-
4. Re: Top 10 Category Within Category.
Shinichiro MurakamiJan 28, 2016 9:57 PM (in response to jitan.chainani)
Jitan,
Could you mark "correct answer" to show it's answered.
And yes, you can. use SET instead of filtering. (You need to remove filter)
Calculated Field
[Top X Detail]
if [Set Top10] then [Traffic Source Detail] else "_Other" end
(I put "_" to sort name easily with putting other on top)
Put field [Top X Detail] into color shelf.
Thanks,
Shin
-
Sample (2) rep2.twbx 45.0 KB
-
-
5. Re: Top 10 Category Within Category.
Rajeev Pandey Jan 28, 2016 10:42 PM (in response to jitan.chainani)Hi Jitan
Please have a look. It may be helpful.
If Index ()<= [ Show N Values] Then "Top N"
elseif Index () > (SIZE()- [ Show N Values]) then "Bottom N"
Else Str(SIZE()- 2*[ Show N Values])+Space(1)+ "others" End
if you want to follow the Set approach then see below
Warm regards,
Rajeev Pandey
-
Top N values.twbx 1.0 MB
-