view: int_prod_vw_release_delivery_history {
#  sql_table_name: intelligence.prod.release_delivery_history ;;
  sql_table_name: INTELLIGENCE.PROD.RELEASE_DELIVERY_HISTORY  ;;

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

  dimension: delivery_history {
    description: "Stores a particular release has been delivered to"
    type: string
    sql: ${TABLE}.stores_delivered ;;
    html:
    {% assign stores = value | split: ";" %}
    {% unless stores.size == 0 %}

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

    <ul>
    {% for store in stores %}
    <li>{{store}}</li>
    {% endfor %}
    </ul>
    </details>

    {% endunless %};;
  }



}