# View: soundcloud-statistics

**View Name:** soundcloud_statistics
**Table Source:** `Derived from: Dev_Engineering, Dev_Engineering.Npalchinskiy, Dt_Soundcloud_Engagement_By_Day, Npalchinskiy.Dim_Day, Npalchinskiy.Staging_Raw_Soundcloud_Statistics_106`
**File Path:** `soundcloud-statistics.view.lkml`

## Overview

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

## Dimensions

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

## Measures

| Name | Type |
|------|------|
| `engagement` | sum |

## Derived Table

```sql
sql: WITH DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY AS (SELECT
        TO_CHAR(TO_DATE(D.DISPLAYDATE), 'YYYY-MM-DD') AS ENGAGEMENT_DATE,
        STATISTICS.PLAYS_ENGAGEMENT AS PLAYS,
        STATISTICS.ARTIST
      FROM DEV_ENGINEERING.NPALCHINSKIY.STAGING_RAW_SOUNDCLOUD_STATISTICS_106 AS STATISTICS
      LEFT JOIN DEV_ENGINEERING.NPALCHINSKIY.DIM_DAY D
      ON D.DISPLAYDATE = STATISTICS.LAST_PROCESSING_DATE
      ORDER BY 1)
      SELECT
          DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY.ARTIST AS "ARTIST",
          DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE AS "ENGAGEMENT_DATE",
          COALESCE(DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY.PLAYS, 0) AS "PLAYS"
      FROM DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY
      WHERE (DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE) >= (DATEADD('day', -29, CURRENT_DATE()))
      GROUP BY
          DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY.ARTIST, DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE, DT_SOUNDCLOUD_ENGAGEMENT_BY_DAY.PLAYS
      ORDER BY
          1 DESC;;
```