# View: dt_label_review_accounting_release_level_country_release_ran

**View Name:** dt_label_review_accounting_release_level_country_release_ran
**Table Source:** `Derived from: Dbt_Prod_Label_Reviews.Label_Review_Accounting_Release_Level, Intelligence.Dbt_Prod_Label_Reviews`
**File Path:** `dt_label_review_accounting_release_level_country_release_ran.view.lkml`

## Overview

- **File Size:** 1327 bytes
- **Lines of Code:** 50
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `label_id` | number |
| `transaction_country_name` | string |
| `release_name` | string |
| `UPC` | string |
| `row_number` | number |

## SQL Comments

- and lower(digital_v_physical) = 'digital'

## Derived Table

```sql
sql:
      select
        label_id,
        transaction_country_name,
        release_name,
        upc,
        sum(gross_revenue_usd) as gross_revenue,
        row_number() over (partition by label_id, transaction_country_name order by gross_revenue desc) as row_number
      from INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL
      where
        (((activity_month ) >= ((DATEADD('year', -1, DATE_TRUNC('year', CURRENT_DATE()))))
            AND ( activity_month ) < ((DATEADD('year', 1, DATEADD('year', -1, DATE_TRUNC('year', CURRENT_DATE())))))))
      AND ((UPPER(( LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Transaction_group )) = UPPER('Streaming')))
      --and lower(digital_v_physical) = 'digital'
      group by 1,2,3,4
    ;;
```