view: fact_prod_dim_store_timed_release {
  sql_table_name: facts.prod.dim_store ;;

  dimension: store_id {
    type: number
    sql: ${TABLE}.storeid ;;
    primary_key: yes
  }


  dimension: store_name {
    type: string
    bypass_suggest_restrictions: yes
    sql:  ${TABLE}.storename  ;;

    link: {
      label: "{{ value }} Deep Dive"
      url: "

      {% if _explore._name != 'facts_prod_fact_analytics_v2' %}

      {% elsif orch_app_ar_track.isrc._in_query and facts_prod_dim_playlist.playlistname._in_query and facts_prod_dim_playlist.playlistauthor._in_query%}

      https://theorchard.looker.com/dashboards-next/1761?ISRC={{ orch_app_ar_track.isrc._value}}&Artist%20Name={{ orch_app_ar_artist_info.name._value }}&Label%20ID={{facts_prod_fact_analytics_v2.labelid._value }}&Store%20Name={{ value }}

      {% else %}

      {% endif %}
      "
    }
  }
  # orch_app_ar_track.isrc._in_query
  #.  _filters['orch_app_ar_track.isrc']<>'') %}
  #.  {% elsif (_explore._name == 'facts_prod_fact_analytics_v2' AND _field.name == 'orch_app_ar_track.isrc') %}

}

# Missing Fields: raw_table (?)