2 Replies Latest reply on Aug 19, 2019 12:12 PM by Philip Perrin

FILTER

Nolan Caprecho Aug 16, 2019 12:15 AM

HI ALL,

Just want to ask how to display the "Bottom (NO)" only even when you change the filters?

I used RANK function to display their ranks and I want to display the Bottom 7 airports only. But im having trouble displaying the bottom 7 because I have different filters that changes the ranks at the bottom. If my filter is 'Domestic' the last 7 ranks would be 21-27 but when changed to international it changes to 29-35. So i need to change my slicer again. Is there a way that when I change my filter it would automatically display the bottom 7?

THANKS

1. Re: FILTER

Philip Perrin Aug 19, 2019 11:18 AM (in response to Nolan Caprecho)

Hi there Nolan -
I think you need a context filter to accomplish this - let me do a quick test on some data, but I believe your bottom N filter, when added to context, will give you the results you are looking for.
Phil
Like Show 0 Likes(0)

Actions
2. Re: FILTER

Philip Perrin Aug 19, 2019 12:12 PM (in response to Philip Perrin)

Actually it is whatever else you are filtering on that needs to be added to context - not whatever you bottom N filter is. Post back if this works for you or if you still have questions!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

FILTER

1. Re: FILTER

2. Re: FILTER

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account