Use Percentiles in Minimum and Maximum Filters
Percentiles filter according to a percentage of the data population that is automatically mapped to absolute values. For example, a maximum of 95% means that the top 5% of the samples are removed. A minimum of 5% means that the lowest 5% of the values are removed.
Activity Steps
- Navigate to the Data Component or Data Loader Component.
- Enter the Minimum or Maximum values as a percentage (for example, 95%).
The absolute value that the percentage translates to within the dataset displays next to the Min and Max fields in the Column tab. You may need to navigate to a different component and return to the Column tab to see this update.
The number of Rows displayed in the Filter and Data tab also change to reflect the new filters.
Notes:
Percentiles can be combined with top-cut values (@)and with < and >.
Percentile values are always relative to the full data set.