Hi, when creating a ratio metric with capped value...
# ask-questions
n
Hi, when creating a ratio metric with capped value at 95%, is the numerator and denominator capped separately? or you cap the ratio per user?
h
Are you using a fact metric or a legacy metric?
n
fact metric. I think for legacy metric, they are capped separately, right?
h
Yes, that's right.
Just confirming.
The numerator and denominator are capped separately, we don't cap the ratio per user (this can get tricky in general for ratio metrics since sometimes the user level denominators can easily be 0).
n
Thank you Luke for the response. Just to confirm, this happens for both fact and legacy ratio metrics, correct?
h
Legacy ratio metrics are capped separately.
n
and what about fact metrics? because I see the capping option when creating ratio fact metric.
I see these values in the queries on GB for a fact ratio metric but want to make sure that the statistical engine is taking them into account as well, thanks in advance!
h
Yeah, they are capped separately also. They are used right in the SQL directly, so if you create another version of this metric without capping, you'll actually see the
main_sum
and
main_denominator
values for the uncapped metric increase.
n
perfect! thank you Luke and have a great day!