# View: anr_missing_days

**View Name:** anr_missing_days
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `anr_missing_days.view.lkml`

## Overview

- **File Size:** 8239 bytes
- **Lines of Code:** 239
- **Dimensions:** 8
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `dates` | string |
| `instagram` | string |
| `spotify` | string |
| `youtube` | string |
| `soundcloud` | string |
| `shazam` | string |
| `tiktok` | string |

## Derived Table

```sql
sql: with missing_dates as (with update_dates as (select distinct a.artist,
               i.LAST_PROCESSING_DATE as "Instagram",
               s.LAST_PROCESSING_DATE as "Spotify",
               y.LAST_PROCESSING_DATE as "YouTube",
              ss.LAST_PROCESSING_DATE as "SoundCloud",
              sh.LAST_PROCESSING_DATE as "Shazam"
              //t.LAST_PROCESSING_DATE as "TikTok"
from TABLE({% parameter artist_table_name %
```