Hey! When using percentile capping on ratio metrics, it's not the value metric that is capped but rather the numerator (leaving the denominator untouched). This is not what I expected and I don't think this makes sense because for ratio metrics we care about the value of the metric and not the value of the numerator in isolation. My concrete example is looking at gross margins where I'm experiencing weird results which seems to be related to outliers. However, adding a percentile cap doesn't help since that just lowers the numerator making the % gross margin into a unrealistically low number which in turn will make it difficult to explain the data to others. Hope this made sense and let me know if I should clarify anything!

Are you using fact metrics for your ratio metric? In that case we cap both numerator and denominator and we would advise you to consider using fact metrics going forward.

Okay thanks! I'm not using a fact metric, but I guess I need to then.