# View: dt_global_certifications_by_country

**View Name:** dt_global_certifications_by_country
**Table Source:** `Derived from: Prod.Dim_Isrc, Prod.Dim_Release`
**File Path:** `dt_global_certifications_by_country.view.lkml`

## Overview

- **File Size:** 21112 bytes
- **Lines of Code:** 556
- **Dimensions:** 3
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 2

## Comments & Notes

- allowed_value: { label: "Track" value: "isrcid" }
- dimension: data_source {
- type: string

## Dimensions

| Name | Type |
|------|------|
| `track_name` | string |
| `transaction_type` | string |
| `country_name` | string |

## Measures

| Name | Type |
|------|------|
| `certification_units` | sum |

## Filters

- `content_filter`
- `label_id`

## Derived Table

```sql
sql:
          WITH content_filter AS (
              SELECT
                  di.labelid,
                  di.isrcid,
                  di.isrc,
                  di.isrcname,
                  dr.releaseid,
                  dr.releasename,
                  dr.releasedate
              FROM facts.prod.dim_isrc di
                  INNER JOIN facts.prod.dim_release dr ON di.upc = dr.releaseid
              {% if certification_type._parameter_value == "'releaseid'" %
```