view: int_prod_daily_spikes_uk {
  sql_table_name: intelligence.dbt_prod.daily_spikes_uk ;;

  dimension: labelid {
    view_label: "Metrics"
    type: number
    hidden: yes
    sql: ${TABLE}.labelid;;
  }

  dimension: subaccountid {
    view_label: "Metrics"
    type: number
    hidden: yes
    sql: ${TABLE}.subaccountid;;
  }

  dimension: artistid {
    view_label: "Metrics"
    type: number
    hidden: yes
    sql: ${TABLE}.artistid;;
  }

  dimension: releaseid {
    view_label: "Metrics"
    type: number
    hidden: yes
    sql: ${TABLE}.upc;;
  }

  dimension: isrc {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.isrc;;
  }

  dimension: track_name {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.track_name;;
  }

  dimension: storeid {
    view_label: "Store"
    type: number
    hidden: no
    sql: ${TABLE}.storeid;;
  }

  dimension: today_streams {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.today_streams;;
  }

  dimension: average_streams {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.average_streams;;
    value_format: "#,##0"
  }

  dimension: percent_above_average {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_average;;
    value_format: "0.00\%"
  }

  dimension: spike_score {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score;;
    value_format: "0.##"
  }

  dimension: days_since_release {
    view_label: "Metrics"
    type: number
    sql: DATEDIFF(day, ${orch_app_ar_releases.release_date}, CURRENT_DATE()-2) ;;
  }

}