handsome-library-8912412/05/2022, 7:22 AM
helpful-application-710712/05/2022, 10:59 PM
handsome-library-8912412/06/2022, 6:37 AM
helpful-application-710712/12/2022, 5:07 PM
handsome-library-8912412/13/2022, 11:10 AM
green-jordan-8360901/10/2023, 2:16 PM
helpful-application-710701/10/2023, 5:56 PM
green-jordan-8360901/11/2023, 8:30 AM
To check if this final join gets any null (i.e. some users might be in the denominator and not in the numerator, therefore retrieving a null in
...all previous steps... , __stats as ( -- One row per variation/dimension with aggregations SELECT d.variation, d.dimension, SUM(IFF(m.value is null, 1, 0)) as num_nulls_numerator, SUM(IFF(d.value is null, 1, 0)) as num_nulls_denominator FROM __userDenominator d LEFT JOIN __userMetric m ON (d.user_id = m.user_id) GROUP BY d.variation, d.dimension ) select * FROM __stats
). That’s not the case, as this query retrieves 0 in both cases.
and std =
? Thanks a lot and let us know if we can help with anything else!
query_stddev / sqrt(num_users)
helpful-application-710701/11/2023, 3:18 PM
, can you share the results from the ratio metric?
and the values in your case are small (mean) and uncertain (variance), and the log approximation can suffer when the mean values are close to zero. We have a check built in
here that returns no meaningful information for the posterior distribution when this check fails, since the log approximation could be inexact.
green-jordan-8360901/11/2023, 3:49 PM
helpful-application-710701/11/2023, 3:51 PM