Yes, we can always do COALESCE() in your field definition but I would like to leave the SQL as it is and those parameters to only affect the visualisation
Many times I change my series’ names from NULL to “Unknown” if the series’ are categorical, and for display purposes I would love to see 0s for some measures (yes even if the underlying calculations do not take that 0 into account). It would be great to be able to define it as
dimension: type {
sql: ${TABLE}.type ;;
null_label: “Unknown”
}
measure: count {
type: count
sql: ${order_id} ;;
null_label: 0
}
Or to not confuse the types together:
dimension: type {
null: {
type: string
value: “Unknown”
}
}
measure: count {
null; {
type: integer
value: 0
}
}