7 Replies Latest reply on Oct 6, 2016 6:38 AM by Shinichiro Murakami

Filter the middle of the pack

Hey guys, I'm trying to figure out how to filter to just the median value plus five above and five below. For example - if the median value is 46, I want the filter to display 41-51. I found the filter option that lets you filter just the top n or bottom n, but I want the middle n, based on the most recent year. Does anyone know how to do this without writing SQL? I'm attaching my worksheet for reference, but I haven't attempted any calculations. Or rather, I haven't included any of my pitiful attempts at calculated fields.

Thanks!

• 1. Re: Filter the middle of the pack

Hi there,

In your example, which dimension would you like to use as filter for getting the middle n values?

Thanks,

Dhanashree

• 2. Re: Filter the middle of the pack

I couldn't open your twbx because of version.

I did an example with superstore. In my twbx status 'Verdadeiro(True)' is for Subcategories with average between total average + 1000 and avarage - 1000

• 3. Re: Filter the middle of the pack

For instance, if you wanted to filter on Research Rank, then when you drag it to filter pane, you can pick MEDIAN as one of the ways and it will give you range that you can customize. Is that resonating?

• 4. Re: Filter the middle of the pack

Not exact, but kind of things?

[Reserch Rank latest Year]

[Count Scoool last year]

{fixed:count([Reserch Rank latest Year])}

[Filter Median]

[Reserch Rank latest Year]>=(([Count Scoool last year]/2-[Median X]))

and

[Reserch Rank latest Year]<=(([Count Scoool last year]/2+[Median X]))

Thanks,

Shin

1 of 1 people found this helpful
• 5. Re: Filter the middle of the pack

Thank you soooooo much! This worked perfectly!

• 6. Re: Filter the middle of the pack

Thank you to all you chipped in! I found my answer.

• 7. Re: Filter the middle of the pack

You are very welcome.

Analog solution.

Thanks,

Shin