# View: dt_music_analytics_in_review_report

**View Name:** dt_music_analytics_in_review_report
**Table Source:** `Derived from: In_Review_Report, Prod.Dim_Day, Prod.Staging_Raw_Music_Analytics_In_Review`
**File Path:** `dt_music_analytics_in_review_report.view.lkml`

## Overview

- **File Size:** 760 bytes
- **Lines of Code:** 32
- **Dimensions:** 1
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `file_date` | date |

## Measures

| Name | Type |
|------|------|
| `in_review` | sum |

## Derived Table

```sql
sql:
    WITH IN_REVIEW_REPORT AS (SELECT
      TO_DATE(D.DISPLAYDATE) AS FILE_DATE,
      STREAMS
    FROM FACTS.PROD.STAGING_RAW_MUSIC_ANALYTICS_IN_REVIEW AS IN_REVIEW
    LEFT JOIN FACTS.PROD.DIM_DAY D
    ON D.DISPLAYDATE = IN_REVIEW.DOWNLOAD_DATE
    ORDER BY 1)
    SELECT
      (TO_CHAR(TO_DATE(IN_REVIEW_REPORT.FILE_DATE), 'YYYY-MM-DD')) AS FILE_DATE,
          COUNT(IN_REVIEW_REPORT.STREAMS) AS STREAMS
      FROM IN_REVIEW_REPORT
      GROUP BY
          FILE_DATE
      ORDER BY
          1 DESC
      FETCH NEXT 500 ROWS ONLY;;
```