# View: _NEW_chartmetric_spotify_playlist_stats

**View Name:** chartmetric_spotify_playlist_stats
**Table Source:** `CHARTMETRIC.RAW_DATA.L_SPOTIFY_PLAYLIST_STAT`
**File Path:** `views/_NEW_chartmetric_spotify_playlist_stats.view.lkml`

## Overview

- **File Size:** 2501 bytes
- **Lines of Code:** 77
- **Dimensions:** 3
- **Measures:** 4
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- =========================================================================
- 1. FOREIGN KEYS FOR JOINING (No Primary Key as this is a log table)
- =========================================================================

## Dimensions

| Name | Type |
|------|------|
| `spotify_track_id_fk` | number |
| `spotify_playlist_id_fk` | number |
| `position` | number |

## Measures

| Name | Type |
|------|------|
| `record_count` | count |
| `average_position` | average |
| `peak_position` | min |
| `lowest_position` | max |

## Dimension Groups

| Name | Type |
|------|------|
| `snapshot` | time |