view: orch_app_ar_country {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.country ;;

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

  dimension: country_code {
    label: "
    {% if _view._name == 'address_country' %} Address Country
    {% else %} Country Code {% endif %}"
    type: string
    sql: ${TABLE}.country_code ;;
  }

  dimension: name {
    label: "
    {% if _view._name == 'label_country' %} Label Country
    {% elsif _view._name == 'artist_country' %} Artist Country
    {% elsif _view._name == 'base_artist_country' %} Artist Country
    {% elsif _view._name == 'similar_artist_country' %} Artist Country
    {% elsif _view._name == 'tax_id_country' %} Tax ID Country
    {% elsif _view._name == 'recording_country' %} Country of Recording
    {% elsif _view._name == 'track_producer_nationality' %} Track Producer Nationality
    {% elsif _view._name == 'product_territory_split_country' %} Product Territory Split Country
    {% elsif _view._name == 'tiktok_country' %} TikTok Country
    {% else %} Country Name {% endif %}"
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: us_vs_row {
    label: "Group By: USA vs. Rest of World"
    case: {
      when: { sql: ${TABLE}.id = 1 ;; label: "USA" }
      else: "Rest of World"
    }
  }

  dimension: us_vs_uk_vs_row {
    label: "Group By: USA vs. UK vs. Rest of World"
    case: {
      when: { sql: ${TABLE}.id = 1 ;; label: "USA" }
      when: { sql: ${TABLE}.id =3  ;; label: "UK" }
      else: "Rest of World"
    }
  }

#   dimension: abbrivation {
#     type: string
#     sql: ${TABLE}.abbrivation ;;
#   }
#
  dimension: continent {
    label: "
    {% if _view._name == 'label_continent' %} Label Continent
    {% elsif _view._name == 'artist_continent' %} Artist Continent
    {% elsif _view._name == 'base_artist_continent' %} Artist Continent
    {% elsif _view._name == 'similar_artist_continent' %} Artist Continent
    {% elsif _view._name == 'tax_id_continent' %} Tax ID Continent
    {% elsif _view._name == 'recording_continent' %} Continent of Recording
    {% else %} Continent Name {% endif %}"
    hidden:  no
    type: string
    sql: ${TABLE}.continent ;;
  }
#
#   dimension: continent_id {
#     type: number
#     sql: ${TABLE}.continent_id ;;
#   }
#
#   dimension: iso3166a3 {
#     type: string
#     sql: ${TABLE}.iso3166a3 ;;
#   }
#
#   dimension: latitude {
#     type: number
#     sql: ${TABLE}.latitude ;;
#   }
#
#   dimension: longitude {
#     type: number
#     sql: ${TABLE}.longitude ;;
#   }

  measure: country_list {
    type: string
    sql: LISTAGG(DISTINCT ${TABLE}.country_code, ', ') WITHIN GROUP (ORDER BY ${TABLE}.country_code) ;;
  }
}