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

salmon-afternoon-55787

05/06/2022, 7:51 AM
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:
Copy code
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
Copy code
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 šŸ˜
f

fresh-football-47124

05/06/2022, 7:52 AM
hi Scott, thanks for that feedback
2 Views