label: "KNR Models"
connection: "knr-looker"

include: "/views/chartmetric_airplay.view.lkml"
include: "/views/chartmetric_recordings.view.lkml"
include: "/views/global_countries.view.lkml"

# =========================================================================
# EXPLORE: CHARTMETRIC AIRPLAY ANALYTICS (CORE)
# =========================================================================
explore: chartmetric_airplay {
  hidden: no
  label: "Chartmetric Airplay Analytics"
  description: "The primary monitoring space for global radio airplay spins mapped against global catalog metadata."

  join: chartmetric_recordings {
    type: left_outer
    relationship: many_to_many
    sql_on: LOWER(${chartmetric_airplay.isrc}) = LOWER(${chartmetric_recordings.isrc}) ;;
  }

  join: global_countries {
    view_label: "Airplay Channel Country"
    type: left_outer
    relationship: many_to_one
    sql_on: UPPER(${chartmetric_airplay.channel_country_code}) = UPPER(${global_countries.country_code}) ;;
  }
}