view: dt_playlist_stream_threshold {
  derived_table: {
    sql:
SELECT isrc, playlist_url
FROM facts.prod.summary_sos
WHERE labelid != 32551
GROUP BY 1,2
HAVING {% condition stream_threshold %}SUM(overall_number_of_streams){% endcondition %} ;;
  }

  filter: stream_threshold {
    view_label: "Playlist"
    description: "Enter a minimum number of Overall Streams that a track must have on a playlist to be included in the query output."
    type: number
  }

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

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