# View: youtube_statistics

**View Name:** youtube_statistics
**Table Source:** `Derived from: Dev_Engineering, Dev_Engineering.Npalchinskiy, Dt_Youtube_Engagement_By_Day, Npalchinskiy.Dim_Day, Npalchinskiy.Staging_Raw_Youtube_Statistics_101`
**File Path:** `youtube_statistics.view.lkml`

## Overview

- **File Size:** 1413 bytes
- **Lines of Code:** 41
- **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_YOUTUBE_ENGAGEMENT_BY_DAY AS (SELECT
        TO_CHAR(TO_DATE(D.DISPLAYDATE), 'YYYY-MM-DD') AS ENGAGEMENT_DATE,
        STATISTICS.LIKES_ENGAGEMENT AS LIKES,
        STATISTICS.COMMENTS_ENGAGEMENT AS COMMENTS,
        STATISTICS.ARTIST
      FROM DEV_ENGINEERING.NPALCHINSKIY.STAGING_RAW_YOUTUBE_STATISTICS_101 AS STATISTICS
      LEFT JOIN DEV_ENGINEERING.NPALCHINSKIY.DIM_DAY D
      ON D.DISPLAYDATE = STATISTICS.LAST_PROCESSING_DATE
      ORDER BY 1)
      SELECT
          DT_YOUTUBE_ENGAGEMENT_BY_DAY.ARTIST AS "ARTIST",
          DT_YOUTUBE_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE AS "ENGAGEMENT_DATE",
          COALESCE(DT_YOUTUBE_ENGAGEMENT_BY_DAY.LIKES, 0) + COALESCE(DT_YOUTUBE_ENGAGEMENT_BY_DAY.COMMENTS, 0) AS "ENGAGEMENT"
      FROM DT_YOUTUBE_ENGAGEMENT_BY_DAY
      WHERE (DT_YOUTUBE_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE) >= (DATEADD('day', -29, CURRENT_DATE()))
      GROUP BY
          DT_YOUTUBE_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE, DT_YOUTUBE_ENGAGEMENT_BY_DAY.LIKES, DT_YOUTUBE_ENGAGEMENT_BY_DAY.COMMENTS,
          DT_YOUTUBE_ENGAGEMENT_BY_DAY.ARTIST
      ORDER BY
          1 DESC;;
```