# View: dt_trending_tracks

**View Name:** dt_trending_tracks
**Table Source:** `Derived from: Prod.Demographics_Region_Mapping_V2`
**File Path:** `dt_trending_tracks.view.lkml`

## Overview

- **File Size:** 4110 bytes
- **Lines of Code:** 185
- **Dimensions:** 10
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- Or, you could make this view a derived table, like this:
- of streams earned in the past week to be considered for spiking "

## Dimensions

| Name | Type |
|------|------|
| `rowid` | number |
| `labelid` | number |
| `subaccountid` | number |
| `artistid` | number |
| `isrc` | string |
| `weekly_streams` | number |
| `expected_weekly_streams` | number |
| `percent_above_avrg` | number |
| `standard_deviation` | number |
| `spike_score` | number |

## Derived Table

```sql
sql:

  WITH region_codes AS (
    SELECT
      DISTINCT region_code
    FROM facts.prod.demographics_region_mapping_v2
    WHERE orchard_region_name ILIKE '%{% parameter region_filter %
```