data.ml
LookML Ecommerce furniture

Order Sessions

Order Sessions model for ecommerce furniture.

source-preserved

Blocks

order_sessions.view.lkml · 72 lines
inferred 
view: order_sessions {
  sql_table_name: bi_tables.order_sessions ;;

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

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

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

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

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

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

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

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

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

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

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

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

  dimension_group: local_order {
    type: time
    timeframes: [time, date, week, month]
    convert_tz: no
    sql: ${TABLE}.local_order_date ;;
  }

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

  measure: count {
    type: count
  }
}
order_sessions.view.lookml · 50 lines
source-preserved 
- view: order_sessions
  sql_table_name: bi_tables.order_sessions
  fields:
  - dimension: order_id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.order_id
  - dimension: browser
    sql: ${TABLE}.browser
  - dimension: city
    sql: ${TABLE}.city
  - dimension: email
    sql: ${TABLE}.email
  - dimension: ip
    sql: ${TABLE}.ip
  - dimension: order_num
    type: int
    sql: ${TABLE}.order_num
  - dimension: os
    sql: ${TABLE}.os
  - dimension: region
    sql: ${TABLE}.region
  - dimension: session_campaign
    sql: ${TABLE}.session_campaign
  - dimension: session_medium
    sql: ${TABLE}.session_medium
  - dimension: session_source
    sql: ${TABLE}.session_source
  - dimension: type
    sql: ${TABLE}.type
  - dimension_group: local_order
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.local_order_date
  - dimension_group: order
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.order_date
  - measure: count
    type: count

Contents

  • order_sessions.view.lkml
  • order_sessions.view.lookml