NULL label as parameter of field definition

Dawid
Participant V

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

  }

}
0 0 130
0 REPLIES 0
Top Labels in this Space
Top Solution Authors