view: dt_registry {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_REGISTRY ;;
#   derived_table: {
#     sql: with territories as (select isrc, tuid, internal_conflict,
# listagg(distinct(territory), ', ')
# within group (order by territory)
# over (partition by tuid) as territories
# from FACTS.PROD.REGISTRY)

# select distinct(tuid),isrc, territories
# from territories ;;
#   }

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

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

  dimension: territories {
    label: "Registry Territories"
    type: string
    sql:  ${TABLE}.territories;;
    html:
    {% assign territories = value | split: ";" %}
    {% unless territories.size == 0 %}

    <details>
    <summary>Detail ({{territories.size}})</summary>

    <ul>
    {% for territory in territories %}
    <li>{{territory}}</li>
    {% endfor %}
    </ul>
    </details>

    {% endunless %}
    ;;
 }
}