# View: cm_spotify_chart_appearences

**View Name:** cm_spotify_chart_appearences
**Table Source:** `INTELLIGENCE.DBT_PROD.CM_SPOTIFY_CHART_APPEARANCES`
**File Path:** `cm_spotify_chart_appearences.view.lkml`

## Overview

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

## Comments & Notes

- derived_table: {
- sql:  with spotify_all_time as(
- #select s.isrc,  sc.spotify, sc.country, sc.chart_type, sc.rank

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |
| `times_charted` | number |

## Derived Table

```sql
#  sql:  with spotify_all_time as(
#
#select s.isrc,  sc.spotify, sc.country, sc.chart_type, sc.rank
#from CHARTMETRIC.RAW_DATA.SPOTIFY_CHART sc
#left join CHARTMETRIC.RAW_DATA.SPOTIFY s on sc.spotify = s.id)
#
#select isrc, count(isrc) as times_charted
#from spotify_all_time
#group by isrc
#order by 2 desc ;;
#
```