Hi everyone
I was wondering if it's possible to define a label in a measure from the value string calculated in another dimension
dummy example:
dimension: cost_first_month_label{
type: string
sql: CASE WHEN ${TABLE}.date_month = X THEN ${TABLE}.date END ;;
}
Imagine that returns the current month ie: January 2025, and I want to use this string as label from a measure:
measure: cost_first_month{
type: number
label: field ${cost_first_month_label}
sql: CASE WHEN ${TABLE}.Order_Q = 1 THEN ${TABLE}.Cost END ;;
}
Thanks!