# View: int_dbt_prod_summary_territory_kpis

**View Name:** int_dbt_prod_summary_territory_kpis
**Table Source:** `Derived from: Cy25_Targets, Dbt_Prod_Strategy.Ifpi_Summary_Territory_Kpis, Dev_Zallard.Territory_Kpi_Targets, Intelligence.Dbt_Prod_Strategy, Intelligence.Dev_Zallard + 2 more`
**File Path:** `views/territory_kpis/int_dbt_prod_summary_territory_kpis.view.lkml`

## Overview

- **File Size:** 29945 bytes
- **Lines of Code:** 413
- **Dimensions:** 5
- **Measures:** 5
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- allowed_value: { label: "Label Country" value: "label"}
- dimension: CY24_Actual {
- description: "H1 '24 Actual Data. Market share data for this field is sourced from IFPI."

## Dimensions

| Name | Type |
|------|------|
| `country` | string |
| `KPI` | string |
| `target_driver_exlc` | number |
| `target_driver_only` | string |
| `CY25_Target` | number |

## Measures

| Name | Type |
|------|------|
| `last_month` | sum |
| `previous_month` | sum |
| `same_month_last_year` | sum |
| `this_year_ytd` | sum |
| `last_year_ytd` | sum |

## SQL Comments

- to_number(cy_24_actual, 38, 10) as cy_24_actual
- cy24_targets.cy_24_actual,

## Derived Table

```sql
sql:

    with cy25_targets as (
      select
        ifpi_country_group,
        market_type,
        kpi,
        to_number(cy_25_target, 38, 10) as cy_25_target,
        --to_number(cy_24_actual, 38, 10) as cy_24_actual
      from intelligence.dev_zallard.territory_kpi_targets
    ),

      target_driver_excl_ex_country_revenue as (
      select
      ifpi_country_group,
      market_type,
      kpi,
      to_number(target_driver, 38, 10) as target_driver
      from intelligence.dev_zallard.territory_kpi_targets
      where kpi != 'LOCAL_LABEL_REVENUE_OUTSIDE_HOME_COUNTRY'
      ),

      target_driver_ex_country_revenue_only as (
      select
      ifpi_country_group,
      market_type,
      kpi,
      target_driver
      from intelligence.dev_zallard.territory_kpi_targets
      where kpi = 'LOCAL_LABEL_REVENUE_OUTSIDE_HOME_COUNTRY'

      )

      select
      kpis.*,
      cy25_targets.cy_25_target,
      --cy24_targets.cy_24_actual,
      target_driver_exlc.target_driver as target_driver_exlc,
      target_driver_only.target_driver as target_driver_only
      from intelligence.dbt_prod_strategy.ifpi_summary_territory_kpis kpis
      left join cy25_targets cy25_targets on cy25_targets.ifpi_country_group = kpis.transaction_country and cy25_targets.kpi = kpis.kpis
      left join target_driver_excl_ex_country_revenue target_driver_exlc on target_driver_exlc.ifpi_country_group = kpis.transaction_country and target_driver_exlc.kpi = kpis.kpis
      left join target_driver_ex_country_revenue_only target_driver_only on target_driver_only.ifpi_country_group = kpis.transaction_country and target_driver_only.kpi = kpis.kpis

      ;;
```