Hello fellow Lookers, I have a View file that contains a Measure to COUNT_DISTINCT Id’s.
I apply this Measure to the following Dimension:
dimension: monetary {
case: {
when: {
sql: ${TABLE}.monetary = 5 ;;
label: "High"
}
when: {
sql: ${TABLE}.monetary = 4 ;;
label: "High/Medium"
}
when: {
sql: ${TABLE}.monetary = 3 ;;
label: "Medium"
}
when: {
sql: ${TABLE}.monetary = 2 ;;
label: "Medium/Low"
}
when: {
sql: ${TABLE}.monetary = 1 ;;
label: "Low"
}
else: "unknown"
}
}
measure: at_risk_strategic {
type: count_distinct
sql: ${shopper_id} ;;
filters: {
field: monetary
value: "High,High/Medium"
}
}
As you can (hopefully) see, the at_risk_strategic Measure returns 2 different values, one count for “High” and one count for “High/Medium”. I then need to SUM these two counts, however, I am informed by Looker that I cannot perform aggregations like SUM on Measures.
Any help is solving this problem is greatly appreciated
