data.ml
LKML Ecommerce beverage

Shipments

Shipments model for ecommerce beverage.

inferred

Blocks

shipments.view.lkml · 68 lines
inferred 
view: shipments {
  sql_table_name: Deliveries ;;

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

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

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

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

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

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

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

  dimension: shipped_at {
    description: "in unix timestamp (number)"
    type: number
    sql: ${TABLE}.shipped_at ;;
  }

  dimension: ship_date {
    type: time
    sql: FROM_UNIXTIME(${TABLE}.shipped_at) ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  measure: total_packages {
    type: sum
    sql: ${TABLE}.num_packages ;;
  }

  measure: total_cost {
    type: sum
    value_format: "$#,##0.00"
    sql: ${TABLE}.cost ;;
  }

  measure: total_orders {
    type: count_distinct
    sql: ${TABLE}.swims_order_id ;;
  }
}
shipments.view.lookml · 43 lines
source-preserved 
- view: shipments
  sql_table_name: Deliveries
  fields:
  - dimension: id
    type: number
    sql: ${TABLE}.id
  - dimension: swims_order_id
    type: number
    sql: ${TABLE}.swims_order_id
  - dimension: cr1
    sql: ${TABLE}.cr1
  - dimension: shipping_id
    type: number
    sql: ${TABLE}.shipping_id
  - dimension: cost
    type: number
    sql: ${TABLE}.cost
  - dimension: num_packages
    type: number
    sql: ${TABLE}.num_packages
  - dimension: location
    sql: ${TABLE}.location
  - dimension: shipped_at
    type: number
    description: in unix timestamp (number)
    sql: ${TABLE}.shipped_at
  - dimension: ship_date
    type: time
    sql: FROM_UNIXTIME(${TABLE}.shipped_at)
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: total_packages
    type: sum
    sql: ${TABLE}.num_packages
  - measure: total_cost
    type: sum
    value_format: '$#,##0.00'
    sql: ${TABLE}.cost
  - measure: total_orders
    type: count_distinct
    sql: ${TABLE}.swims_order_id

Contents

  • shipments.view.lkml
  • shipments.view.lookml