There is a bug with segments. They will not work f...
# give-feedback
m
There is a bug with segments. They will not work for us at all. We get
Syntax error: Expected ")" but got keyword WHERE at [83:13]
The generated query has two
where
keywords instead of an
and
Copy code
FROM
              `ga4-explorations`.`analytics_383872824`.`events_*`
            WHERE
              (
                (_TABLE_SUFFIX BETWEEN '20241115' AND '20250214')
                OR (
                  _TABLE_SUFFIX BETWEEN 'intraday_20241115' AND 'intraday_20250214'
                )
              )
            WHERE
              customer_type != 'pro'
Full query - found by selecting the segment on a metric analysis
f
@helpful-application-7107 do you know?
h
Investigating now.
Yes, this is a bug with Segments built on fact tables where you use a filter.
I'm working on a solution.
m
Thanks!
h
Just landed a fix for this. Should be live and working on our cloud app in the next ~5-10 minutes.
💙 1
m
Thanks! I'll check in about 20 mins
Sweet all seems to be working for us now. Thanks again!
🙌 1