# View: dt_top_playlist_by_country

**View Name:** dt_top_playlist_by_country
**Table Source:** `Derived from: Prod.Fact_Analytics`
**File Path:** `dt_top_playlist_by_country.view.lkml`

## Overview

- **File Size:** 2470 bytes
- **Lines of Code:** 101
- **Dimensions:** 10
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 2

## Dimensions

| Name | Type |
|------|------|
| `rank` | number |
| `country_id` | number |
| `countryname` | string |
| `days_since_release` | number |
| `label_id` | number |
| `playlist` | number |
| `playlist_name` | string |
| `artistid` | number |
| `month` | number |
| `year` | number |

## Measures

| Name | Type |
|------|------|
| `streams` | sum |

## Filters

- `countryid`
- `labelid`

## Derived Table

```sql
sql:
      WITH content_filter AS (
          SELECT playlistid, countryid, SUM(units) AS streams
          FROM facts.prod.fact_analytics
          WHERE {% condition countryid %
```