# View: dt_release_compare

**View Name:** dt_release_compare
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `dt_release_compare.view.lkml`

## Overview

- **File Size:** 28316 bytes
- **Lines of Code:** 574
- **Dimensions:** 40
- **Measures:** 8
- **Dimension Groups:** 2
- **Filters:** 0

## Comments & Notes

- timeframes: [
- day_of_year
- dimension: weeks_since_release {

## Dimensions

| Name | Type |
|------|------|
| `artistid` | number |
| `catalogid` | number |
| `containertypeid` | number |
| `countryid` | number |
| `currencyid` | number |
| `dayid` | number |
| `catalog_type` | string |
| `days_since_release_date` | number |
| `feedid` | number |
| `formatid` | number |
| `freeunits` | number |
| `genreid` | number |
| `imprintid` | number |
| `isrcid` | number |
| `labelid` | number |
| `licensorid` | number |
| `paidunits` | number |
| `playlistid` | number |
| `source_is_playlist` | yesno |
| `playlist_group` | string |
| `processeddaytime` | date_time |
| `releaseid` | number |
| `reportdate` | date |
| `royalty` | number |
| `royaltydollar` | number |
| `sourcetypeid` | number |
| `active_passive_collection` | string |
| `source_type_normalized` | string |
| `stagingrawid` | number |
| `storeid` | number |
| `storeuserid` | number |
| `storeuserid_varchar` | string |
| `subaccountid` | number |
| `subscriptionpaytierid` | number |
| `subscriptiontypeid` | number |
| `trackid` | number |
| `transactiontypeid` | number |
| `userid` | number |
| `uuid` | string |
| `region_code` | string |

## Measures

| Name | Type |
|------|------|
| `completion_rate` | average |
| `listener_duration` | sum |
| `units` | sum |
| `billboard_consumption_units_track` | sum |
| `billboard_consumption_units_album` | sum |
| `legacy_consumption_units_track` | sum |
| `legacy_consumption_units_album` | sum |
| `users` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `download_activity_date` | time |
| `Current` | time |

## Derived Table

```sql
sql:
        WITH track1 AS (

          WITH r1 AS (
            SELECT
              releasename,
              releaseid as UPC,
              sale_start_date AS lower_bound,
              DATE_FROM_PARTS(YEAR(lower_bound), MONTH(lower_bound),DAY(lower_bound)) AS lower_date,
              DATEADD(day,{% parameter days_since_release %
```