data.ml
LookML Service marketplace

Zendesk Users

Zendesk Users model for service marketplace.

source-preserved

Blocks

zendesk_users.view.lkml · 49 lines
inferred 
view: zendesk_users {
  sql_table_name: adminProd_zendesk_users ;;

  dimension: zendesk_id {
    type: int
  }

  dimension: account {
  }

  dimension: name {
  }

  dimension: email {
  }

  dimension: notes {
  }

  dimension: phone {
  }

  dimension: photo {
  }

  dimension: role {
  }

  dimension: company_user_id {
    type: int
  }

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

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

  measure: count {
    type: count_distinct
    sql: ${zendesk_id} ;;
  }
}
zendesk_users.view.lookml · 33 lines
source-preserved 
- view: zendesk_users
  sql_table_name: adminProd_zendesk_users
  fields:
  - dimension: zendesk_id
    type: int
  - dimension: account
  - dimension: name
  - dimension: email
  - dimension: notes
  - dimension: phone
  - dimension: photo
  - dimension: role
  - dimension: company_user_id
    type: int
  - dimension_group: last_login
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_login_at
  - dimension_group: zendesk_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.zendesk_created_at
  - measure: count
    type: count_distinct
    sql: ${zendesk_id}

Contents

  • zendesk_users.view.lkml
  • zendesk_users.view.lookml