view: owned_and_operated_artist_royalty_rates {
  sql_table_name: intelligence.dev.owned_and_operated_artist_royalty_rates ;;

#   measure: count {
#     hidden: yes
#     view_label: "Xtra Advanced Fields"
#     type: count
#     drill_fields: [detail*]
#   }

  dimension: isrc {
    hidden: yes
    view_label: "Xtra Advanced Fields"
    label: "Artist Royalty Percentage ISRC"
    type: string
    sql: ${TABLE}.ISRC ;;
  }

  dimension: upc {
    hidden: yes
    view_label: "Xtra Advanced Fields"
    type: number
    sql: ${TABLE}.UPC ;;
  }

  dimension: artist_royalty_percentage {
    view_label: "Xtra Advanced Fields"
    label: "O&O Artist Royalty Percentage"
    type: number
    #value_format_name: decimal_4
    sql: ${TABLE}.ARTIST_ROYALTY_PERCENTAGE ;;
  }

dimension: streaming_rate {
  view_label: "Xtra Advanced Fields"
  label: "O&O Streaming Rate"
  type: number
  sql: ${TABLE}.STREAMING_RATE ;;
}

dimension: isrc_available {
  view_label: "Xtra Advanced Fields"
  label: "Track Has O&O Artist Royalty Percentage? (Yes/No)"
  type: string
  sql: case when ${TABLE}.isrc is null THEN 'No'
         Else 'Yes'
        END;;
}

}