# View: anr_likes_statistics

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

## Overview

- **File Size:** 8788 bytes
- **Lines of Code:** 316
- **Dimensions:** 13
- **Measures:** 6
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `artist` | string |
| `date` | date |
| `editorail_playlists` | number |
| `notable_playlists` | number |
| `the_latest_Spotify_release` | date |
| `Instagram_comments_count` | number |
| `weekly_change_in_comments` | number |
| `current_Instagram_posts_count` | number |
| `weekly_change_in_posts` | number |
| `current_SoundCloud_plays` | number |
| `weekly_change_in_plays` | number |
| `YouTube_dislikes_count` | number |
| `YouTube_views_count` | number |

## Measures

| Name | Type |
|------|------|
| `Spotify` | max |
| `Instagram` | max |
| `SoundCloud` | max |
| `SoundCloud_plays` | max |
| `YouTube` | max |
| `YouTube_views` | 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 %
```