# View: dt_top_tracks

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

## Overview

- **File Size:** 5105 bytes
- **Lines of Code:** 209
- **Dimensions:** 10
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Comments & Notes

- Or, you could make this view a derived table, like this:

## Dimensions

| Name | Type |
|------|------|
| `labelid` | number |
| `artistid` | number |
| `trackid` | number |
| `most_recent_date` | date |
| `most_recent_day` | number |
| `current_week_to_date` | number |
| `last_week_to_date` | number |
| `last_full_week` | number |
| `last_12_months` | number |
| `weekly_trend_to_date` | number |

## 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
    ),

date_definitions AS (
  SELECT
    TO_CHAR(CURRENT_DATE()-2) AS most_recent_day_label,
    TO_CHAR(DATEADD(day,(SELECT diff FROM date_difference), CURRENT_DATE()-2)) || ' - ' || TO_CHAR(CURRENT_DATE()-2) AS current_week_label,
    TO_CHAR(DATEADD(day,(SELECT diff FROM date_difference) - 7, CURRENT_DATE()-2)) || ' - ' || TO_CHAR(DATEADD(day,-7,CURRENT_DATE()-2)) AS last_week_label,
    TO_CHAR(DATEADD(day,(SELECT diff FROM date_difference) -7, CURRENT_DATE()-2)) || ' - ' || TO_CHAR(DATEADD(day,(SELECT diff FROM date_difference)-1, CURRENT_DATE()-2)) AS last_full_week_label
FROM date_difference
),

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