Hey @helpful-application-7107! The capping is happening after aggregation, that part is correct.
The issue is that currently only the upper tail (95th percentile) is being capped, with no way to cap the lower tail (5th percentile).
The table below illustrates this perfectly — using dummy data as an example:
• User 1 has a Net Deposit of -£9,500 — a huge negative outlier with no way to cap it
• User 10 has a Net Deposit of £1,000 — capped at the 95th percentile (£300) ✅
You can see in the Mean Net Deposit summary at the bottom:
• No capping → -£891 — badly skewed
• Current (95th percentile only) → -£1,011 — the negative outliers are still dragging the mean down
• Requested (two-sided capping) → -£39 — far more representative
So the feature request is simply the ability to apply a lower-tail cap in addition to the existing upper-tail cap. Would this be possible to log as a feature request? 🙏