users.view.lookml

- view: users
  sql_table_name: looker_zendesk.users
  fields:

  - dimension: id
    primary_key: true
    type: number
    sql: ${TABLE}.id

  - dimension: active
    type: yesno
    sql: ${TABLE}.active

  - dimension: alias
    type: string
    sql: ${TABLE}.alias

  - dimension_group: created
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.created_at

  - dimension: details
    type: string
    sql: ${TABLE}.details

  - dimension: email
    type: string
    sql: ${TABLE}.email

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

  - dimension: locale
    type: string
    sql: ${TABLE}.locale

  - dimension: locale_id
    type: number
    value_format_name: id
    sql: ${TABLE}.locale_id

  - dimension: moderator
    type: yesno
    sql: ${TABLE}.moderator

  - dimension: name
    type: string
    sql: ${TABLE}.name

  - dimension: notes
    type: string
    sql: ${TABLE}.notes

  - dimension: only_private_comments
    type: yesno
    sql: ${TABLE}.only_private_comments

  - dimension: organization_id
    type: number
    value_format_name: id
    sql: ${TABLE}.organization_id

  - dimension: remote_photo_url
    type: string
    sql: ${TABLE}.photo__url

  - dimension: role
    type: string
    sql: ${TABLE}.role

  - dimension: shared
    type: yesno
    sql: ${TABLE}.shared

  - dimension: suspended
    type: yesno
    sql: ${TABLE}.suspended

  - dimension: ticket_restriction
    type: string
    sql: ${TABLE}.ticket_restriction

  - dimension: time_zone
    type: string
    sql: ${TABLE}.time_zone

  - dimension_group: updated
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.updated_at

  - dimension: url
    type: string
    sql: ${TABLE}.url

  - dimension: verified
    type: yesno
    sql: ${TABLE}.verified

  - measure: count
    type: count
    drill_fields: [id, name]