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
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}) ;;
}