# View: dt_promusicae_certification_single

**View Name:** dt_promusicae_certification_single
**Table Source:** `Derived from: Prod.Dim_Track, Prod.Fact_Analytics`
**File Path:** `dt_promusicae_certification_single.view.lkml`

## Overview

- **File Size:** 6323 bytes
- **Lines of Code:** 221
- **Dimensions:** 9
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- dimension: TDE {
- label: "Track Download Equivilant"
- type: number

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |
| `labelid` | string |
| `artistid` | string |
| `SEA` | number |
| `SD` | number |
| `ad_supported_units` | number |
| `subscription_units` | number |
| `ad_streams` | number |
| `sub_streams` | number |

## Derived Table

```sql
sql:

    with total_sea as(

    WITH sums AS (SELECT
        FA.labelid,
        FA.artistid,
        FA.releaseid,
        FA.trackid,
        FA.transactiontypeid,
        DT.isrc as isrc,
        SUM(FA.units) as units
    FROM facts.prod.fact_analytics FA
    LEFT JOIN facts.prod.dim_track DT ON FA.isrcid = DT.isrcid
    WHERE FA.labelid = {% parameter filter_label_id %
```