Combining two date conditions with measurement

Looker Q&A Looker
1

What is the right filter syntax to identify when a new client we are measuring is showing activity and the date of this first activity appeared.

For example my objective is to identify when client X went live per the measurement minimum activity.

Thank you in advance,

2

Since we can’t use MIN/MAX with dates in Looker the best way to do it is to add this column in your data model and just expose it as a dimension.

You can use this:

measure: first_date {
    type: date
    sql: MIN(${TABLE}.activtiy_date ;;
}

but you won’t be able to use it as a filter because measure can’t be filtered by another measure