Populate earliest date of status at item level in each row

Looker Q&A Looker
,
1

Hi Guys,

I am a beginner in Looker and trying to achieve below requirement.

Data set :

Item_id created_date status_date status

I1 10-Mar 12-Mar Ready

I1 10-Mar 15-Mar Delivered

Desired Output:

Item_id created_date status_date status earliest_status_date

I1 10-Mar 12-Mar Ready 12-Mar

I1 10-Mar 15-Mar Delivered 12-Mar

2

You can try this hack: https://help.looker.com/hc/en-us/articles/360023425454-Max-or-Min-Date-Measure

measure: earliest_start_date {
  type:date
  sql: MIN(${status_date}) ;;
}