https://www.growthbook.io/ logo
h

handsome-library-89124

10/04/2022, 7:40 AM
Hi @here Query is giving different results but the analysis engine is showing bit different cc: @future-teacher-7046 @fresh-football-47124
f

fresh-football-47124

10/04/2022, 7:41 AM
Which numbers are different?
h

handsome-library-89124

10/04/2022, 7:42 AM
@fresh-football-47124 count is 55/52 but its showing 477/365 in variation 0/1.
f

fresh-football-47124

10/04/2022, 8:11 AM
how have you defined that metric?
h

handsome-library-89124

10/04/2022, 8:13 AM
This is the metric query as count.
Copy code
SELECT 
c_user_id, cuserid as value,
experimentvariationid AS variation_id,
max(timestamp) AS timestamp,
FROM `EXPERIMENTS_*` 
WHERE cuserid is not null
group by experimentvariationid,cuserid
f

future-teacher-7046

10/04/2022, 10:12 AM
"count" in the query result actually refers to the denominator and is usually the same as the number of users. The 477/365 part comes from multiplying the mean by the count.
1
h

handsome-library-89124

10/06/2022, 12:51 PM
@future-teacher-7046 why we apply it with mean?
f

future-teacher-7046

10/06/2022, 1:19 PM
We could have selected sum and then divided by the denominator to get the mean if we wanted. No real reason why we went with the method we did.
1