# View: dt_charts_monitoring_last_four_days

**View Name:** dt_charts_monitoring_last_four_days
**Table Source:** `Derived from: Charts_Raw_Data, Prod.Dim_Chart, Prod.Fact_Charts`
**File Path:** `dt_charts_monitoring_last_four_days.view.lkml`

## Overview

- **File Size:** 1243 bytes
- **Lines of Code:** 55
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `platform` | string |
| `frequency` | string |
| `one_day_back` | number |
| `two_days_back` | number |
| `three_days_back` | number |
| `four_days_back` | number |

## Derived Table

```sql
sql:
  WITH charts AS (
    WITH charts_raw_data AS (
      SELECT   dc.platform AS platform,
               dc.frequency,
               chart_date,
               count(DISTINCT fc.chartid) AS num_charts,
               row_number () over (partition BY platform, frequency ORDER BY chart_date DESC) n_days_back
      FROM     facts.prod.fact_charts fc
      JOIN     facts.prod.dim_chart dc
      ON       fc.chartid = dc.chartid
      GROUP BY 1, 2, 3 qualify n_days_back <= 4
      ORDER BY 1, 2, 3 DESC )
    SELECT platform,
           frequency,
           num_charts,
           n_days_back
    FROM   charts_raw_data )
  SELECT p.*
  FROM   charts pivot(sum(num_charts) FOR n_days_back IN (1,2,3,4)) AS p;;
```