having trouble using filters in the SQL when i have a with statement (CTE), any idea what im doing wrong?
Hi @rjn
You cannot use table aliases together with Field Filters. Just remove ol alias and use full table reference.
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html#field-filter-gotchas
awesome, it worked. thanks!