5 Replies Latest reply on Jan 28, 2016 10:42 PM by Rajeev Pandey

Top 10 Category Within Category.

jitan.chainani Jan 28, 2016 3:25 PM

Hi Guys,

I need your help in my dashboard that I have been working on. The dashboard displays views for different videos and source of those videos.

I wanted to get the top 10 sources within a video. Have created a action filter so that the data becomes responsive for both the charts.

Can you give me some suggestions on how i can do a top 10 category within a category? In the screen shot below if some clicks on video 7 (blue box) I would need the top 10 sources for the blue in second chart.

Thanks for your help,

Jitan

Sample.twbx 46.7 KB

1. Re: Top 10 Category Within Category.

Shinichiro Murakami Jan 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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
4. Re: Top 10 Category Within Category.

Shinichiro Murakami Jan 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

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
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
http://www.tableaulearners.com

Top N values.twbx 1.0 MB

2 of 2 people found this helpful
Like Show 1 Likes(1)

Actions