so the where clause is likely filtering all those events out

additional fields like this on the assignment query, are used for dimensional analysis

if this is not always set on exposure, you can (and should) remove it or move it to a separate query on the dimensions page

This is my User Dimensions query and it doesn't include gender: select

parse_date('%Y%m%d',event_date) as date,

user_id,

user_properties.value.string_value as value

FROM (

`SELECT * FROM

analytics_209649058

.`events_*``

WHERE _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'

UNION ALL

`SELECT * FROM `analytics_209649058.events_intraday_*``

),

unnest(user_properties) as user_properties

where

user_properties.key = 'company_name'

and user_properties.value.string_value is not null

Basically, I can't find anywhere in the GrowthBook interface where gender is included, it seems to be automatic and unchangeable?

Another odd thing is that gender appears in the dimensions dropdown, but it is not selected, and it is not defined as a dimension in Dimensions. The only User Dimension I have is Company Name. I've tried creating a new experiment from scratch, but I see the same problem. I'm really stuck here!

OK, that's interesting. I assume there is some way to change the SQL so that it will return a field such as gender if it is present, but not filter out results that are missing that field. But that's a general SQL question and I can work that out in my own time.

THANK YOU

I think this is perhaps an example of how even small inconsistencies can confuse people...I've been round and round the interface looking for how to edit this query, but was looking for an edit icon, also I'd forgotten that this part of the Experiment query comes from the data source. Phew!