In #37 we translate a LookML explore to a SQL view but only support measure with type: count. In this change we support all measure types.
Categories:
- Aggregate (
average, average_distinct, count_distinct, list, max, median_distinct, min, percentile, percentile_distinct, sum, sum_distinct). Allow these types and generate correct view SQL.
- Non-aggregate (
date, number, string, yesno). Allow these types, validate that the SQL expression is valid and of that type, generate correct SQL.
- Post (
percent_of_previous, percent_of_total, running_total). Include these values in the LookML schema, but give an error in the validator that post-aggregates are not supported.
In #37 we translate a LookML explore to a SQL view but only support measure with
type: count. In this change we support all measure types.Categories:
average,average_distinct,count_distinct,list,max,median_distinct,min,percentile,percentile_distinct,sum,sum_distinct). Allow these types and generate correct view SQL.date,number,string,yesno). Allow these types, validate that the SQL expression is valid and of that type, generate correct SQL.percent_of_previous,percent_of_total,running_total). Include these values in the LookML schema, but give an error in the validator that post-aggregates are not supported.