# View: anr_followers_statistics

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

## Overview

- **File Size:** 7471 bytes
- **Lines of Code:** 263
- **Dimensions:** 8
- **Measures:** 4
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `date` | date |
| `the_latest_Spotify_release` | date |
| `current_Instagram_posts_count` | number |
| `weekly_change_in_posts` | number |
| `current_SoundCloud_tracks_count` | number |
| `weekly_change_in_tracks_count` | number |
| `YouTube_videos_count` | number |

## Measures

| Name | Type |
|------|------|
| `Spotify` | max |
| `Instagram` | max |
| `SoundCloud` | max |
| `YouTube` | max |

## Derived Table

```sql
sql: WITH INSTAGRAM AS (
        WITH tmp AS (
          SELECT
            *,
            ROW_NUMBER() OVER (
              ORDER BY
                LAST_PROCESSING_DATE
            ) AS rn
          FROM
            TABLE({% parameter instagram_table_name %
```