Help Centre › Building Processes
Find amounts far from the rest, overall or per supplier.
Add it to a process
In the process designer, open the Add step tab. Find Find unusual amounts under Process, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Rows | No | Variable holding the rows, or a plain list of amounts |
| Field | No | Field holding the amount, when the rows are records |
| Group field | No | Field to judge each group on its own (e.g. supplier) |
| Method | No | How to judge far (default: iqr) Choices: iqr, zscore. |
| Threshold | No | How far is far: inter-quartile ranges (default 1.5) or standard deviations (default 3) |
| Variable | No | Variable to store the result in (default: outliers) |
What it gives back
{outliers}– rows (each with position, value, typical and reason high or low) and summary
See all Process steps.