view: yt_single_input_field {
  derived_table: {
    sql: select * from facts.dev.MISSING_YOUTUBE_ISRCS_20171117
      ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  dimension: isrc {
    type: string
    sql: ${TABLE}.ISRC ;;
  }

  dimension: on_list {
    type: string
    sql: CASE
        WHEN yt_single_input_field.ISRC IS NOT NULL
        THEN 'Y'
        ELSE 'N'
        END ;;
  }

  set: detail {
    fields: [isrc]
  }
}