Skip to main content
This parameter is functionally identical to always_having_sql, but uses filter syntax instead of SQL.
This parameter must reference measures, not dimensions. To filter on non-aggregated fields, use always_where_filters instead.
When defined, a filter will be inserted into the HAVING clause of the generated SQL block of all queries in the topic. Users with the Querier role can’t change this filter and it will be visible only in the underlying SQL of any queries. This filter is additive to any measure filters specified in the workbook.

​
Syntax

always_having_filters:
  <field_name>:
    <filter_operator>: <value>

​
Properties

​
always_having_filters
object
required
A map of measure names to filter conditions that are applied to the HAVING clause of all queries in the topic using filter syntax.

​
Examples

always_having_filters:
  users.count:
    greater_than: 5