Hi! I'm trying to set use an experiment with Ampli...
# ask-questionsr
red-artist-96080
10/23/2023, 9:29 PMHi! 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 valuef
fresh-football-47124
10/23/2023, 9:30 PM
Hi, you can’t edit it as a whole, but you can edit all parts of it
fresh-football-47124
10/23/2023, 9:31 PM
The main exposure query is on the data source page, under assignment queries
r
red-artist-96080
10/23/2023, 9:35 PMThanks for the quick reply, in the 'Experiment assignment queries'?
f
fresh-football-47124
10/23/2023, 9:36 PM
Yes
fresh-football-47124
10/23/2023, 9:36 PM
We then add the metric queries to that assignment one
fresh-football-47124
10/23/2023, 9:36 PM
Most of the time If there are errors it’s in the assignment query
r
red-artist-96080
10/23/2023, 9:39 PMHow would I modify the
__userMetricAggf
fresh-football-47124
10/23/2023, 9:41 PM
@future-teacher-7046 do you know?
f
future-teacher-7046
10/23/2023, 9:44 PM
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)
future-teacher-7046
10/23/2023, 9:46 PM
If you want to continue using strings and do something like COUNT DISTINCT, you can override the aggregation when setting up the metric:
r
red-artist-96080
10/23/2023, 9:47 PMAh allright, see if I can test that. Thanks!
66 Views