# View: worldwide_trending_tracks

**View Name:** worldwide_trending_tracks
**Table Source:** `Derived from: Analytics_Aggregated, Analytics_Aggregated.Activity_Date, Bi.Analytics_Aggregated`
**File Path:** `worldwide_trending_tracks.view.lkml`

## Overview

- **File Size:** 14265 bytes
- **Lines of Code:** 202
- **Dimensions:** 12
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `activity_date` | date |
| `trackid` | number |
| `isrc` | string |
| `releaseid` | string |
| `artistid` | number |
| `labelid` | number |
| `total_units` | number |
| `weekly_units` | number |
| `analytics_weekly_totals` | number |
| `analytics_orchard_weekly_totals` | number |
| `previous_week_units` | number |
| `blowing_up` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Filters

- `filter_country_code`

## Derived Table

```sql
sql:     SELECT   *
      FROM     (
                        SELECT   notifications_analytics.activity_date,
                                 notifications_analytics.trackid,
                                 notifications_analytics.isrc,
                                 notifications_analytics.releaseid,
                                 notifications_analytics.artistid,
                                 notifications_analytics.labelid,
                                 notifications_analytics.analytics_units AS total_units,
                                 notifications_analytics.weekly_units,
                                 notifications_analytics.analytics_weekly_totals,
                                 notifications_analytics.analytics_orchard_weekly_totals,
                                 notifications_analytics.previous_week_units,
                                 zeroifnull((((notifications_analytics.weekly_units-notifications_analytics.previous_week_units)/nullif(notifications_analytics.previous_week_units,0))*1000000)*(notifications_analytics.weekly_units/nullif(notifications_analytics.analytics_units,0))*(notifications_analytics.weekly_units/nullif(notifications_analytics.analytics_weekly_totals,0))) AS blowing_up
                        FROM     (
                                           SELECT    TO_CHAR(TO_DATE(DATEADD('day', (0 - MOD(EXTRACT(DOW FROM analytics_aggregated.activity_date )::integer - 5 + 7, 7)), analytics_aggregated.activity_date )), 'YYYY-MM-DD') AS activity_date,
                                                     analytics_aggregated.trackid,
                                                     analytics_aggregated.isrc,
                                                     analytics_aggregated.releaseid,
                                                     analytics_aggregated.artistid,
                                                     analytics_aggregated.labelid,
                                                     analytics_totals.analytics_units,
                                                     analytics_weekly_totals.analytics_weekly_totals,
                                                     analytics_orchard_weekly_totals.analytics_orchard_weekly_totals,
                                                     sum(analytics_aggregated.paidunits)                                                                                                                                                                                                        AS weekly_units,
                                                     lag(sum(analytics_aggregated.paidunits), 1, 0) over (partition BY analytics_aggregated.trackid,analytics_aggregated.isrc,analytics_aggregated.releaseid, analytics_aggregated.artistid,analytics_aggregated.labelid ORDER BY analytics_aggregated.trackid,analytics_aggregated.isrc, analytics_aggregated.releaseid,analytics_aggregated.artistid,analytics_aggregated.labelid, TO_CHAR(TO_DATE(DATEADD('day', (0 - MOD(EXTRACT(DOW FROM analytics_aggregated.activity_date )::integer - 5 + 7, 7)), analytics_aggregated.activity_date )), 'YYYY-MM-DD')) as previous_week_units
                                           FROM      prod.bi.analytics_aggregated
                                           LEFT JOIN
                                                     (
                                                              SELECT   a2.trackid,
                                                                       a2.isrc,
                                                                       a2.releaseid,
                                                                       a2.artistid,
                                                                       a2.labelid,
                                                                       sum(a2.paidunits) AS analytics_units
                                                              FROM     prod.bi.analytics_aggregated a2
                                                              WHERE    a2.aggregate = 'Track Level'
                                                              AND      a2.transac_type_abbr IN ('S',
                                                                                                'AS')
                                                              AND      {% condition filter_country_code %
```