view: int_dbt_prod_completion_rate_track_level_monthly {
  sql_table_name: INTELLIGENCE.DBT_PROD.COMPLETION_RATE_TRACK_LEVEL_MONTHLY ;;

  dimension_group: download_activity_month {
    view_label: "Date"
    label: "Activity"
    type: time
    sql: ${TABLE}.download_activity_date_month ;;
    timeframes: [year,
      quarter,
      month,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

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

  dimension: track_name {
    view_label: "Track"
    label: "Track Name"
    type: string
    sql: ${TABLE}.track_name ;;
  }

  dimension: isrc {
    view_label: "Track"
    label: "ISRC"
    type: string
    sql: ${TABLE}.isrc;;
  }

  dimension: store_name {
    view_label: "Store"
    label: "Store Name"
    type: string
    sql: ${TABLE}.store_name ;;
  }

  measure: completion_rate {
    view_label: "Completion Rate"
    label: "Completion Rate"
    type: sum
    sql: ${TABLE}.completion_rate;;
    value_format: "00.0%"
  }

  }