# View: TSZ_FA

**View Name:** tsz_fa
**Table Source:** `INTELLIGENCE.DBT_PROD.TSZ_FA`
**File Path:** `TSZ_FA.view.lkml`

## Overview

- **File Size:** 33840 bytes
- **Lines of Code:** 712
- **Dimensions:** 46
- **Measures:** 18
- **Dimension Groups:** 2
- **Filters:** 1

## Comments & Notes

- timeframes: [
- day_of_year
- dimension: regioncode {

## Dimensions

| Name | Type |
|------|------|
| `artistid` | number |
| `catalogid` | number |
| `containertypeid` | number |
| `countryid` | number |
| `is_local_activity_label` | yesno |
| `currencyid` | number |
| `dayid` | number |
| `catalog_type` | string |
| `days_since_release` | number |
| `weeks_since_release` | number |
| `months_since_release` | number |
| `feedid` | number |
| `formatid` | number |
| `freeunits` | number |
| `genreid` | number |
| `imprintid` | number |
| `isrcid` | number |
| `labelid` | number |
| `licensorid` | number |
| `paidunits` | number |
| `playlistid` | number |
| `source_is_playlist` | yesno |
| `playlist_group` | string |
| `processeddaytime` | date_time |
| `releaseid` | number |
| `reportdate` | date |
| `royalty` | number |
| `royaltydollar` | number |
| `sourcetypeid` | number |
| `active_passive_collection` | string |
| `source_type_normalized` | string |
| `stagingrawid` | number |
| `storeid` | number |
| `storeuserid` | number |
| `storeuserid_varchar` | string |
| `subaccountid` | number |
| `subscriptionpaytierid` | number |
| `subscriptiontypeid` | number |
| `trackid` | number |
| `transactiontypeid` | number |
| `userid` | string |
| `uuid` | string |
| `region_code` | string |
| `osid` | string |
| `deviceid` | string |
| `voice_activated` | yesno |

## Measures

| Name | Type |
|------|------|
| `local_activity_units` | sum |
| `non_local_activity_units` | sum |
| `international_reach` | number |
| `first_week_units` | sum |
| `completion_rate` | average |
| `listener_duration` | sum |
| `units` | sum |
| `unit_percentage` | percent_of_total |
| `billboard_consumption_units_track` | sum |
| `billboard_consumption_units_album` | sum |
| `legacy_consumption_units_track` | sum |
| `legacy_consumption_units_album` | sum |
| `users` | count_distinct |
| `streams_per_user` | number |
| `release_day_listeners` | count_distinct |
| `number_of_artists` | count_distinct |
| `units_breakdown_country_units_in_territory` | sum |
| `units_breakdown_country_units_not_in_territory` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `download_activity_date` | time |
| `Current` | time |

## Filters

- `units_breakdown_country_filter`