view: dt_fact_sales_market_share_artist_level {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_FACT_SALES_MARKET_SHARE_ARTIST_LEVEL ;;

  dimension_group: activity_month {
    view_label: "Date"
    label: "Activity"
    description: "Resolves for 'Activity Month 544' as provided by iTunes/Apple"
    type: time
    timeframes: [month, month_name, month_num, quarter, year]
    sql: ${TABLE}.activity_month ;;
  }

  dimension: country_code {
    type: string
    sql: ${TABLE}.country_code ;;
    hidden: yes
  }

  dimension: storeid {
    type: number
    sql: ${TABLE}.storeid ;;
    hidden: yes
  }

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

  dimension: artist_name {
    view_label: "Artist"
    type: string
    sql: ${TABLE}.artistname ;;
    hidden: no
  }

  dimension: is_adsup {
    view_label: "Transaction Type"
    label: "Is Ad-Supported"
    type: yesno
    sql: ${TABLE}.is_adsup ;;
  }

  measure: net_receipt {
    view_label: "Accounting"
    label: "Client Net Receipt (USD)"
    type: sum
    sql: ${TABLE}.net_receipt ;;
  }

  measure: gross {
    view_label: "Accounting"
    label: "Gross Revenue (USD)"
    type: sum
    sql: ${TABLE}.gross ;;
  }

  measure: units {
    view_label: "Accounting"
    label: "Streams"
    type: sum
    sql: ${TABLE}.units ;;
  }

  measure: orchard_streams {
    view_label: "Market Share"
    label: "Streams (Orchard)"
    type: sum
    sql: ${TABLE}.orchard_streams ;;
    value_format: "[>=1000000]#,##0.0,,\" M\"; #,###"
  }

  measure: store_streams {
    view_label: "Market Share"
    label: "Streams (Storewide)"
    type: sum
    sql: ${TABLE}.store_streams ;;
    value_format: "[>=1000000]#,##0.0,,\" M\"; [>=10 OR =0]#,##0; [>=.0000001]#,##0.0000"
  }

  measure: users {
    view_label: "Market Share"
    label: "Number of Accounts (Storewide)"
    description: "Previously referred to as 'Users'"
    type: sum
    sql: TRUNC(${TABLE}.users, 0) ;;
    value_format: "#,###"
  }

  measure: orchard_gross_revenue_usd {
    view_label: "Market Share"
    label: "Revenue USD (Orchard)"
    type: sum
    sql: ${TABLE}.orchard_gross_revenue_usd ;;
    value_format: "[>=1000000]$ #,##0.0,,\" M\"; [>=10 OR =0]$ #,##0; [>=.0000001]$ #,##0.0000;"

  }

  measure: store_revenue_usd {
    view_label: "Market Share"
    label: "Revenue USD (Storewide)"
    type: sum
    sql: ${TABLE}.store_revenue_usd ;;
    value_format: "[>=1000000]$ #,##0.0,,\" M\"; [>=10 OR =0]$ #,##0; [>=.0000001]$ #,##0.0000;"
  }
}