Remove Top and Bottom 5% of Records

Hello

I have a dataset of about 60k lines with only 3 columns of data. They data has outliers on both the high and low end of the data. Therefore, I would like to strip out the highest 5% and lowest 5% based on a specific column that is numeric. I am struggling on figuring out how to do this and am looking for any recommendations.

Thanks

Brian

Help

Accepted answers

Are you looking for something like the attached?

top bottom.png

- Sort the column of interest

- Record ID to get an incrementing number per record

- Summary to get a total count of records

- Append to have the count on each record

- Filter to remove the top and bottom 5 percent

remove top and bottom 5 pct.yxmd

All comments

Are you looking for something like the attached?

top bottom.png

- Sort the column of interest

- Record ID to get an incrementing number per record

- Summary to get a total count of records

- Append to have the count on each record

- Filter to remove the top and bottom 5 percent

remove top and bottom 5 pct.yxmd

Hello Joe,

This is exactly what I needed. Thank you!!!

Thanks

Brian

Is there a way to achieve the same result but for In-Database?

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703