Knowledge Drop

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


Userlevel 5
Badge
  • Looker Staff
  • 171 replies

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.                


0 replies

Be the first to reply!

Reply