data.ml
LookML Ecommerce florist

Orders

Orders model for ecommerce florist.

source-preserved

Blocks

orders.view.lkml · 198 lines
inferred 
view: orders {
  sql_table_name: Orders ;;

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

  dimension: id {
    type: int
    hidden: yes
    sql: ${TABLE}.ID ;;
  }

  dimension: alt_visitor_id {
    hidden: yes
    sql: ${TABLE}.AltVisitorID ;;
  }

  dimension: browser_country {
    sql: ${TABLE}.BrowserCountry ;;
  }

  dimension: browser_id {
    hidden: yes
    sql: ${TABLE}.BrowserID ;;
  }

  dimension: channel_id {
    type: int
    hidden: yes
    sql: ${TABLE}.ChannelID ;;
  }

  dimension: customer_id {
    type: int
    hidden: yes
    sql: ${TABLE}.CustomerID ;;
  }

  dimension: discount {
    sql: ${TABLE}.Discount ;;
  }

  dimension: encryption_type_id {
    type: int
    hidden: yes
    sql: ${TABLE}.EncryptionTypeID ;;
  }

  dimension: is_follow_up {
    type: yesno
    sql: ${TABLE}.FollowUp  = 1 ;;
  }

  dimension: is_fraud_checked {
    type: yesno
    sql: ${TABLE}.FraudChecked = 1 ;;
  }

  dimension: fraud_score {
    type: number
    hidden: yes
    sql: ${TABLE}.FraudScore ;;
  }

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

  dimension: funeral_time {
    sql: ${TABLE}.FuneralTime ;;
  }

  dimension: google_order_number {
    hidden: yes
    sql: ${TABLE}.GoogleOrderNumber ;;
  }

  dimension: high_level_order_status_id {
    type: int
    sql: ${TABLE}.HighLevelOrderStatusID ;;
  }

  dimension: sub_order_status_id {
    type: int
    sql: ${TABLE}.idSubOrderStatus ;;
  }

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

  dimension: is_completed {
    type: yesno
    sql: ${TABLE}.OrderComplete = 1 ;;
  }

  dimension: is_started {
    type: yesno
    sql: ${start_date} IS NOT NULL ;;
  }

  dimension: order_status_id {
    type: int
    sql: ${TABLE}.OrderStatusID ;;
  }

  dimension: is_valid_order {
    type: yesno
    sql: ${TABLE}.HighLevelOrderStatusID ;;
  }

  dimension: partner_order_ref {
    hidden: yes
    sql: ${TABLE}.PartnerOrderRef ;;
  }

  dimension: re_order_voucher {
    sql: ${TABLE}.ReOrderVoucher ;;
  }

  dimension: session_id {
    hidden: yes
    sql: ${TABLE}.SessionID ;;
  }

  dimension: site_id {
    type: int
    hidden: yes
    sql: ${TABLE}.SiteID ;;
  }

  dimension: amount {
    sql: ${TABLE}.Total ;;
  }

  dimension: type_id {
    type: int
    sql: ${TABLE}.TypeID ;;
  }

  dimension: voucher_id {
    type: int
    sql: ${TABLE}.VoucherID ;;
  }

  dimension: is_first_purchase {
    type: yesno
    sql: ${order_sequence_number} = 1 ;;
  }

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

  dimension_group: order {
    type: time
    timeframes: [time, date, week, month, month_num, year, hod, dow]
    sql: ${TABLE}.OrderDate ;;
  }

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

  measure: count {
    type: count
  }

  measure: running_order_count {
    type: running_total
    sql: ${count} ;;
  }

  measure: total_amount {
    type: sum
    sql: ${amount} ;;
  }

  measure: average_amount {
    type: average
    sql: ${amount} ;;
  }

  measure: first_purchase_count {
    type: count
    sql: ${count} ;;
  }
}
orders.view.lookml · 138 lines
source-preserved 
- view: orders
  sql_table_name: Orders
  fields:
  - dimension: order_id
    primary_key: true
    hidden: true
    sql: ${TABLE}.OrderID
  - dimension: id
    type: int
    hidden: true
    sql: ${TABLE}.ID
  - dimension: alt_visitor_id
    hidden: true
    sql: ${TABLE}.AltVisitorID
  - dimension: browser_country
    sql: ${TABLE}.BrowserCountry
  - dimension: browser_id
    hidden: true
    sql: ${TABLE}.BrowserID
  - dimension: channel_id
    type: int
    hidden: true
    sql: ${TABLE}.ChannelID
  - dimension: customer_id
    type: int
    hidden: true
    sql: ${TABLE}.CustomerID
  - dimension: discount
    sql: ${TABLE}.Discount
  - dimension: encryption_type_id
    type: int
    hidden: true
    sql: ${TABLE}.EncryptionTypeID
  - dimension: is_follow_up
    type: yesno
    sql: ${TABLE}.FollowUp  = 1
  - dimension: is_fraud_checked
    type: yesno
    sql: ${TABLE}.FraudChecked = 1
  - dimension: fraud_score
    type: number
    hidden: true
    sql: ${TABLE}.FraudScore
  - dimension: fulfillment_partner_id
    type: int
    hidden: true
    sql: ${TABLE}.FulfillmentPartnerID
  - dimension: funeral_time
    sql: ${TABLE}.FuneralTime
  - dimension: google_order_number
    hidden: true
    sql: ${TABLE}.GoogleOrderNumber
  - dimension: high_level_order_status_id
    type: int
    sql: ${TABLE}.HighLevelOrderStatusID
  - dimension: sub_order_status_id
    type: int
    sql: ${TABLE}.idSubOrderStatus
  - dimension: occasion_id
    type: int
    sql: ${TABLE}.OccasionID
  - dimension: is_completed
    type: yesno
    sql: ${TABLE}.OrderComplete = 1
  - dimension: is_started
    type: yesno
    sql: ${start_date} IS NOT NULL
  - dimension: order_status_id
    type: int
    sql: ${TABLE}.OrderStatusID
  - dimension: is_valid_order
    type: yesno
    sql: ${TABLE}.HighLevelOrderStatusID
  - dimension: partner_order_ref
    hidden: true
    sql: ${TABLE}.PartnerOrderRef
  - dimension: re_order_voucher
    sql: ${TABLE}.ReOrderVoucher
  - dimension: session_id
    hidden: true
    sql: ${TABLE}.SessionID
  - dimension: site_id
    type: int
    hidden: true
    sql: ${TABLE}.SiteID
  - dimension: amount
    sql: ${TABLE}.Total
  - dimension: type_id
    type: int
    sql: ${TABLE}.TypeID
  - dimension: voucher_id
    type: int
    sql: ${TABLE}.VoucherID
  - dimension: is_first_purchase
    type: yesno
    sql: ${order_sequence_number} = 1
  - dimension_group: completed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.OrderCompletionTime
  - dimension_group: order
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - month_num
    - year
    - hod
    - dow
    sql: ${TABLE}.OrderDate
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.OrderStartTime
  - measure: count
    type: count
  - measure: running_order_count
    type: running_total
    sql: ${count}
  - measure: total_amount
    type: sum
    sql: ${amount}
  - measure: average_amount
    type: average
    sql: ${amount}
  - measure: first_purchase_count
    type: count
    sql: ${count}

Contents

  • orders.view.lkml
  • orders.view.lookml