# View: int_prod_streaming_totals_last_sales_week_isrc_level

**View Name:** int_prod_streaming_totals_last_sales_week_isrc_level
**Table Source:** `intelligence.dbt_prod.streaming_totals_last_sales_week_isrc_level`
**File Path:** `int_prod_streaming_totals_last_sales_week_isrc_level.view.lkml`

## Overview

- **File Size:** 2125 bytes
- **Lines of Code:** 101
- **Dimensions:** 8
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 1

## Comments & Notes

- derived_table: {
- sql: WITH countries AS (SELECT countryid FROM facts.prod.dim_country WHERE {% condition country_code %} country_code {% endcondition %})
- #          ,country_totals AS (

## Dimensions

| Name | Type |
|------|------|
| `rowid` | number |
| `activity_week` | date |
| `labelid` | number |
| `artistid` | number |
| `isrc` | string |
| `track_name` | string |
| `storeid` | number |
| `countryid` | number |

## Measures

| Name | Type |
|------|------|
| `store_units` | sum |

## Filters

- `country_code`

## Derived Table

```sql
#  sql: WITH countries AS (SELECT countryid FROM facts.prod.dim_country WHERE {% condition country_code %
```