# View: spotify_statistics

**View Name:** spotify_statistics
**Table Source:** `Derived from: Dev_Engineering, Dev_Engineering.Npalchinskiy, Dt_Spotify_Popularity_By_Day, Npalchinskiy.Staging_Raw_Spotify_Statistics_19, Prod.Dim_Day`
**File Path:** `spotify_statistics.view.lkml`

## Overview

- **File Size:** 1197 bytes
- **Lines of Code:** 38
- **Dimensions:** 2
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `date` | date |
| `artist` | string |

## Measures

| Name | Type |
|------|------|
| `popularity` | sum |

## Derived Table

```sql
sql: WITH DT_SPOTIFY_POPULARITY_BY_DAY AS (SELECT
  TO_CHAR(TO_DATE(D.DISPLAYDATE), 'YYYY-MM-DD') AS POPULARITY_DATE,
  STATISTICS.SPOTIFY_POPULARITY AS POPULARITY,
  STATISTICS.ARTIST AS ARTIST
FROM DEV_ENGINEERING.NPALCHINSKIY.STAGING_RAW_SPOTIFY_STATISTICS_19 AS STATISTICS
LEFT JOIN FACTS.PROD.DIM_DAY D
ON D.DISPLAYDATE = STATISTICS.LAST_PROCESSING_DATE
ORDER BY 1)
SELECT
    DT_SPOTIFY_POPULARITY_BY_DAY.ARTIST AS "ARTIST",
    DT_SPOTIFY_POPULARITY_BY_DAY.POPULARITY_DATE AS "POPULARITY_DATE",
    COALESCE(DT_SPOTIFY_POPULARITY_BY_DAY.POPULARITY, 0) AS "POPULARITY"
FROM DT_SPOTIFY_POPULARITY_BY_DAY
WHERE (DT_SPOTIFY_POPULARITY_BY_DAY.POPULARITY_DATE) >= (DATEADD('day', -29, CURRENT_DATE()))
GROUP BY
    DT_SPOTIFY_POPULARITY_BY_DAY.POPULARITY_DATE, DT_SPOTIFY_POPULARITY_BY_DAY.POPULARITY, DT_SPOTIFY_POPULARITY_BY_DAY.ARTIST
ORDER BY
    1 ASC;;
```