data.ml
LookML Ecommerce window treatments

Lead Employee

Lead Employee model for ecommerce window treatments.

source-preserved

Blocks

lead_employee.view.lkml · 44 lines
inferred 
view: lead_employee {
  sql_table_name: commission.lead_employee ;;

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

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

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

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

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

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

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

  measure: count_associated_people {
    type: count
    drill_fields: [detail*]
  }
}
lead_employee.view.lookml · 29 lines
source-preserved 
- view: lead_employee
  sql_table_name: commission.lead_employee
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: added_date
    type: int
    sql: ${TABLE}.added_date
  - dimension: created_time
    type: number
    sql: ${TABLE}.created_time
  - dimension: lead_id
    type: int
    sql: ${TABLE}.lead_id
  - dimension: modified_time
    type: number
    sql: ${TABLE}.modified_time
  - dimension: showroom_id
    type: int
    sql: ${TABLE}.showroom_id
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - measure: count_associated_people
    type: count
    drill_fields:
    - detail*

Contents

  • lead_employee.view.lkml
  • lead_employee.view.lookml