# View: facts_prod_streams_by_country_feed_distributor_rollup_dbt

**View Name:** facts_prod_streams_by_country_feed_distributor_rollup_dbt
**Table Source:** `Derived from: Prod.V_Streams_By_Track_Country_Feed_Distributor_Rollup`
**File Path:** `facts_prod_streams_by_country_feed_distributor_rollup_dbt.view.lkml`

## Overview

- **File Size:** 4255 bytes
- **Lines of Code:** 186
- **Dimensions:** 9
- **Measures:** 10
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `row_number` | number |
| `track_id` | number |
| `country_code` | string |
| `feed_id` | number |
| `distributor` | string |
| `store_id` | number |
| `product_id` | number |
| `isrc` | string |
| `label_id` | string |

## Measures

| Name | Type |
|------|------|
| `streams_1day` | sum |
| `streams_1day_prev` | sum |
| `streams_7day` | sum |
| `streams_7days_prev` | sum |
| `streams_28days` | sum |
| `streams_28days_prev` | sum |
| `streams_183days` | sum |
| `streams_183days_prev` | sum |
| `streams_365days` | sum |
| `streams_all_time` | sum |

## Derived Table

```sql
sql:
      SELECT
        ROW_NUMBER() OVER (ORDER BY track_id, country_code, feed_id, product_id, isrc, distributor, label_id) AS row_number,
        track_id,
        country_code,
        feed_id,
        store_id,
        product_id,
        isrc,
        distributor,
        label_id,
        streams_1_day,
        streams_1_day_prev,
        streams_7_days,
        streams_7_days_prev,
        streams_28_days,
        streams_28_days_prev,
        streams_183_days,
        streams_183_days_prev,
        streams_365_days_prev,
        streams_all_time
      FROM (
        SELECT
          track_id,
          country_code,
          feed_id,
          store_id,
          product_id,
          isrc,
          distributor,
          label_id,
          SUM(streams_1_day) AS streams_1_day,
          SUM(streams_1_day_prev) AS streams_1_day_prev,
          SUM(streams_7_days) AS streams_7_days,
          SUM(streams_7_days_prev) AS streams_7_days_prev,
          SUM(streams_28_days) AS streams_28_days,
          SUM(streams_28_days_prev) AS streams_28_days_prev,
          SUM(streams_183_days) AS streams_183_days,
          SUM(streams_183_days_prev) AS streams_183_days_prev,
          SUM(streams_365_days_prev) AS streams_365_days_prev,
          SUM(streams_all_time) AS streams_all_time
        FROM FACTS.PROD.V_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP
        GROUP BY
          track_id,
          country_code,
          feed_id,
          store_id,
          product_id,
          isrc,
          distributor,
          label_id
      ) AS aggregated_data ;;
```