red-oxygen-69265
01/22/2022, 4:15 AM{
"dimensions": [
{
"dimension": "All",
"variations": [
{
"variation": null,
"stats": {
"mean": 1,
"count": 45409,
"stddev": 0
}
},
{
"variation": null,
"stats": {
"mean": 1,
"count": 4,
"stddev": 0
}
}
]
}
]
}
but according to bigquery is
am I missing something? why variation is null on dashboard?fresh-football-47124
red-oxygen-69265
01/22/2022, 4:33 AMfuture-teacher-7046
red-oxygen-69265
01/22/2022, 2:29 PM[
{
"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
}
}
]
}
]
}
future-teacher-7046
red-oxygen-69265
01/22/2022, 9:28 PM-- 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"
seems old. the one from master let me change idsfuture-teacher-7046
latest
tag for docker should point to the most recent commitred-oxygen-69265
01/23/2022, 1:13 AMfuture-teacher-7046
docker-compose pull growthbook
docker-compose stop growthbook
docker-compose up -d growthbook