Customer

view: customer {
  sql_table_name: tblCustomer ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.pk_CustomerID ;;
  }

  dimension: original_shipping_id {
    type: int
    sql: ${TABLE}.OrigShipID ;;
  }

  dimension: billing_address {
    sql: ${TABLE}.BillAddr ;;
  }

  dimension: billing_address_2 {
    sql: ${TABLE}.BillAddr2 ;;
  }

  dimension: billing_city {
    sql: ${TABLE}.BillCity ;;
  }

  dimension: billing_date_of_birth {
    type: date
    sql: ${TABLE}.BillDoB ;;
  }

  dimension: billing_email {
    sql: ${TABLE}.BillEmail ;;
  }

  dimension: billing_gender {
  }

  dimension: billing_first_name {
    sql: ${TABLE}.BillFirst ;;
  }

  dimension: billing_last_name {
    sql: ${TABLE}.BillLast ;;
  }

  dimension: billing_full_name {
    sql: ${TABLE}.BillFirst + ' ' + ${TABLE}.BillLast ;;
  }

  dimension: billing_phone_number {
    sql: ${TABLE}.BillPhone ;;
  }

  dimension: shipping_same_as_billing_info {
    type: yesno
    sql: ${TABLE}.BillShipSame='true' ;;
  }

  dimension: billing_state {
    sql: ${TABLE}.BillState ;;
  }

  dimension: billing_zip_code {
    sql: ${TABLE}.BillZip ;;
  }

  dimension: shipping_address {
    sql: ${TABLE}.ShipAddr ;;
  }

  dimension: shipping_address_2 {
    sql: ${TABLE}.ShipAddr2 ;;
  }

  dimension: shipping_city {
    sql: ${TABLE}.ShipCity ;;
  }

  dimension: shipping_date_of_birth {
    type: date
    sql: ${TABLE}.ShipDoB ;;
  }

  dimension: shipping_email {
    sql: ${TABLE}.ShipEmail ;;
  }

  dimension: shipping_gender {
  }

  dimension: shipping_first_name {
    sql: ${TABLE}.ShipFirst ;;
  }

  dimension: shipping_last_name {
    sql: ${TABLE}.ShipLast ;;
  }

  dimension: shipping_full_name {
    sql: ${TABLE}.ShipFirst + ' ' + ${TABLE}.ShipLast ;;
  }

  dimension: shipping_phone_number {
    sql: ${TABLE}.ShipPhone ;;
  }

  dimension: shipping_state {
    sql: ${TABLE}.ShipState ;;
  }

  dimension: shipping_zip_code {
    sql: ${TABLE}.ShipZip ;;
  }

  dimension: billing_age_now {
    type: number
    sql: CASE
  WHEN ${billing_date_of_birth} IS NOT NULL
  THEN FLOOR(DATEDIFF(day, ${billing_date_of_birth}, getDate()) / 365.25)
  ELSE NULL
END ;;
  }

  dimension: billing_age_during_order {
    type: number
    sql: CASE
  WHEN ${billing_date_of_birth} IS NOT NULL
  THEN FLOOR(DATEDIFF(day, ${billing_date_of_birth}, ${call.call_date}) / 365.25)
  ELSE NULL
END ;;
  }

  dimension: age_bracket {
    type: tier
    sql: ${billing_age_during_order} ;;
  }

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }
}

- view: customer
  sql_table_name: tblCustomer
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.pk_CustomerID
  - dimension: original_shipping_id
    type: int
    sql: ${TABLE}.OrigShipID
  - dimension: billing_address
    sql: ${TABLE}.BillAddr
  - dimension: billing_address_2
    sql: ${TABLE}.BillAddr2
  - dimension: billing_city
    sql: ${TABLE}.BillCity
  - dimension: billing_date_of_birth
    type: date
    sql: ${TABLE}.BillDoB
  - dimension: billing_email
    sql: ${TABLE}.BillEmail
  - dimension: billing_gender
  - dimension: billing_first_name
    sql: ${TABLE}.BillFirst
  - dimension: billing_last_name
    sql: ${TABLE}.BillLast
  - dimension: billing_full_name
    sql: ${TABLE}.BillFirst + ' ' + ${TABLE}.BillLast
  - dimension: billing_phone_number
    sql: ${TABLE}.BillPhone
  - dimension: shipping_same_as_billing_info
    type: yesno
    sql: ${TABLE}.BillShipSame='true'
  - dimension: billing_state
    sql: ${TABLE}.BillState
  - dimension: billing_zip_code
    sql: ${TABLE}.BillZip
  - dimension: shipping_address
    sql: ${TABLE}.ShipAddr
  - dimension: shipping_address_2
    sql: ${TABLE}.ShipAddr2
  - dimension: shipping_city
    sql: ${TABLE}.ShipCity
  - dimension: shipping_date_of_birth
    type: date
    sql: ${TABLE}.ShipDoB
  - dimension: shipping_email
    sql: ${TABLE}.ShipEmail
  - dimension: shipping_gender
  - dimension: shipping_first_name
    sql: ${TABLE}.ShipFirst
  - dimension: shipping_last_name
    sql: ${TABLE}.ShipLast
  - dimension: shipping_full_name
    sql: ${TABLE}.ShipFirst + ' ' + ${TABLE}.ShipLast
  - dimension: shipping_phone_number
    sql: ${TABLE}.ShipPhone
  - dimension: shipping_state
    sql: ${TABLE}.ShipState
  - dimension: shipping_zip_code
    sql: ${TABLE}.ShipZip
  - dimension: billing_age_now
    type: number
    sql: CASE
  WHEN ${billing_date_of_birth} IS NOT NULL
  THEN FLOOR(DATEDIFF(day, ${billing_date_of_birth}, getDate()) / 365.25)
  ELSE NULL
END
  - dimension: billing_age_during_order
    type: number
    sql: CASE
  WHEN ${billing_date_of_birth} IS NOT NULL
  THEN FLOOR(DATEDIFF(day, ${billing_date_of_birth}, ${call.call_date}) / 365.25)
  ELSE NULL
END
  - dimension: age_bracket
    type: tier
    sql: ${billing_age_during_order}
  - measure: count
    type: count_distinct
    sql: ${id}