view: int_dbt_prod_artist_marketshare {
  sql_table_name: INTELLIGENCE.DBT_PROD.ARTIST_MARKETSHARE ;;


### Dimensions

  dimension: artistid {
    label: "Artist ID"
    view_label: "Artist"
    type: number
    sql: ${TABLE}.artistid ;;
  }

  dimension: artistname {
    label: "Artist Name"
    view_label: "Artist"
    type: string
    sql: ${TABLE}.artistname ;;
  }

  dimension: stream_country {
    label: "Stream Country"
    type: string
    sql: ${TABLE}.stream_country ;;
  }

  dimension: accounting_date {
    label: "Accounting Date"
    type: date
    sql: ${TABLE}.accounting_date ;;
  }

  dimension: store {
    label: "Store"
    type: string
    sql: INITCAP(${TABLE}.store) ;;
  }

### Measures

  measure: artist_stream {
    label: "Artist Streams"
    view_label: "Market Share"
    type: sum
    sql: ${TABLE}.artist_stream ;;
    value_format: "#,###"
  }

  measure: market_total_streams {
    label: "Market Total Streams"
    view_label: "Market Share"
    type: sum
    sql: ${TABLE}.MARKET_TOTAL_STREAMS ;;
    value_format: "#,###"
  }

  # # measure: market_share_percentage {
  # #   label: "Market Share %"
  # #   view_label: "Market Share"
  # #   type: average
  # #   value_format: "0.0000%"
  # #   sql: (${TABLE}.MARKET_SHARE_PERCENTAGE / 100)
  # }

  # measure: market_share_score {
  #   label: "Market Share Score"
  #   view_label: "Market Share"
  #   type: number
  #   sql: ${TABLE}.MARKET_SHARE_SCORE ;;
  #   value_format: "#,##0.00"
  # }
}