I’m trying to use a condition group, [A or (B and C)] but the field I want to reference in “C” is a custom measure. I’m not seeing my custom measure when I search for it. Is this known that custom measures can be used in conditions but not condition groups? Thanks.
Hi @Becca_Perry,
Quick heads-up: the Condition Group UI doesn’t support measures yet, and we don’t allow and/or filtering logic on measures in general.
- Why: combining aggregations (measures) with and/or filtering logic can get ambiguous. Depending on evaluation order and grouping, you might see different results. We want to avoid surprises.
- Status: we’re exploring designs that make this predictable and intuitive. No timeline yet, but we’ll update this thread when it’s ready.
If all the fields you need are in the same Explore, you can use an AQL condition expression as a workaround.
Example:
unique(cities.name, users.gender)
| filter(
cities.name ilike 'c%'
or (
revenue > 300000 and
users.gender == 'f'
)
)
