# View: instagram_statistics

**View Name:** instagram_statistics
**Table Source:** `Derived from: Dev_Engineering, Dev_Engineering.Npalchinskiy, Dt_Instagram_Engagement_By_Day, Npalchinskiy.Dim_Day, Npalchinskiy.Staging_Raw_Instagram_Statistics`
**File Path:** `instagram_statistics.view.lkml`

## Overview

- **File Size:** 1199 bytes
- **Lines of Code:** 40
- **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_INSTAGRAM_ENGAGEMENT_BY_DAY AS (SELECT
  TO_CHAR(TO_DATE(D.DISPLAYDATE), 'YYYY-MM-DD') AS ENGAGEMENT_DATE,
  STATISTICS.ENGAGEMENT  AS ENGAGEMENT,
  STATISTICS.ARTIST AS ARTIST
FROM DEV_ENGINEERING.NPALCHINSKIY.staging_raw_instagram_statistics AS STATISTICS
LEFT JOIN DEV_ENGINEERING.NPALCHINSKIY.DIM_DAY D
ON D.DISPLAYDATE = STATISTICS.LAST_PROCESSING_DATE
ORDER BY 1)
SELECT
    DT_INSTAGRAM_ENGAGEMENT_BY_DAY.ARTIST AS "ARTIST",
    DT_INSTAGRAM_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE AS "ENGAGEMENT_DATE",
    COALESCE(DT_INSTAGRAM_ENGAGEMENT_BY_DAY.ENGAGEMENT, 0) AS "ENGAGEMENT"
FROM DT_INSTAGRAM_ENGAGEMENT_BY_DAY
WHERE (DT_INSTAGRAM_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE) >= (DATEADD('day', -29, CURRENT_DATE()))
GROUP BY
    DT_INSTAGRAM_ENGAGEMENT_BY_DAY.ENGAGEMENT_DATE, DT_INSTAGRAM_ENGAGEMENT_BY_DAY.ENGAGEMENT,
    DT_INSTAGRAM_ENGAGEMENT_BY_DAY.ARTIST
ORDER BY
    1 DESC;;
```