Hi team. Further to @numerous-hospital-35835’s issue above, I'm running into this warning on the Results tab of a new binomial experiment:

Warning: Missing data from the following variation ids: 0

I'm using a MySQL data source and the final query is not returning a row for variation 0 as it has no recorded metrics. I believe changing the final query to

SELECT
  u.variation,
  u.dimension,
  COALESCE (s.count, 0) as count,
  COALESCE (s.mean, 0) as mean,
  COALESCE (s.stddev, 0) as stddev,
  u.users
FROM
  __stats s
  RIGHT JOIN __overallUsers u ON (
    s.variation = u.variation
    AND s.dimension = u.dimension
  )

would produce the correct result, but understand that you'll want to test to see what else is affected 😁

hi Scott, thanks for that feedback