view: dt_label_manager_insights {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_LABEL_MANAGER_INSIGHTS ;;

  dimension: primary_key {
    primary_key: yes
    hidden:  yes
    type: string
    sql: CONCAT(${TABLE}.label_id,' ',${TABLE}.label_manager, ' ', ${TABLE}.label_manager_id) ;;
  }

  dimension: label_manager_id {
    type: number
    view_label: "Label"
    label: "Label Manager ID"
    sql: ${TABLE}.label_manager_id ;;
  }

  dimension: label_manager {
    type: string
    view_label: "Label"
    label: "Primary Relationship Manager"
    sql: ${TABLE}.label_manager ;;
  }

  dimension: label_id {
    type: number
    view_label: "Label"
    label: "Label ID"
    sql: ${TABLE}.label_id ;;
  }

  dimension: label_name {
    type: string
    view_label: "Label"
    label: "Label Name"
    sql: ${TABLE}.label_name ;;
  }

  dimension: is_active {
    type: yesno
    view_label: "Label"
    label: "Is Active"
    sql: ${TABLE}.is_active = 1 ;;
  }

  measure: count_is_active {
    type: sum
    view_label: "Label"
    label: "Number of Active Label "
    sql: ${TABLE}.is_active ;;
  }

  measure: sum_count_recent_digital {
    type: sum
    view_label: "Release"
    label: "Number of Recent Digital Releases"
    sql: ${TABLE}.count_recent_digital ;;
  }

  measure: sum_count_recent_physical {
    type: sum
    view_label: "Release"
    label: "Number of Recent Physcial Releases"
    sql: ${TABLE}.count_recent_physical ;;
  }

  measure: max_latest_release_date {
    type: date
    view_label: "Release"
    label: "Latest Released date"
    sql: MAX(${TABLE}.latest_release_date) ;;
  }

  measure: sum_count_recent_priority {
    type: sum
    view_label: "Release"
    label: "Number of Recent Priorities"
    sql: ${TABLE}.count_recent_priority ;;
  }

  measure: sum_count_alltime_tracks {
    type: sum
    view_label: "Track"
    label: "All Time Tracks"
    sql: ${TABLE}.count_alltime_tracks ;;
  }

  dimension: is_physical {
    type: yesno
    view_label: "Label"
    label: "Is Physical"
    sql: ${TABLE}.is_physical = 1 ;;
  }

  measure: count_is_physical {
    type: sum
    view_label: "Label"
    label: "Number of Physical Labels"
    sql: ${TABLE}.is_physical ;;
  }

  measure: sum_current_ytd {
    type: sum
    view_label: "Label"
    label: "Curr YTD Revenue"
    sql: ${TABLE}.current_ytd ;;
    value_format: "$#,##0.00"
  }

  measure: sum_previous_ytd {
    type: sum
    view_label: "Label"
    label: "Prev YTD Revenue"
    sql: ${TABLE}.previous_ytd ;;
    value_format: "$#,##0.00"
  }

  measure: sum_last_twelve_months {
    type: sum
    view_label: "Label"
    label: "Last 12 month Revenue"
    sql: ${TABLE}.last_twelve_months ;;
    value_format: "$#,##0.00"
  }

  measure: sum_previous_twelve_months {
    type: sum
    view_label: "Label"
    label: "Last 12 month Revenue(Last Year)"
    sql: ${TABLE}.previous_twelve_months ;;
    value_format: "$#,##0.00"
  }

  measure: sum_current_ytd_physical {
    type: sum
    view_label: "Label"
    label: "Curr YTD Physical Revenue"
    sql: ${TABLE}.current_ytd_physical ;;
    value_format: "$#,##0.00"
  }


  measure: sum_previous_ytd_physical {
    type: sum
    view_label: "Label"
    label: "Prev YTD Physical Revenue"
    sql: ${TABLE}.previous_ytd_physical ;;
    value_format: "$#,##0.00"
  }

  measure: sum_last_twelve_months_physical {
    type: sum
    view_label: "Label"
    label: "Last 12 Month Physical Revenue"
    sql: ${TABLE}.last_twelve_months_physical ;;
    value_format: "$#,##0.00"
  }

  measure: previous_twelve_months_physical {
    type: sum
    view_label: "Label"
    label: "Last 12 Month Physical Revenue(Last Year)"
    sql: ${TABLE}.previous_twelve_months_physical ;;
    value_format: "$#,##0.00"
  }


  dimension: label_identifier {
    type: string
    view_label: "Label"
    label: "Label Type"
    sql: ${TABLE}.label_identifier ;;
  }

  dimension: quarterback_label_manager {
    type: string
    hidden: yes
    sql: ${TABLE}.quarterback_label_manager ;;
  }

  measure: frontline_labels {
    type: count_distinct
    view_label: "Label"
    label: "Number of FrontLine Labels"
    sql: ${TABLE}.label_id ;;
    filters: {
      field: label_identifier
      value: "Frontline"
    }
    filters: {
      field: is_active
      value: "Yes"
    }
  }

  measure: catalog_d3_labels {
    type: count_distinct
    view_label: "Label"
    sql: ${TABLE}.label_id ;;
    label: "Number of Catalog/D3 Labels"
    filters: {
      field: label_identifier
      value: "Catalog,D3"
    }
    filters: {
      field: is_active
      value: "Yes"
    }
  }
}