future-candle-10380
07/08/2022, 6:27 PMScreenshot - cloud and Screenshot - local you can see the data is exactly the same. In fact it’s taking from the same mixpanel production data store but the results are different. In cloud Chance to beat control is 50% and there is no Percent change graph. In local version it’s 36% with nice graph.
In files Screenshot - query cloud and Screenshot - query local you can see that the query result data is identical.
In files Screenshot - metric cloud and Screenshot - metric local you can see that the metric configuration is identical
In files Screenshot - experiment cloud and Screenshot - experiment local you can see that the experiment configuration is identical
When I export the transformed data that are going into the gbstats calculation it’s the same as in the query:
{
"var_id_map": {
"0": 0,
"1": 1
},
"var_names": [
"Small",
"Big"
],
"weights": [
0.5,
0.5
],
"type": "count",
"ignore_nulls": false,
"inverse": false,
"max_dimensions": 20,
"rows": [
{
"users": 16,
"count": 13,
"mean": 5.769230769230769,
"stddev": 7.148467787993196,
"dimension": "",
"variation": "0"
},
{
"users": 10,
"count": 8,
"mean": 5,
"stddev": 2.7386127875258306,
"dimension": "",
"variation": "1"
}
]
}
And when I run it through jupiter notebook I get exactly the same results (chanceToWin: 0.36) as in local version (see `Screenshot - notebook`:
{
"unknownVariations": [],
"dimensions": [
{
"dimension": "",
"srm": 0.23931654122149193,
"variations": [
{
"cr": 4.6875,
"value": 75,
"users": 16,
"stats": {
"users": 16,
"count": 13,
"stddev": 6.803611336557586,
"mean": 4.6875
}
},
{
"cr": 4,
"value": 40,
"users": 10,
"expected": -0.1466666666666666,
"chanceToWin": 0.3600440835131542,
"uplift": {
"dist": "lognormal",
"mean": -0.15860503017663863,
"stddev": 0.4426092654556529
},
"ci": [
-0.6415991584084633,
1.031741260830155
],
"risk": [
0.4933414277382564,
1.1808414277382564
],
"stats": {
"users": 10,
"count": 8,
"stddev": 3.2058973436118907,
"mean": 4
}
}
]
}
]
}
I can’t debug the cloud version but my suspicion is that the calculation is for some reason different than on local version and I am trying to figure out why.
Local commit: 16303dfba972b805bc3fcc5e6e6514cbf21a2209future-teacher-7046
future-candle-10380
07/08/2022, 7:16 PM