# View: int_dbt_prod_lmcp_fact_analytics_last_3_weeks

**View Name:** int_dbt_prod_lmcp_fact_analytics_last_3_weeks
**Table Source:** `"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."FACT_ANALYTICS_LAST_3_WEEKS"`
**File Path:** `int_dbt_prod_lmcp_fact_analytics_last_3_weeks.view.lkml`

## Overview

- **File Size:** 4968 bytes
- **Lines of Code:** 248
- **Dimensions:** 32
- **Measures:** 5
- **Dimension Groups:** 3
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Artistid` | number |
| `Dayid` | number |
| `Labelid` | number |
| `Storeid` | number |
| `Genreid` | number |
| `Releaseid` | number |
| `Trackid` | number |
| `Countryid` | number |
| `Transactiontypeid` | number |
| `Zipid` | number |
| `Catalogid` | number |
| `Isrcid` | number |
| `Imprintid` | number |
| `Currencyid` | number |
| `Storeuserid` | number |
| `Uuid` | string |
| `Subaccountid` | number |
| `Formatid` | number |
| `Listenduration` | number |
| `Playlistid` | number |
| `Sourcetypeid` | number |
| `Containertypeid` | number |
| `Stagingrawid` | number |
| `Feedid` | number |
| `Userid` | number |
| `Storeuserid_varchar` | string |
| `Licensorid` | number |
| `Regioncode` | string |
| `Subscriptionpaytierid` | number |
| `Subscriptiontypeid` | number |
| `Osid` | number |
| `Deviceid` | number |

## Measures

| Name | Type |
|------|------|
| `Royalty` | sum |
| `Royaltydollar` | sum |
| `Units` | sum |
| `Paidunits` | sum |
| `Freeunits` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `Processeddaytime` | time |
| `Download_activity_date` | time |
| `Reportdate` | time |