Hello !
I am trying to do a case when using two measures but I keep getting the same error and already tried everything said on the documentation.
Below is my code
measure: first_task_date {
label: "First task date"
description: "Date of the first task made on this lead"
sql: MIN(${task_ext.createddate_time}) ;;
}
✅ This measure on its own works
measure: tasktype {
type: string
sql: ${task_ext.type} ;;
}
? I created this measure “calling” a dimension from another table because it was suggested in this article
However it’s still saying I have the same problem
FYI this is what the info I really want looks like in my case when ??
measure: first_call_date {
label: "First Call Date"
description: "First call on the lead"
sql: CASE WHEN ${task_ext.type} = 'Call' then ${first_task_date}
ELSE null
END;;
}
Can someone help me please? 🙂