# View: int_dbt_prod_summary_territory_kpis

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

## Overview

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

## Comments & Notes

- allowed_value: { label: "Label Country" value: "label"}

## Dimensions

| Name | Type |
|------|------|
| `country` | string |
| `KPI` | string |
| `target_driver_exlc` | number |
| `target_driver_only` | string |
| `CY24_Target` | number |
| `CY24_Actual` | number |

## Measures

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

## Derived Table

```sql
sql:

    with cy24_targets as (
      select
        ifpi_country_group,
        market_type,
        kpi,
        to_number(cy_24_target, 38, 10) as cy_24_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.*,
      cy24_targets.cy_24_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.ifpi_summary_territory_kpis kpis
      left join cy24_targets cy24_targets on cy24_targets.ifpi_country_group = kpis.transaction_country and cy24_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

    ;;
```