# View: holiday_trending_report

**View Name:** holiday_trending_report
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `holiday_trending_report.view.lkml`

## Overview

- **File Size:** 8842 bytes
- **Lines of Code:** 207
- **Dimensions:** 13
- **Measures:** 5
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `int_dbt_prod_summary_streams_upc` | string |
| `facts_prod_dim_artist_artist_name` | string |
| `facts_prod_dim_track_track_name` | string |
| `int_dbt_prod_summary_streams_isrc` | string |
| `facts_prod_dim_label_label_name` | string |
| `release_genre_genre` | string |
| `orch_app_ar_releases_release_date` | date |
| `label_manager_orchadmin_user` | string |
| `int_dbt_prod_summary_streams_store` | string |
| `transaction_country_country_name` | string |
| `orch_app_ar_releases_is_active` | string |
| `int_dbt_prod_awal_tier_groups_brand_name` | string |
| `primarykey` | string |

## Measures

| Name | Type |
|------|------|
| `count` | count |
| `int_dbt_prod_summary_streams_streams` | sum |
| `current_period_streams` | sum |
| `previous_period_streams` | sum |
| `percentage_change` | number |

## Derived Table

```sql
sql: SELECT
          ltrim(int_dbt_prod_summary_streams.upc, '0') AS "int_dbt_prod_summary_streams.upc",
          facts_prod_dim_artist.artistname AS "facts_prod_dim_artist.artist_name",
          facts_prod_dim_track.trackname AS "facts_prod_dim_track.track_name",
          int_dbt_prod_summary_streams.isrc AS "int_dbt_prod_summary_streams.isrc",
          facts_prod_dim_label.labelname AS "facts_prod_dim_label.label_name",
          release_genre.genre AS "release_genre.genre",
          (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date), 'YYYY-MM-DD')) AS "orch_app_ar_releases.release_date",
          label_manager.f_name || ' ' || label_manager.l_name AS "label_manager.orchadmin_user",
          int_dbt_prod_summary_streams.store AS "int_dbt_prod_summary_streams.store",
          transaction_country.countryname AS "transaction_country.country_name",
          (CASE WHEN orch_app_ar_releases.release_status = 'in_content' AND orch_app_ar_releases.deletions = 'N' AND orch_app_ar_releases.not_for_distribution = 'N' THEN 'Yes' ELSE 'No' END) AS "orch_app_ar_releases.is_active",
          int_dbt_prod_awal_tier_groups.brand_name AS "int_dbt_prod_awal_tier_groups.brand_name",
          COALESCE(SUM(int_dbt_prod_summary_streams.streams), 0) AS "int_dbt_prod_summary_streams.streams",
          SUM(CASE WHEN download_activity_date BETWEEN {% parameter activity_date_3 %
```