# View: ChartMetric_WatchList

**View Name:** chartmetric_watchlist
**Table Source:** `Derived from: Chartmetric.Raw_Data, Prod.Performance_Nr_Sound_Recording, Raw_Data.L_Spotify_Playlist_Stat, Raw_Data.Spotify, Raw_Data.Spotify_Playlist`
**File Path:** `views/ChartMetric_WatchList.view.lkml`

## Overview

- **File Size:** 1597 bytes
- **Lines of Code:** 67
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `ARTIST_NAME` | string |
| `Source_Score` | number |
| `Playlist_Name` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `Added_Date` | time |

## Derived Table

```sql
sql:
SELECT
    s.ARTIST_NAME,
    sp.NAME AS PLAYLIST_NAME,
    s.POPULARITY_SCORE AS SOURCE_SCORE,
    TO_VARCHAR(s.CREATED_AT, 'yyyy-mm-dd') AS ADDED_DATE
FROM CHARTMETRIC.RAW_DATA.SPOTIFY s
LEFT JOIN CHARTMETRIC.RAW_DATA.L_SPOTIFY_PLAYLIST_STAT sps
    ON sps.spotify = s.id
LEFT JOIN CHARTMETRIC.RAW_DATA.SPOTIFY_PLAYLIST sp
    ON sps.spotify_playlist = sp.id
LEFT JOIN FACTS.prod.performance_nr_sound_recording sr
    ON s.ISRC = sr.ISRC
WHERE sp.playlist_id IN (
    '2G8aPd8FKYBgFKvRGzf3V3',
    '5X8lN5fZSrLnXzFtDEUwb9',
    '37i9dQZEVXbMDoHDwVN2tF',
    '37i9dQZEVXbLiRSasKsNU9'
)
QUALIFY ROW_NUMBER() OVER (
    PARTITION BY sp.playlist_id, s.artist_name
    ORDER BY s.POPULARITY_SCORE DESC, s.CREATED_AT ASC
) = 1;;
```