view: spotify_market_share_week_ending {
  sql_table_name: intelligence.dbt_prod.spotify_weekly_market_share_by_country ;;
  label: "Spotify Weekly Market Share"

  dimension_group: report_date {
    description: "End Date of Reporting Week"
    type: time
    timeframes: [week]
    sql: ${TABLE}.report_date ;;
  }

  dimension: country {
    type: string
    sql: ${TABLE}.country ;;
  }

  dimension: region_group {
    type: string
    sql: ${TABLE}.region_group ;;
  }

  dimension: global_country_rank {
    type: number
    sql: ${TABLE}.global_country_rank ;;
  }

  dimension: regional_country_rank {
    type: number
    sql: ${TABLE}.regional_country_rank ;;
  }

  dimension: global_region_rank {
    type: number
    sql: ${TABLE}.global_region_rank ;;
  }

  measure: pct_of_global_store_streams {
    type: sum
    sql: ${TABLE}.pct_of_global_store_streams ;;
  }

  measure: pct_of_region_store_streams {
    type: sum
    sql: ${TABLE}.pct_of_region_store_streams ;;
  }

  measure: orchard_streams {
    type: sum
    sql: ${TABLE}.orchard_streams ;;
  }

  measure: store_streams {
    type: sum
    sql: ${TABLE}.store_streams ;;
  }

  measure: orchard_stream_share {
    type: sum
    sql: ${TABLE}.stream_share ;;
  }
}