https://www.growthbook.io/
Join Slack
Hi! I'm trying to set use an experiment with Amplitude and bigquery. However I'm running into issues...
# ask-questions
r
Hi! I'm trying to set use an experiment with Amplitude and bigquery. However I'm running into issues when trying to query the results. Any way I can alter the SQL for the whole query? I'd like to try 
SUM(COALESCE(value,"0")) AS value
f
Hi, you can’t edit it as a whole, but you can edit all parts of it
The main exposure query is on the data source page, under assignment queries
r
Thanks for the quick reply, in the 'Experiment assignment queries'?
f
Yes
We then add the metric queries to that assignment one
Most of the time If there are errors it’s in the assignment query
r
How would I modify the 
__userMetricAgg
in this case?
f
@future-teacher-7046 do you know?
f
In this case, it looks like the metric value you are selecting is a string when it needs to be a number (int or float)
If you want to continue using strings and do something like COUNT DISTINCT, you can override the aggregation when setting up the metric:
r
Ah allright, see if I can test that. Thanks!
79 Views
Open in Slack
PreviousNext
Powered by

GrowthBook Users

Open source platform for stress free deployments, measured impact, and smarter decisions.

Powered by