view: int_dbt_prod_label_isrc_monthly_ctc {
  sql_table_name: intelligence.dbt_prod.label_isrc_monthly_ctc ;;

  dimension: run_date {
    description: "The date that the model was run."
    type: date
    sql: ${TABLE}.timestamp ;;
  }

  dimension: label_id {
    description: "The unique identifier for a label."
    type: string
    sql: ${TABLE}.label_id ;;
  }

  dimension: label_name {
    description: "The name of the label."
    type: string
    sql: ${TABLE}.label_name ;;
  }

  dimension: isrc {
    description: "The isrc associated with streaming."
    type: string
    sql: ${TABLE}.isrc ;;
  }

  dimension: months_of_data_available {
    description: "The number of months of data included in calculations."
    type: number
    sql: ${TABLE}.timestamp ;;
  }

  measure: streams_previous_six_months {
    description: "The total number of streams over the six month period prior to last month."
    type: sum
    sql: ${TABLE}.streams_prev_six_months ;;
  }

  measure: average_monthly_streams {
    description: "The average monthly streams over the six month period prior to last month."
    type: average
    sql: ${TABLE}.avg_streams ;;
  }

  measure: standard_deviation_streams {
    description: "The standard deviation in monthly streams over the six month period prior to last month."
    type: sum
    sql: ${TABLE}.std_streams ;;
  }

  measure: last_months_streams {
    description: "The total number of streams during last month."
    type: sum
    sql: ${TABLE}.last_months_streams ;;
  }

  measure: difference_vs_average {
    description: "The difference between last months streams and the average over the previous six months."
    type: sum
    sql: ${TABLE}.difference_vs_average ;;
  }

  measure: total_label_streams_difference_vs_average {
    description: "The difference between total label streams last months streams and the average over the previous six months."
    type: sum
    sql: ${TABLE}.difference_vs_average ;;
  }

  measure: isrc_contribution_to_change {
    description: "The ISRCs contribution to the change in streaming volume displayed as a percent."
    type: sum
    sql: ${TABLE}.isrc_contribution_to_change ;;
  }

  dimension: contribution_rank {
    description: "The ISRCs contribution to change rank in terms of absolute value."
    type: number
    sql: ${TABLE}.contribution_rank ;;
  }

  dimension: t_score {
    description: "The T-Score for last months streams as compared to the average streams over the last 6 months."
    type: number
    sql: ${TABLE}.t_score ;;
  }

}