[
  {
    "variation": "enabled",
    "dimension": "All",
    "users": "46267"
  },
  {
    "variation": "control",
    "dimension": "All",
    "users": "5"
  }
]

{
  "dimensions": [
    {
      "dimension": "All",
      "variations": [
        {
          "variation": null,
          "stats": {
            "mean": 1,
            "count": 46266,
            "stddev": 0
          }
        },
        {
          "variation": null,
          "stats": {
            "mean": 1,
            "count": 4,
            "stddev": 0
          }
        }
      ]
    }
  ]
}

-- Number of users in experiment
WITH __rawExperiment as (
    SELECT
      DATETIME(server_time) as timestamp,
      user_id,
      user_id as anonymous_id,
      experiment_id,
      variation_id

    FROM
      events
),
__experiment as (
  -- Viewed Experiment
  SELECT
    e.user_id as user_id,
    e.variation_id as variation,
    e.timestamp as actual_start,
    DATETIME_ADD(e.timestamp, INTERVAL 3 DAY) as conversion_end,
    DATETIME_SUB(e.timestamp, INTERVAL 30 MINUTE) as session_start
  FROM
    __rawExperiment e
  WHERE
    e.experiment_id = 'consolidated_apm_settings_panel_frontend'
    AND e.timestamp >= DATETIME "2022-01-18 04:11:00"
),
__distinctUsers as (
  -- One row per user/dimension/variation
  SELECT
    e.user_id,
    e.variation,
    'All' as dimension
  FROM
    __experiment e
  GROUP BY
    variation,
    dimension,
    e.user_id
) -- Count of distinct users in experiment per variation/dimension
SELECT
  variation,
  dimension,
  COUNT(*) as users
FROM
  __distinctUsers
GROUP BY
  variation,
  dimension
click to minimize

Warning: Expected 2 variation ids (0, 1), but database returned a different set (control, enabled).

"growthbook/growthbook:latest"