Sensor Collectd Temperature

view: sensor_collectd_temperature {
  sql_table_name: logs.sensor_collectd_temperature_with_mfg_fw ;;

  dimension: unique_id {
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.unique_id ;;
  }

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

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

  dimension: measure_id {
    description: "Unique Id of a measure from stas/collectd Post. Correlates all different plugins from the same time period"
    sql: ${TABLE}.measure_id ;;
  }

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

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

  dimension: product_serial {
    label: "Unit Serial Number"
    sql: ${TABLE}.product_serial ;;
  }

  dimension: mfg_run {
    label: "Manufacturing Run"
    sql: ${TABLE}.mfg_run ;;
  }

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

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

  dimension_group: log_ts {
    label: "Time Log Generated"
    type: time
    timeframes: [time, date, week, month, hour, hour_of_day, day_of_week]
    sql: ${TABLE}.log_ts ;;
  }

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

  measure: count_device {
    type: count_distinct
    drill_fields: [network_id, nose_session_id]
    sql: ${device_id} ;;
  }

  measure: average_temperature {
    description: "In degrees Celcius"
    type: average
    drill_fields: [log_ts_time, sensor_instance, degrees_c, device_id, firmware_version]
    sql: ${degrees_c} ;;
  }

  measure: max_temperature {
    description: "In degrees Celcius"
    type: max
    drill_fields: [log_ts_time, sensor_instance, degrees_c, device_id, firmware_version]
    sql: ${degrees_c} ;;
  }

  measure: min_temperature {
    description: "In degrees Celcius"
    type: min
    drill_fields: [log_ts_time, sensor_instance, degrees_c, device_id, firmware_version]
    sql: ${degrees_c} ;;
  }
}

- view: sensor_collectd_temperature
  sql_table_name: logs.sensor_collectd_temperature_with_mfg_fw
  fields:
  - dimension: unique_id
    primary_key: true
    hidden: true
    sql: ${TABLE}.unique_id
  - dimension: degrees_c
    type: number
    sql: ${TABLE}.degrees_c
  - dimension: device_id
    sql: ${TABLE}.device_id
  - dimension: measure_id
    description: Unique Id of a measure from stas/collectd Post. Correlates all different plugins from the same time period
    sql: ${TABLE}.measure_id
  - dimension: network_id
    sql: ${TABLE}.network_id
  - dimension: node_session_id
    sql: ${TABLE}.node_session_id
  - dimension: product_serial
    label: Unit Serial Number
    sql: ${TABLE}.product_serial
  - dimension: mfg_run
    label: Manufacturing Run
    sql: ${TABLE}.mfg_run
  - dimension: firmware_version
    sql: ${TABLE}.firmware_version
  - dimension: sensor_instance
    sql: ${TABLE}.sensor_instance
  - dimension_group: log_ts
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    - hour_of_day
    - day_of_week
    sql: ${TABLE}.log_ts
  - dimension_group: first_test
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.first_test_time
  - measure: count_device
    type: count_distinct
    drill_fields:
    - network_id
    - nose_session_id
    sql: ${device_id}
  - measure: average_temperature
    type: average
    description: In degrees Celcius
    drill_fields:
    - log_ts_time
    - sensor_instance
    - degrees_c
    - device_id
    - firmware_version
    sql: ${degrees_c}
  - measure: max_temperature
    type: max
    description: In degrees Celcius
    drill_fields:
    - log_ts_time
    - sensor_instance
    - degrees_c
    - device_id
    - firmware_version
    sql: ${degrees_c}
  - measure: min_temperature
    type: min
    description: In degrees Celcius
    drill_fields:
    - log_ts_time
    - sensor_instance
    - degrees_c
    - device_id
    - firmware_version
    sql: ${degrees_c}