data.ml
LKML Ecommerce florist

Dispatches

Dispatches model for ecommerce florist.

inferred

Blocks

dispatches.view.lkml · 131 lines
inferred 
view: dispatches {
  sql_table_name: Dispatches ;;

  dimension: dispatch_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.DispatchID ;;
  }

  dimension: carrier_id {
    type: int
    sql: ${TABLE}.CarrierID ;;
  }

  dimension: consignment_number {
    sql: ${TABLE}.ConsignmentNumber ;;
  }

  dimension: del_option_id {
    type: int
    hidden: yes
    sql: ${TABLE}.DelOptionID ;;
  }

  dimension: delivery_address_id {
    type: int
    hidden: yes
    sql: ${TABLE}.DeliveryAddressID ;;
  }

  dimension: delivery_discount {
    sql: ${TABLE}.DeliveryDiscount ;;
  }

  dimension: price {
    type: number
    sql: ${TABLE}.DeliveryPrice ;;
  }

  dimension: delivery_service_status {
    type: int
    sql: ${TABLE}.DeliveryServiceStatus ;;
  }

  dimension: delivery_time {
    sql: ${TABLE}.DeliveryTime ;;
  }

  dimension: dispatch_status_id {
    type: int
    sql: ${TABLE}.DispatchStatusID ;;
  }

  dimension: dispatch_type {
    sql: ${TABLE}.DispatchType ;;
  }

  dimension: fulfillment_partner_id {
    type: int
    sql: ${TABLE}.FulfillmentPartnerID ;;
  }

  dimension: message_card_id {
    type: int
    hidden: yes
    sql: ${TABLE}.MessageCardID ;;
  }

  dimension: number_of_boxes {
    type: number
    sql: ${TABLE}.numBoxes ;;
  }

  dimension: occasion_id {
    type: int
    sql: ${TABLE}.OccasionID ;;
  }

  dimension: is_occassion {
    type: yesno
    sql: ${occasion_id} IS NOT NULL ;;
  }

  dimension: order_id {
    hidden: yes
    sql: ${TABLE}.OrderID ;;
  }

  dimension: tracking_status_id {
    type: int
    sql: ${TABLE}.TrackingStatusID ;;
  }

  dimension_group: delivery {
    type: time
    timeframes: [date, week, month, hod]
    sql: ${TABLE}.DeliveryDate ;;
  }

  dimension_group: delivery_eta_end {
    type: time
    timeframes: [time, date]
    sql: ${TABLE}.DeliveryETAEnd ;;
  }

  dimension_group: delivery_eta_start {
    type: time
    timeframes: [time, date]
    sql: ${TABLE}.DeliveryETAStart ;;
  }

  dimension_group: dispatch {
    type: time
    timeframes: [time, date, week, month, hod]
    sql: ${TABLE}.DispatchDate ;;
  }

  measure: total_number_of_boxes {
    type: sum
    sql: ${number_of_boxes} ;;
  }

  measure: total_price_amount {
    type: sum
    sql: ${price} ;;
  }

  measure: count {
    type: count
  }
}
dispatches.view.lookml · 94 lines
source-preserved 
- view: dispatches
  sql_table_name: Dispatches
  fields:
  - dimension: dispatch_id
    type: int
    primary_key: true
    sql: ${TABLE}.DispatchID
  - dimension: carrier_id
    type: int
    sql: ${TABLE}.CarrierID
  - dimension: consignment_number
    sql: ${TABLE}.ConsignmentNumber
  - dimension: del_option_id
    type: int
    hidden: true
    sql: ${TABLE}.DelOptionID
  - dimension: delivery_address_id
    type: int
    hidden: true
    sql: ${TABLE}.DeliveryAddressID
  - dimension: delivery_discount
    sql: ${TABLE}.DeliveryDiscount
  - dimension: price
    type: number
    sql: ${TABLE}.DeliveryPrice
  - dimension: delivery_service_status
    type: int
    sql: ${TABLE}.DeliveryServiceStatus
  - dimension: delivery_time
    sql: ${TABLE}.DeliveryTime
  - dimension: dispatch_status_id
    type: int
    sql: ${TABLE}.DispatchStatusID
  - dimension: dispatch_type
    sql: ${TABLE}.DispatchType
  - dimension: fulfillment_partner_id
    type: int
    sql: ${TABLE}.FulfillmentPartnerID
  - dimension: message_card_id
    type: int
    hidden: true
    sql: ${TABLE}.MessageCardID
  - dimension: number_of_boxes
    type: number
    sql: ${TABLE}.numBoxes
  - dimension: occasion_id
    type: int
    sql: ${TABLE}.OccasionID
  - dimension: is_occassion
    type: yesno
    sql: ${occasion_id} IS NOT NULL
  - dimension: order_id
    hidden: true
    sql: ${TABLE}.OrderID
  - dimension: tracking_status_id
    type: int
    sql: ${TABLE}.TrackingStatusID
  - dimension_group: delivery
    type: time
    timeframes:
    - date
    - week
    - month
    - hod
    sql: ${TABLE}.DeliveryDate
  - dimension_group: delivery_eta_end
    type: time
    timeframes:
    - time
    - date
    sql: ${TABLE}.DeliveryETAEnd
  - dimension_group: delivery_eta_start
    type: time
    timeframes:
    - time
    - date
    sql: ${TABLE}.DeliveryETAStart
  - dimension_group: dispatch
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hod
    sql: ${TABLE}.DispatchDate
  - measure: total_number_of_boxes
    type: sum
    sql: ${number_of_boxes}
  - measure: total_price_amount
    type: sum
    sql: ${price}
  - measure: count
    type: count

Contents

  • dispatches.view.lkml
  • dispatches.view.lookml