Hi I m trying to set use an experiment with Amplitude and bi

Question

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`

fresh-football-47124 · Answer

Hi you can t edit it as a whole but you can edit all parts of it

fresh-football-47124 · Answer

The main exposure query is on the data source page under assignment queries

red-artist-96080 · Answer

Thanks for the quick reply in the Experiment assignment queries

fresh-football-47124 · Answer

Yes

fresh-football-47124 · Answer

We then add the metric queries to that assignment one

fresh-football-47124 · Answer

Most of the time If there are errors it s in the assignment query

red-artist-96080 · Answer

How would I modify the ` userMetricAgg` in this case

fresh-football-47124 · Answer

< future teacher 7046> do you know

future-teacher-7046 · Answer

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 · Answer

If you want to continue using strings and do something like COUNT DISTINCT you can override the aggregation when setting up the metric

red-artist-96080 · Answer

Ah allright see if I can test that Thanks