Hi guys,
For one of my ab test I'm not able to Que...
# announcementss
straight-businessperson-54316
12/16/2021, 8:47 AMHi guys,
For one of my ab test I'm not able to Query the results. I got this error. My source is Mixpanel
f
future-teacher-7046
12/16/2021, 12:36 PM
Hmm. Haven't seen that error before. Can you send me the query result tables in that modal so I can reproduce it?
s
straight-businessperson-54316
12/17/2021, 7:51 AMHi Jeremy. It's weird... the error has changed. Look at it.
straight-businessperson-54316
12/17/2021, 7:56 AM Copy code
| | dimension | variation | users | metrics |
|--- |--- |--- |--- |--- |
| 0 | "" | "control" | 426 | [{"metric":"met_19g614kx7koqy6","users":426,"count":0,"mean":null,"stddev":null},{"metric":"met_19g614kx7knbhj","users":426,"count":56,"mean":1,"stddev":0}] |
| 1 | "" | "finance_partner_is_ace" | 406 | [{"metric":"met_19g614kx7koqy6","users":406,"count":0,"mean":null,"stddev":null},{"metric":"met_19g614kx7knbhj","users":406,"count":29,"mean":1,"stddev":0}] |straight-businessperson-54316
12/17/2021, 7:56 AMHere is the query result
f
future-teacher-7046
12/17/2021, 3:21 PM
ok, thanks. I'm guessing it has to do with the mean and stddev being null for one of the metrics.
s
straight-businessperson-54316
12/17/2021, 3:34 PMOk. Is that the expected behavior?
f
future-teacher-7046
12/17/2021, 4:10 PM
no, I'm working on coercing those values to always be numbers before sending them to our stats engine.
s
straight-businessperson-54316
12/17/2021, 4:14 PMOk cool. Thanks you Jeremy
f
future-teacher-7046
12/17/2021, 4:36 PM
Pushing out a fix now. Will be live in about 10 minutes
future-teacher-7046
12/17/2021, 4:37 PM
I don't think this will fix the original error you saw, which I'm guessing can happen really early in a test when there is very little data. If it happens again, can you let me know and send me the query results?
95 Views