What causes a 'having' clause in generated SQL?

Knowledge Drop

Last tested: Jan 31, 2019

A filter on a dimension will generally result in a WHERE clause, and a filter on a measure (aggregation) will result in a HAVING clause

See this doc