Hi, I need to add an extra where clause condition ...
# ask-questions
w
Hi, I need to add an extra where clause condition to exclude certain lines of data from a Data Source. I've made these changes in "Experiment Assignment Queries" in the Data Source (and when I run the code in BigQuery, it excludes the correct entries) but when I run Metrics in Growthbook, these entries are not removed from the results... The code in the "Experiment Assignment Queries" has had no effect on the results of the Metrics. Anyone know how to solve this?
1
Nevermind, found the solution through the AI assistant: "if you update the "Experiment Assignment Queries" in your Data Source to exclude certain `anonymous_id`s, then any A/B test (experiment analysis) that uses this Data Source will only include users/subjects that pass the conditions in your assignment query. However, if you run the metric on its own (outside the context of an experiment), the metric query will not be affected by the assignment query and will include all data unless you also add exclusion logic to the metric SQL itself."
f
you can edit the SQL for any metric as well
to exclude that data
but yes - it will not effect the results as the queries will be combined