Check For Missed Serials

view: check_for_missed_serials {
  sql_table_name: mfg.shipped_serials_missing ;;

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

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

  dimension: check_job_results {
  }

  dimension: source_file_name {
    sql: ${TABLE}.file_name ;;
  }

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

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

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

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

  dimension: serial_number {
    label: "Full Serial Number from MFG Test"
    description: "If this field is complete but the device appears on this list then there is a missing secret"
    sql: ${TABLE}.serial_number ;;
  }

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

  measure: count {
    type: count
    drill_fields: [check_dt, pcba_sn, fg_sn, comments, packingtime, serial_number]
  }
}

- view: check_for_missed_serials
  sql_table_name: mfg.shipped_serials_missing
  fields:
  - dimension: cartonid
    sql: ${TABLE}.cartonid
  - dimension: comments
    sql: ${TABLE}.comments
  - dimension: check_job_results
  - dimension: source_file_name
    sql: ${TABLE}.file_name
  - dimension: config
    sql: ${TABLE}.config
  - dimension: fg_sn
    sql: ${TABLE}.fg_sn
  - dimension: packingtime
    sql: ${TABLE}.packingtime
  - dimension: pcba_sn
    sql: ${TABLE}.pcba_sn
  - dimension: serial_number
    label: Full Serial Number from MFG Test
    description: If this field is complete but the device appears on this list then there is a missing secret
    sql: ${TABLE}.serial_number
  - dimension_group: check_dt
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.check_dt
  - measure: count
    type: count
    drill_fields:
    - check_dt
    - pcba_sn
    - fg_sn
    - comments
    - packingtime
    - serial_number