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 |