Use Top-Cut Values in Minimum and Maximum Filters

Minimum and maximum filters remove data from the dataset. Top-cutting (or bottom-cutting) values allows you to keep all samples but remove the effect of extreme values on data analysis. For example, for a dataset with most samples with values below 10 and some values as high as 200, you can use the top-cut feature to set those high values to a 10 instead of removing them altogether.

Activity Steps

1. Navigate to the Data Component or Data Loader Component.
2. Enter the Minimum or Maximum values as an absolute number preceded an @ symbol (for example, @10).

   The top-cut value displays next to the Min and Max fields in the Column tab.You may need to navigate to a different window and return to the Column tab for this to display.

   The number of Rows displayed in the Filter and Data tab remains the same.

Note: To combine percentiles and top-cuts (for example, to cut the highest 5% values to the 95% percentile value), combine the @ symbol with the % symbol (for example, @10%). When the value that is associated with a given percentile falls between two data points an interpolated value is used, meaning that the maximum or minimum value that you see is not always a value of any specific data point.