# View: dt_weekly_spikes_v2

**View Name:** dt_weekly_spikes_v2
**Table Source:** `Derived from: Prod.Dim_Country`
**File Path:** `dt_weekly_spikes_v2.view.lkml`

## Overview

- **File Size:** 5434 bytes
- **Lines of Code:** 197
- **Dimensions:** 10
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 2

## Comments & Notes

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

## Dimensions

| Name | Type |
|------|------|
| `labelid` | number |
| `subaccountid` | number |
| `artistid` | number |
| `releaseid` | number |
| `trackid` | number |
| `storeid` | number |
| `today_streams` | number |
| `average_streams` | number |
| `percent_above_average` | number |
| `spike_score` | number |

## Filters

- `country_filter`
- `store_filter`

## Derived Table

```sql
sql:  WITH countries AS (SELECT countryid FROM facts.prod.dim_country WHERE {% condition country_filter %
```