Index

Category Data Type Support Status Recommended Approach
Dimension time Supported NA
Dimension string Supported NA
Dimension number Supported NA
Dimension boolean Supported NA
Measure max Supported NA
Measure min Supported NA
Measure number Supported NA
Measure sum Supported NA
Measure count Supported NA
Measure boolean Auto-converts to Dimension NA
Measure string Auto-converts to Dimension NA
Measure time Auto-converts to Dimension NA
Measure avg Not Supported Option 1: To use measure of type ‘avg’, define an additional measure of type 'count' in that entity:name: count type: count sql: '1' Option 2: Use measure of type 'number' and define average logic in SQL: measures:  - name: total_accounts     type: number     sql: "avg({accounts})”
Measure count_distinct Not Supported Option 1: To use measure of type ‘count_distinct’, additionally define a measure of type 'count' in that entity: name: counttype: countsql: '1' Option 2: Or, use measure of type 'number' and define logic for count_distinct in SQL: measures:  - name: total_accounts     type: number sql: "count(distinct({accounts}))”
Measure count_distinct_approx Not Supported NA
Rolling Window - Supported NA