data.ml
LKML Call center

Agent

Agent model for call center.

inferred

Blocks

agent.view.lkml · 82 lines
inferred 
view: agent {
  sql_table_name: User ;;

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

  dimension: uuid {
    sql: ${TABLE}.userUUID ;;
  }

  dimension: person_id {
    type: int
    hidden: yes
    sql: ${TABLE}.userPersonId ;;
  }

  dimension: login {
    sql: ${TABLE}.userLogin ;;
  }

  dimension: level {
    type: int
    sql: ${TABLE}.userLevel ;;
  }

  dimension: debug_level {
    type: yesno
    sql: ${TABLE}.userDebugLevel ;;
  }

  dimension: single_session {
    type: yesno
    sql: ${TABLE}.userSingleSession = 'Y' ;;
  }

  dimension: session_control {
    type: yesno
    sql: ${TABLE}.userSessionControl = 'Y' ;;
  }

  dimension: timezone {
    sql: ${TABLE}.userTimezone ;;
  }

  dimension: days_since_created {
    type: number
    sql: DATEDIFF(CURDATE(), ${created_date}) ;;
  }

  dimension: days_since_created_tier {
    type: tier
    sql: ${days_since_created} ;;
  }

  dimension: updated_time {
    type: date_time
    sql: ${TABLE}.userUpdatedOn ;;
  }

  dimension: suspended {
    type: yesno
    sql: ${TABLE}.userSuspended = 'Y' ;;
  }

  dimension: active {
    type: yesno
    sql: ${TABLE}.userActive = 'Y' ;;
  }

  dimension_group: created_date {
    type: date
    sql: ${TABLE}.userCreatedOn ;;
  }

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }
}
agent.view.lookml · 50 lines
source-preserved 
- view: agent
  sql_table_name: User
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.userId
  - dimension: uuid
    sql: ${TABLE}.userUUID
  - dimension: person_id
    type: int
    hidden: true
    sql: ${TABLE}.userPersonId
  - dimension: login
    sql: ${TABLE}.userLogin
  - dimension: level
    type: int
    sql: ${TABLE}.userLevel
  - dimension: debug_level
    type: yesno
    sql: ${TABLE}.userDebugLevel
  - dimension: single_session
    type: yesno
    sql: ${TABLE}.userSingleSession = 'Y'
  - dimension: session_control
    type: yesno
    sql: ${TABLE}.userSessionControl = 'Y'
  - dimension: timezone
    sql: ${TABLE}.userTimezone
  - dimension: days_since_created
    type: number
    sql: DATEDIFF(CURDATE(), ${created_date})
  - dimension: days_since_created_tier
    type: tier
    sql: ${days_since_created}
  - dimension: updated_time
    type: date_time
    sql: ${TABLE}.userUpdatedOn
  - dimension: suspended
    type: yesno
    sql: ${TABLE}.userSuspended = 'Y'
  - dimension: active
    type: yesno
    sql: ${TABLE}.userActive = 'Y'
  - dimension_group: created_date
    type: date
    sql: ${TABLE}.userCreatedOn
  - measure: count
    type: count_distinct
    sql: ${id}

Contents

  • agent.view.lkml
  • agent.view.lookml