Custom dimensions are created using dimension parameter. The dimension name should be unique in the view.
We can create custom dimensions from existing dimensions.
For example if we need to create Full Name using First Name & Last Name, we should create a custom dimension as below,
dimension: first_name {
type: string
sql: ${TABLE}.first_name ;;
}
dimension: last_name {
type: string
sql: ${TABLE}.last_name ;;
}
dimension: full_name {
type: string
sql: ${first_name} || ‘ ‘ || ${last_name} ;;
}
using case statement in custom dimensions,