Dynamic label. Get name from other dimension

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!

 

0 2 292
2 REPLIES 2
Top Labels in this Space
Top Solution Authors