view: discos_musart_spotify_sos_aggregated {
  sql_table_name: prod.discos_musart.spotify_sos_aggregated ;;

  dimension: adsupported_or_premium {
    type: string
    sql: ${TABLE}.ADSUPPORTED_OR_PREMIUM ;;
  }

  dimension: aggregate {
    type: string
    hidden: yes
    sql: ${TABLE}.AGGREGATE ;;
    suggestions: [
      "Weekly Track Level",
      "Weekly Release Level",
      "Weekly Label Level",
      "Weekly Orchard Level",
      "Weekly Worldwide",
      "Weekly Worldwide Release Level",
      "Weekly Worldwide Label Level",
      "Weekly Worldwide Orchard Level",
      "Weekly Track Level Exclude User Detail",
      "Weekly Release Level Exclude User Detail",
      "Weekly Label Level Exclude User Detail",
      "Weekly Orchard Level Exclude User Detail",
      "Weekly Worldwide Exclude User Detail",
      "Weekly Worldwide Release Level Exclude User Detail",
      "Weekly Worldwide Label Level Exclude User Detail",
      "Weekly Worldwide Orchard Level Exclude User Detail",
      "Weekly Track Level Exclude Playlist Detail",
      "Weekly Release Level Exclude Playlist Detail",
      "Weekly Label Level Exclude Playlist Detail",
      "Weekly Orchard Level Exclude Playlist Detail",
      "Weekly Worldwide Exclude Playlist Detail",
      "Weekly Worldwide Release Level Exclude Playlist Detail",
      "Weekly Worldwide Label Level Exclude Playlist Detail",
      "Weekly Worldwide Orchard Level Exclude Playlist Detail",
      "Weekly Track Level Exclude User Detail Exclude Playlist Detail",
      "Weekly Release Level Exclude User Detail Exclude Playlist Detail",
      "Weekly Label Level Exclude User Detail Exclude Playlist Detail",
      "Weekly Orchard Level Exclude User Detail Exclude Playlist Detail",
      "Weekly Worldwide Exclude User Detail Exclude Playlist Detail",
      "Weekly Worldwide Release Level Exclude User Detail Exclude Playlist Detail",
      "Weekly Worldwide Label Level Exclude User Detail Exclude Playlist Detail",
      "Weekly Worldwide Orchard Level Exclude User Detail Exclude Playlist Detail"
    ]
  }

  dimension: album_code {
    type: string
    sql: ${TABLE}.ALBUM_CODE ;;
  }

  dimension: album_name {
    type: string
    sql: ${TABLE}.ALBUM_NAME ;;
  }

  dimension: cached {
    type: string
    sql: ${TABLE}.CACHED ;;
  }

  dimension: count_tid {
    type: string
    sql: ${TABLE}.COUNT_TID ;;
  }

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

  dimension: country_subregion {
    type: string
    sql: ${TABLE}.COUNTRY_SUBREGION ;;
  }

  dimension_group: date_paulo_downloaded_file {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.DATE_PAULO_DOWNLOADED_FILE ;;
  }

  dimension: device_type {
    type: string
    sql: ${TABLE}.DEVICE_TYPE ;;
  }

  dimension_group: friday_weekof {
    view_label: "Required Fields"
    label: "Activity Week"
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.stream_activity_date ;;
  }

  dimension: isrc {
    view_label: "Required Fields"
    label: "ISRC"
    type: string
    sql: ${TABLE}.ISRC ;;
  }

  #   - dimension: label_is_red
  #     type: string
  #     sql: ${TABLE}.LABEL_IS_RED
  #
  dimension: labelid {
    view_label: "Required Fields"
    hidden: yes
    label: "Label ID"
    type: number
    sql: ${TABLE}.LABELID ;;
  }

  dimension: length_seconds {
    type: string
    sql: ${TABLE}.LENGTH_SECONDS ;;
  }

  dimension_group: monday_weekof {
    hidden: yes
    view_label: "Required Fields"
    label: "monday_weekof"
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.MONDAY_WEEKOF ;;
  }

  dimension: os {
    type: string
    sql: ${TABLE}.OS ;;
  }

  dimension: os_group {
    type: string
    sql: ${TABLE}.OS_GROUP ;;
  }

  dimension: playlist_id {
    type: string
    sql: ${TABLE}.PLAYLIST_ID ;;
  }

  dimension: playlist_is_unknown {
    type: string
    sql: ${TABLE}.PLAYLIST_IS_UNKNOWN ;;
  }

  dimension: playlist_owner_group {
    type: string
    sql: ${TABLE}.PLAYLIST_OWNER_GROUP ;;
  }

  dimension: playlist_owner_id_from_source_uri {
    type: string
    sql: ${TABLE}.PLAYLIST_OWNER_ID_FROM_SOURCE_URI ;;
  }

  dimension: playlist_uri {
    type: string
    sql: ${TABLE}.PLAYLIST_URI ;;
  }

  dimension: product_partner {
    type: string
    sql: ${TABLE}.PRODUCT_PARTNER ;;
  }

  dimension: product_type {
    type: string
    sql: ${TABLE}.PRODUCT_TYPE ;;
  }

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

  dimension: source {
    type: string
    sql: ${TABLE}.SOURCE ;;
  }

  dimension: source_group {
    type: string
    sql: ${TABLE}.SOURCE_GROUP ;;
  }

  dimension: source_original_values {
    type: string
    sql: ${TABLE}.SOURCE_ORIGINAL_VALUES ;;
  }

  measure: streams {
    type: sum
    sql: ${TABLE}.STREAMS ;;
  }

  dimension: track_album_artist {
    type: string
    sql: ${TABLE}.TRACK_ALBUM_ARTIST ;;
  }

  dimension: track_artists {
    type: string
    sql: ${TABLE}.TRACK_ARTISTS ;;
  }

  dimension: track_name {
    type: string
    sql: ${TABLE}.TRACK_NAME ;;
  }

  dimension: track_uri {
    type: string
    sql: ${TABLE}.TRACK_URI ;;
  }

  dimension: user_access {
    type: string
    sql: ${TABLE}.USER_ACCESS ;;
  }

  dimension: user_type {
    type: string
    sql: ${TABLE}.USER_TYPE ;;
  }

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

  dimension: zipcode {
    type: string
    sql: ${TABLE}.ZIPCODE ;;
  }

  measure: count {
    type: count
    drill_fields: [track_name, album_name]
  }

  measure: count_distinct_weeks {
    view_label: ""
    label: "Number of Weeks"
    description: "Unique number of weeks (by group; within your filters)"
    hidden: yes
    suggestable: no
    sql: ${friday_weekof_week} ;;
    type: count_distinct
    value_format: "#,###"
  }

  measure: streams_per_week {
    view_label: ""
    label: "Avg Streams per Week"
    description: "Number of Streams per Day;   ie  (Number Of Streams) / NULLIF(Number of Days, 0)"
    sql: ${streams} / ${count_distinct_weeks} ;;
    type: number
    value_format: "[>=1000000]#,##0.0,,\" M\"; #,##0"
  }
}