Orders

view: orders {
  sql_table_name: genericdb.demandorderheader ;;

  dimension: adj_merchandise_total {
    type: number
    sql: ${TABLE}.adjMerchandiseTotal ;;
  }

  dimension: adj_shipping_total {
    type: number
    sql: ${TABLE}.adjShippingTotal ;;
  }

  dimension: billing_address1 {
    sql: ${TABLE}.billingAddress1 ;;
  }

  dimension: billing_address2 {
    sql: ${TABLE}.billingAddress2 ;;
  }

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

  dimension: billing_country {
    sql: ${TABLE}.billingCountry ;;
  }

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

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

  dimension: billing_phone {
    sql: ${TABLE}.billingPhone ;;
  }

  dimension: billing_postal_code {
    sql: ${TABLE}.billingPostalCode ;;
  }

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

  dimension: created_by {
    sql: ${TABLE}.createdBy ;;
  }

  dimension: customer_email {
    sql: ${TABLE}.customerEmail ;;
  }

  dimension: customer_id {
    sql: ${TABLE}.customerId ;;
  }

  dimension: customer_name {
    sql: ${TABLE}.customerName ;;
  }

  dimension: demand_order_id {
    sql: ${TABLE}.demandOrderId ;;
  }

  dimension: merchandise_total {
    type: number
    sql: ${TABLE}.merchandiseTotal ;;
  }

  dimension: order_subtotal {
    type: number
    sql: ${TABLE}.orderSubtotal ;;
  }

  dimension: order_tax {
    type: number
    sql: ${TABLE}.orderTax ;;
  }

  dimension: order_total {
    type: number
    sql: ${TABLE}.orderTotal ;;
  }

  dimension: orig_customer_email {
    sql: ${TABLE}.origCustomerEmail ;;
  }

  dimension: shipment_method {
    sql: ${TABLE}.shipmentMethod ;;
  }

  dimension: shipment_name {
    sql: ${TABLE}.shipmentName ;;
  }

  dimension: shipping_address1 {
    sql: ${TABLE}.shippingAddress1 ;;
  }

  dimension: shipping_address2 {
    sql: ${TABLE}.shippingAddress2 ;;
  }

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

  dimension: shipping_country {
    sql: ${TABLE}.shippingCountry ;;
  }

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

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

  dimension: shipping_phone {
    sql: ${TABLE}.shippingPhone ;;
  }

  dimension: shipping_postal_code {
    sql: ${TABLE}.shippingPostalCode ;;
  }

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

  dimension: shipping_total {
    type: number
    sql: ${TABLE}.shippingTotal ;;
  }

  dimension: sr_token {
    sql: ${TABLE}.srToken ;;
  }

  dimension: user_agent {
    sql: ${TABLE}.userAgent ;;
  }

  dimension: utm_source {
    sql: ${TABLE}.utm_source ;;
  }

  dimension_group: order_dtm {
    type: time
    timeframes: [time, date, week, month, month_num, day_of_week, year]
    sql: ${TABLE}.orderDtm ;;
  }

  dimension_group: sr_send_dtm {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.srSendDtm ;;
  }

  measure: total_adj_merch_total {
    description: "Includes Merch, not Shipping, after POS Promos and Discounts"
    type: sum
    value_format: "$#.00"
    sql: ${adj_merchandise_total} ;;
  }

  measure: average_adj_merchandise_total {
    description: "Includes Merch, not Shipping, after POS Promos and Discounts"
    type: average
    value_format: "$#.00"
    sql: ${adj_merchandise_total} ;;
  }

  measure: count {
    type: count
    drill_fields: [customer_name, order_subtotal, adj_merchandise_total, order_dtm_date]
  }
}

- view: orders
  sql_table_name: genericdb.demandorderheader
  fields:
  - dimension: adj_merchandise_total
    type: number
    sql: ${TABLE}.adjMerchandiseTotal
  - dimension: adj_shipping_total
    type: number
    sql: ${TABLE}.adjShippingTotal
  - dimension: billing_address1
    sql: ${TABLE}.billingAddress1
  - dimension: billing_address2
    sql: ${TABLE}.billingAddress2
  - dimension: billing_city
    sql: ${TABLE}.billingCity
  - dimension: billing_country
    sql: ${TABLE}.billingCountry
  - dimension: billing_first_name
    sql: ${TABLE}.billingFirstName
  - dimension: billing_last_name
    sql: ${TABLE}.billingLastName
  - dimension: billing_phone
    sql: ${TABLE}.billingPhone
  - dimension: billing_postal_code
    sql: ${TABLE}.billingPostalCode
  - dimension: billing_state
    sql: ${TABLE}.billingState
  - dimension: created_by
    sql: ${TABLE}.createdBy
  - dimension: customer_email
    sql: ${TABLE}.customerEmail
  - dimension: customer_id
    sql: ${TABLE}.customerId
  - dimension: customer_name
    sql: ${TABLE}.customerName
  - dimension: demand_order_id
    sql: ${TABLE}.demandOrderId
  - dimension: merchandise_total
    type: number
    sql: ${TABLE}.merchandiseTotal
  - dimension: order_subtotal
    type: number
    sql: ${TABLE}.orderSubtotal
  - dimension: order_tax
    type: number
    sql: ${TABLE}.orderTax
  - dimension: order_total
    type: number
    sql: ${TABLE}.orderTotal
  - dimension: orig_customer_email
    sql: ${TABLE}.origCustomerEmail
  - dimension: shipment_method
    sql: ${TABLE}.shipmentMethod
  - dimension: shipment_name
    sql: ${TABLE}.shipmentName
  - dimension: shipping_address1
    sql: ${TABLE}.shippingAddress1
  - dimension: shipping_address2
    sql: ${TABLE}.shippingAddress2
  - dimension: shipping_city
    sql: ${TABLE}.shippingCity
  - dimension: shipping_country
    sql: ${TABLE}.shippingCountry
  - dimension: shipping_first_name
    sql: ${TABLE}.shippingFirstName
  - dimension: shipping_last_name
    sql: ${TABLE}.shippingLastName
  - dimension: shipping_phone
    sql: ${TABLE}.shippingPhone
  - dimension: shipping_postal_code
    sql: ${TABLE}.shippingPostalCode
  - dimension: shipping_state
    sql: ${TABLE}.shippingState
  - dimension: shipping_total
    type: number
    sql: ${TABLE}.shippingTotal
  - dimension: sr_token
    sql: ${TABLE}.srToken
  - dimension: user_agent
    sql: ${TABLE}.userAgent
  - dimension: utm_source
    sql: ${TABLE}.utm_source
  - dimension_group: order_dtm
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - month_num
    - day_of_week
    - year
    sql: ${TABLE}.orderDtm
  - dimension_group: sr_send_dtm
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.srSendDtm
  - measure: total_adj_merch_total
    type: sum
    description: Includes Merch, not Shipping, after POS Promos and Discounts
    value_format: '$#.00'
    sql: ${adj_merchandise_total}
  - measure: average_adj_merchandise_total
    type: average
    description: Includes Merch, not Shipping, after POS Promos and Discounts
    value_format: '$#.00'
    sql: ${adj_merchandise_total}
  - measure: count
    type: count
    drill_fields:
    - customer_name
    - order_subtotal
    - adj_merchandise_total
    - order_dtm_date