# View: int_dbt_prod_orch_spotify_top_200_chart_appearances

**View Name:** int_dbt_prod_orch_spotify_top_200_chart_appearances
**Table Source:** `intelligence.dbt_prod.orch_spotify_top_200_chart_appearances`
**File Path:** `int_dbt_prod_orch_spotify_top_200_chart_appearances.view.lkml`

## Overview

- **File Size:** 4030 bytes
- **Lines of Code:** 194
- **Dimensions:** 27
- **Measures:** 3
- **Dimension Groups:** 2
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Chart_country` | string |
| `Artist_name` | string |
| `Spotify_artist_id` | string |
| `Isrc` | string |
| `Current_rank` | number |
| `Peak_rank` | number |
| `Min_chart_date` | date |
| `Max_chart_date` | date |
| `Days_to_chart` | number |
| `Hit` | number |
| `Previous_hit` | number |
| `Previous_hit_country` | string |
| `Days_since_last_hit` | number |
| `Latest_hit_date` | date |
| `Acousticness` | number |
| `Danceability` | number |
| `Duration_ms` | number |
| `Energy` | number |
| `Instrumentalness` | number |
| `Key` | number |
| `Liveness` | number |
| `Loudness` | number |
| `Mode` | number |
| `Speechiness` | number |
| `Tempo` | number |
| `Time_signature` | number |
| `Valence` | number |

## Measures

| Name | Type |
|------|------|
| `Spotify_followeres` | sum |
| `Spotify_popularity` | sum |
| `Spotify_monthly_listeners` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `Min_release_date` | time |
| `Fixed_release_date` | time |

