Submitted Orders

view: submitted_orders {
  sql_table_name: api.submitted_orders ;;

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

  dimension: actual_savings_compared_to_main_cost {
    type: number
    sql: ${TABLE}.actual_savings_compared_to_main_cost ;;
  }

  dimension: actual_savings_compared_to_main_time {
    type: number
    sql: ${TABLE}.actual_savings_compared_to_main_time ;;
  }

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

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

  dimension: address_details_postal_code {
    type: zipcode
    sql: ${TABLE}.address_details_postal_code ;;
  }

  dimension: address_details_residential {
    type: yesno
    sql: ${TABLE}.address_details_residential ;;
  }

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

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

  dimension: best_warehouse_cost {
    type: number
    sql: ${TABLE}.best_warehouse_cost ;;
  }

  dimension: best_warehouse_id {
    type: int
    sql: ${TABLE}.best_warehouse_id ;;
  }

  dimension: best_warehouse_main {
    type: yesno
    sql: ${TABLE}.best_warehouse_main ;;
  }

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

  dimension: best_warehouse_time {
    type: number
    sql: ${TABLE}.best_warehouse_time ;;
  }

  dimension: chosen_warehouse_cost {
    type: number
    sql: ${TABLE}.chosen_warehouse_cost ;;
  }

  dimension: chosen_warehouse_id {
    type: int
    sql: ${TABLE}.chosen_warehouse_id ;;
  }

  dimension: chosen_warehouse_main {
    type: yesno
    sql: ${TABLE}.chosen_warehouse_main ;;
  }

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

  dimension: chosen_warehouse_time {
    type: number
    sql: ${TABLE}.chosen_warehouse_time ;;
  }

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

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

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

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

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

  dimension: ideal_savings_compared_to_main_cost {
    type: number
    sql: ${TABLE}.ideal_savings_compared_to_main_cost ;;
  }

  dimension: ideal_savings_compared_to_main_time {
    type: number
    sql: ${TABLE}.ideal_savings_compared_to_main_time ;;
  }

  dimension: order_details_amount_charged {
    type: number
    sql: ${TABLE}.order_details_amount_charged ;;
  }

  dimension: order_details_units_count {
    type: number
    sql: ${TABLE}.order_details_units_count ;;
  }

  dimension: order_details_id {
    type: int
    sql: ${TABLE}.order_details_id ;;
  }

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

  dimension: order_id {
    type: int
    sql: ${TABLE}.order_id ;;
  }

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

  dimension: non_ideal_warehouse {
    label: "Shipped from non-Ideal Warehouse"
    description: "Chosen Warehouse did not match Best Warehouse"
    sql: ${TABLE}.chosen_warehouse_id != ${TABLE}.best_warehouse_id ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [best_warehouse_name, chosen_warehouse_name, context_library_name]
  }

  measure: total_units_count {
    type: sum
    sql: ${order_details_units_count} ;;
  }

  measure: average_units_count {
    type: average
    sql: ${order_details_units_count} ;;
  }
}

- view: submitted_orders
  sql_table_name: api.submitted_orders
  fields:
  - dimension: products
    sql: ${TABLE}.products
  - dimension: actual_savings_compared_to_main_cost
    type: number
    sql: ${TABLE}.actual_savings_compared_to_main_cost
  - dimension: actual_savings_compared_to_main_time
    type: number
    sql: ${TABLE}.actual_savings_compared_to_main_time
  - dimension: address_details_city
    sql: ${TABLE}.address_details_city
  - dimension: address_details_country
    sql: ${TABLE}.address_details_country
  - dimension: address_details_postal_code
    type: zipcode
    sql: ${TABLE}.address_details_postal_code
  - dimension: address_details_residential
    type: yesno
    sql: ${TABLE}.address_details_residential
  - dimension: address_details_state
    sql: ${TABLE}.address_details_state
  - dimension: address_details_street
    sql: ${TABLE}.address_details_street
  - dimension: best_warehouse_cost
    type: number
    sql: ${TABLE}.best_warehouse_cost
  - dimension: best_warehouse_id
    type: int
    sql: ${TABLE}.best_warehouse_id
  - dimension: best_warehouse_main
    type: yesno
    sql: ${TABLE}.best_warehouse_main
  - dimension: best_warehouse_name
    sql: ${TABLE}.best_warehouse_name
  - dimension: best_warehouse_time
    type: number
    sql: ${TABLE}.best_warehouse_time
  - dimension: chosen_warehouse_cost
    type: number
    sql: ${TABLE}.chosen_warehouse_cost
  - dimension: chosen_warehouse_id
    type: int
    sql: ${TABLE}.chosen_warehouse_id
  - dimension: chosen_warehouse_main
    type: yesno
    sql: ${TABLE}.chosen_warehouse_main
  - dimension: chosen_warehouse_name
    sql: ${TABLE}.chosen_warehouse_name
  - dimension: chosen_warehouse_time
    type: number
    sql: ${TABLE}.chosen_warehouse_time
  - dimension: context_library_name
    sql: ${TABLE}.context_library_name
  - dimension: context_library_version
    sql: ${TABLE}.context_library_version
  - dimension: event
    sql: ${TABLE}.event
  - dimension: event_id
    sql: ${TABLE}.event_id
  - dimension: event_text
    sql: ${TABLE}.event_text
  - dimension: ideal_savings_compared_to_main_cost
    type: number
    sql: ${TABLE}.ideal_savings_compared_to_main_cost
  - dimension: ideal_savings_compared_to_main_time
    type: number
    sql: ${TABLE}.ideal_savings_compared_to_main_time
  - dimension: order_details_amount_charged
    type: number
    sql: ${TABLE}.order_details_amount_charged
  - dimension: order_details_units_count
    type: number
    sql: ${TABLE}.order_details_units_count
  - dimension: order_details_id
    type: int
    sql: ${TABLE}.order_details_id
  - dimension: order_details_order_date
    sql: ${TABLE}.order_details_order_date
  - dimension: order_id
    type: int
    sql: ${TABLE}.order_id
  - dimension: user_id
    sql: ${TABLE}.user_id
  - dimension: non_ideal_warehouse
    label: Shipped from non-Ideal Warehouse
    description: Chosen Warehouse did not match Best Warehouse
    sql: ${TABLE}.chosen_warehouse_id != ${TABLE}.best_warehouse_id
  - dimension_group: received
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.received_at
  - dimension_group: sent
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.sent_at
  - measure: count
    type: count
    drill_fields:
    - best_warehouse_name
    - chosen_warehouse_name
    - context_library_name
  - measure: total_units_count
    type: sum
    sql: ${order_details_units_count}
  - measure: average_units_count
    type: average
    sql: ${order_details_units_count}