# View: chartmetric_top_n_tracks

**View Name:** chartmetric_top_n_tracks
**Table Source:** `Derived from: Dbt_Hstanhope_Knr.Chartmetric_Perf_Content_Income, Intelligence.Dbt_Hstanhope_Knr`
**File Path:** `views/chartmetric_top_n_tracks.view.lkml`

## Overview

- **File Size:** 1005 bytes
- **Lines of Code:** 34
- **Dimensions:** 1
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |

## Measures

| Name | Type |
|------|------|
| `play_count` | max |
| `average_market_share` | average |

## Derived Table

```sql
sql:
    SELECT *
    FROM (
      SELECT *,
             ROW_NUMBER() OVER (PARTITION BY COUNTRY_NAME, YEAR ORDER BY PLAY_COUNT DESC) AS row_num
      FROM intelligence.dbt_hstanhope_knr.chartmetric_perf_content_income
    ) ranked
    WHERE row_num <= {% parameter chartmetric_perf_marketshare.top_n %
```