Application Download Request

view: application_download_request {
  label: "Download Requests"
  sql_table_name: downloads.applicationdownloadrequest ;;

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

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

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

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

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

  dimension: user_device {
    sql: ARRAY[${user}, ${device}] ;;
  }

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

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

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

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

  measure: count {
    type: count
  }

  measure: unique_user_device_downloads {
    label: "User-Device Downloads"
    type: count_distinct
    sql: ${user_device} ;;
  }
}

- view: application_download_request
  label: Download Requests
  sql_table_name: downloads.applicationdownloadrequest
  fields:
  - dimension: psk
    type: int
    primary_key: true
    sql: ${TABLE}.psk
  - dimension: complete
    type: yesno
    sql: ${TABLE}.complete
  - dimension: device
    type: int
    sql: ${TABLE}.device
  - dimension: user
    type: int
    sql: ${TABLE}.user
  - dimension: version
    type: int
    sql: ${TABLE}.version
  - dimension: user_device
    sql: ARRAY[${user}, ${device}]
  - dimension: isota
    type: yesno
    sql: ${TABLE}.isota
  - dimension: request_type
    type: int
    sql: ${TABLE}.request_type
  - dimension_group: completed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created
  - measure: count
    type: count
  - measure: unique_user_device_downloads
    type: count_distinct
    label: User-Device Downloads
    sql: ${user_device}