# View: dt_promusicae_certification_album_incl_youtube

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

## Overview

- **File Size:** 7505 bytes
- **Lines of Code:** 257
- **Dimensions:** 10
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

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

## Dimensions

| Name | Type |
|------|------|
| `upc` | string |
| `labelid` | string |
| `artistid` | string |
| `SEA` | number |
| `AD` | number |
| `PS` | number |
| `ad_streams` | number |
| `sub_streams` | number |
| `ad_supported_units` | number |
| `subscription_units` | number |

## Derived Table

```sql
sql:

    with total_sea as(

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