Hi @here Query is giving different results but the analysis engine is showing bit different cc: @future-teacher-7046 @fresh-football-47124

Which numbers are different?

@fresh-football-47124 count is 55/52 but its showing 477/365 in variation 0/1.

how have you defined that metric?

This is the metric query as count.

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

"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.

@future-teacher-7046 why we apply it with mean?

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.