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

gorgeous-toddler-76645

07/18/2023, 1:27 AM
Hi guys. Im having a problem of seeing the result of the experiment. For some reason it returned nothing. But the assignment query returned the data I wanted also the metric query. Does anyone know what will be reason ?appreciate any help🙏
f

fresh-football-47124

07/18/2023, 1:29 AM
you can share the queries?
g

gorgeous-toddler-76645

07/18/2023, 1:32 AM
Yeb, This is the metric query of
click
[img1]. This is the other metric query [img2].
f

fresh-football-47124

07/18/2023, 1:32 AM
what does the ‘view queries’ show when you are on the experiment page?
g

gorgeous-toddler-76645

07/18/2023, 1:34 AM
It returned
no rows returned
But the metric query and assignment query returned the data. So Im quite confuse now
f

fresh-football-47124

07/18/2023, 1:48 AM
you should be able to debug the query - we construct it with common table expressions
my guess would be that id’s arent matching correctly
as it looks to be sample data
g

gorgeous-toddler-76645

07/18/2023, 1:52 AM
Yeb, Because now the the mock from bigquery is mock up data. But I will continue to debug. Thanks
f

fresh-football-47124

07/18/2023, 7:29 AM
Let me know if you need more help
g

gorgeous-toddler-76645

07/20/2023, 12:12 AM
Thanks Graham. I finally get that fixed. It was because of the
experiment_id
didn't match.
f

fresh-football-47124

07/20/2023, 12:12 AM
ah cool
🙏 1
👏 1