view: int_dbt_prod_label_country_report {
  derived_table: {
    sql:
      SELECT
        *
      FROM intelligence.dbt_prod_strategy.ifpi_label_country_report

      ;;
  }


  parameter: country_group_type {
    type: string
    allowed_value: { label: "IFPI Country Groups" value: "ifpi"}
  }

  dimension: lastest_month_of_current_year {
    description: "A number corresponding to the latest month of the latest year that data is avilable for."
    type: number
    sql: ${TABLE}.lastest_month_of_current_year ;;
  }

  dimension: latest_year {
    description: "The latest year of that data is available for."
    type: number
    sql: ${TABLE}.lastest_month_of_current_year ;;
  }

  dimension_group: activity_month{
    description: "The month that streaming activity occurred."
    type: time
    sql: ${TABLE}.activity_month ;;
  }

  dimension: label_country {
    description: ""
    type: string
    sql: ${TABLE}.label_country ;;
  }

  dimension: label_id{
    description: ""
    type: number
    sql: ${TABLE}.label_id ;;
  }

  dimension: label_name {
    description: ""
    type: string
    sql: ${TABLE}.label_name ;;
  }

  dimension: activity_period {
    description: "Either 'This Year YTD' or 'Last Year YTD'."
    type: string
    sql: ${TABLE}.activity_period ;;
  }

  measure: local_gross_revenue_usd {
    description: "Includes revenue from Spotify, iTunes/Apple, YouTube Subscription, Amazon Unlimited and Deezer"
    type: sum
    value_format_name: usd
    sql: ${TABLE}.local_gross_revenue_usd ;;
  }

  measure: global_gross_revenue_usd {
    description: "Includes revenue from Spotify, iTunes/Apple, YouTube Subscription, Amazon Unlimited and Deezer"
    type: sum
    value_format_name: usd
    sql: ${TABLE}.global_gross_revenue_usd ;;
  }

  measure: total_gross_revenue_usd {
    description: "Includes revenue from Spotify, iTunes/Apple, YouTube Subscription, Amazon Unlimited and Deezer"
    type: sum
    value_format_name: usd
    sql: ${TABLE}.total_gross_revenue ;;
  }

  measure: total_net_revenue_usd {
    description: "Includes revenue from Spotify, iTunes/Apple, YouTube Subscription, Amazon Unlimited and Deezer"
    type: sum
    value_format_name: usd
    sql: ${TABLE}.total_net_revenue ;;
  }

  measure: local_gross_revenue_usd_all_stores {
    description: ""
    type: sum
    value_format_name: usd
    sql: ${TABLE}.local_gross_revenue_usd_all_stores ;;
  }


  measure: global_gross_revenue_usd_all_stores {
    description: ""
    type: sum
    value_format_name: usd
    sql: ${TABLE}.global_gross_revenue_usd_all_stores ;;
  }

  measure: total_gross_revenue_usd_all_stores {
    description: ""
    type: sum
    value_format_name: usd
    sql: ${TABLE}.total_gross_revenue_all_stores ;;
  }

  measure: total_net_revenue_usd_all_stores {
    description: ""
    type: sum
    value_format_name: usd
    sql: ${TABLE}.total_net_revenue_all_stores ;;
  }

}