# View: dt_track_compare

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

## Overview

- **File Size:** 28064 bytes
- **Lines of Code:** 627
- **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 all_tracks1 AS (

  SELECT
    t.trackid,
    t.upc,
    r.sale_start_date,
    rank() OVER (ORDER BY r.sale_start_date ASC) AS rank
  FROM FACTS.PROD.dim_track t
  INNER JOIN facts.prod.dim_release r ON r.releaseid=t.upc
  WHERE t.isrc = {% parameter isrc_dsr_1 %
```