Phones

view: phones {
  sql_table_name: public.phones ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: is_latest_dump {
    type: yesno
    sql: (SELECT MAX(dump_ts) FROM phones) = ${dump_ts_raw} ;;
  }

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

  measure: count {
    type: count
    drill_fields: [id, uname]
  }

  measure: column_percent {
    type: percent_of_total
    sql: ${count} ;;
  }
}

- view: phones
  sql_table_name: public.phones
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: akey
    sql: ${TABLE}.akey
  - dimension: app_version
    sql: ${TABLE}.app_version
  - dimension: full_disk_encryption
    sql: ${TABLE}.full_disk_encryption
  - dimension: jailbroken
    sql: ${TABLE}.jailbroken
  - dimension: manufacturer
    sql: ${TABLE}.manufacturer
  - dimension: model
    sql: ${TABLE}.model
  - dimension: os_version
    sql: ${TABLE}.os_version
  - dimension: passcode_status
    sql: ${TABLE}.passcode_status
  - dimension: pkey
    sql: ${TABLE}.pkey
  - dimension: platform
    sql: ${TABLE}.platform
  - dimension: security_patch_level
    sql: ${TABLE}.security_patch_level
  - dimension: touchid_status
    sql: ${TABLE}.touchid_status
  - dimension: type
    sql: ${TABLE}.type
  - dimension: uname
    sql: ${TABLE}.uname
  - dimension: is_latest_dump
    type: yesno
    sql: (SELECT MAX(dump_ts) FROM phones) = ${dump_ts_raw}
  - dimension_group: dump_ts
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - raw
    sql: ${TABLE}.dump_ts
  - measure: count
    type: count
    drill_fields:
    - id
    - uname
  - measure: column_percent
    type: percent_of_total
    sql: ${count}