# View: dt_top_tracks_by_artist

**View Name:** dt_top_tracks_by_artist
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Releases, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Dim_Artist, Prod.Fact_Analytics`
**File Path:** `dt_top_tracks_by_artist.view.lkml`

## Overview

- **File Size:** 2318 bytes
- **Lines of Code:** 76
- **Dimensions:** 5
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 4

## Dimensions

| Name | Type |
|------|------|
| `rank` | number |
| `track_name` | string |
| `isrc` | string |
| `days_since_release` | number |
| `weeks_since_release` | number |

## Measures

| Name | Type |
|------|------|
| `streams` | sum |

## Filters

- `label_id`
- `artistid`
- `artist_name`
- `imprint_name`

## Derived Table

```sql
sql:
    WITH content_filter AS (
        SELECT f.releaseid, f.isrcid AS isrcid, f.dayid, SUM(f.units) AS streams, da.artistname
        FROM facts.prod.fact_analytics f
        LEFT JOIN facts.prod.dim_artist da ON f.artistid = da.artistid
        LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r on f.releaseid = r.upc
        WHERE {% condition label_id %
```