Knowledge Drop

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

Userlevel 5
  • Looker Staff
  • 173 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!