view: US_ARTIST_RANKING{
  #sql_table_name:INTELLIGENCE.DBT_PROD.US_ARTIST_RANKING;;

  derived_table: {
    sql: SELECT * FROM INTELLIGENCE.DBT_PROD.US_ARTIST_RANKING WHERE Country_name = 'USA';;
  }


  dimension: Artist_id{
    label:"Artist Id"
    type: number
    sql:${TABLE}.Artist_id;;
  }
  dimension: Country_name{
    label:"Country Name"
    type: string
    sql:${TABLE}.Country_name;;
  }
  dimension: Streams{
    label:"Streams"
    type: string
    sql:${TABLE}.Streams;;
  }
  dimension: Total_streams{
    label:"Total Streams"
    type: string
    sql:${TABLE}.Total_streams;;
  }
  dimension: Percentage{
    label:"Percentage of Total Streams"
    type: string
    sql:${TABLE}.Percentage;;
  }
  dimension: Country_rank{
    label:"Country Rank"
    type: string
    sql:${TABLE}.Country_rank;;

}

dimension: primary {
  label: "Primary"
  hidden: yes
  primary_key: yes
  sql:${TABLE}.Artist_id,${TABLE}.Country_name;;
}
}