# View: dt_charts_monitoring_latest_update

**View Name:** dt_charts_monitoring_latest_update
**Table Source:** `Derived from: Prod.Dim_Chart`
**File Path:** `dt_charts_monitoring_latest_update.view.lkml`

## Overview

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

## Comments & Notes

- FFAA00; font-size:100%;">{{ rendered_value }} days overdue</p>
- 58FA58; font-size:100%;">{{ rendered_value }}</p>

## Dimensions

| Name | Type |
|------|------|
| `platform` | string |
| `frequency` | string |
| `latest_chart_date` | date |
| `expected_latest_chart_date` | date |
| `outage` | number |
| `updated_charts` | number |

## SQL Comments

- TODO: add expected_updated_charts

## Derived Table

```sql
sql:
WITH latest
     AS (SELECT platform,
                frequency,
                MAX(latest_chart_date) AS latest_chart_date
         FROM   facts.prod.dim_chart
         GROUP  BY 1, 2
         ORDER  BY 1, 2)
SELECT latest.platform,
       latest.frequency,
       latest.latest_chart_date,
       CASE
         WHEN latest.frequency = 'weekly' THEN DATEADD(week, -1, CURRENT_DATE())
         WHEN latest.frequency = 'daily' AND latest.platform = 'spotify'
              THEN DATEADD(day, -2, CURRENT_DATE())
         WHEN latest.frequency = 'daily' AND latest.platform != 'spotify'
              THEN DATEADD(day, -1, CURRENT_DATE())
         ELSE DATEADD(day, -100, CURRENT_DATE())
       END AS expected_latest_chart_date,
       latest.latest_chart_date - expected_latest_chart_date AS outage,
       COUNT(dc.*) AS updated_charts
-- TODO: add expected_updated_charts
FROM   latest
       INNER JOIN facts.prod.dim_chart dc
               ON latest.platform = dc.platform
                  AND latest.frequency = dc.frequency
                  AND latest.latest_chart_date = dc.latest_chart_date
GROUP  BY 1, 2, 3
ORDER  BY 1, 2, 3;;
```