Why does`type: min`or `type: max` on a raw time field return NULL?

Knowledge Drop

Last tested: March 2021

The min and max type only work for numbers. You will want to use a `date` type and do the aggregation in SQL.

 measure: last_updated_date { type: date sql: MAX(${updated_raw}) convert_tz: no}

This content is subject to limited support.                

Version history
Last update:
‎04-05-2021 09:07 AM
Updated by: