# View: int_dbt_prod_monthly_territory_kpis

**View Name:** int_dbt_prod_monthly_territory_kpis
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `views/territory_kpis/int_dbt_prod_monthly_territory_kpis.view.lkml`

## Overview

- **File Size:** 2543 bytes
- **Lines of Code:** 105
- **Dimensions:** 1
- **Measures:** 12
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `country` | string |

## Measures

| Name | Type |
|------|------|
| `country_market_share_local_streams` | average |
| `country_market_share_global_streams` | average |
| `country_market_share_local_revenue` | average |
| `country_market_share_global_revenue` | average |
| `local_label_margin` | average |
| `orchard_top_store_streams` | sum |
| `orchard_top_stores_local_label_streams` | sum |
| `orchard_top_stores_global_label_streams` | sum |
| `total_market_top_store_streams` | sum |
| `local_label_revenue_outside_home_country` | sum |
| `world_wide_revenue_from_local_labels` | sum |
| `world_wide_distribution_fee_local_label` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_month` | time |

## Derived Table

```sql
sql:

    select
      *
    from {% if country_group_type._parameter_value == "'label'" %
```