# View: dt_top_tracks_test

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

## Overview

- **File Size:** 2606 bytes
- **Lines of Code:** 115
- **Dimensions:** 4
- **Measures:** 5
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `shit_primary_key` | number |
| `trackid` | number |
| `artistid` | number |
| `labelid` | number |

## Measures

| Name | Type |
|------|------|
| `most_recent_day` | sum |
| `current_week` | sum |
| `last_week` | sum |
| `last_full_week` | sum |
| `last_12_months` | sum |

## Filters

- `country`

## Derived Table

```sql
sql:
WITH date_difference AS (
    SELECT
      CASE
        WHEN DAYNAME(CURRENT_DATE()-2) = 'Fri' THEN 0
        ELSE  DATEDIFF(day,CURRENT_DATE()-2,PREVIOUS_DAY(CURRENT_DATE()-2,'Friday'))
    END AS diff
    ),

countries AS (SELECT countryid FROM facts.prod.dim_country WHERE {% condition country %
```