# View: apple_music_sos_aggregated

**View Name:** apple_music_sos_aggregated
**Table Source:** `prod.APPLEMUSIC.APPLE_MUSIC_SOS_AGGREGATED`
**File Path:** `apple_music_sos_aggregated.view.lkml`

## Overview

- **File Size:** 11861 bytes
- **Lines of Code:** 462
- **Dimensions:** 33
- **Measures:** 3
- **Dimension Groups:** 2
- **Filters:** 0

## Description

Total number of streams by given filter

## Dimensions

| Name | Type |
|------|------|
| `units_cat` | number |
| `effective_units_calc_cat` | number |
| `action_type` | string |
| `aggregate` | string |
| `apple_identifier` | string |
| `avg_stream_duration` | string |
| `container_type` | string |
| `country_code` | string |
| `device` | string |
| `end_reason_type` | string |
| `weeks_since_release` | number |
| `days_since_release` | number |
| `months_since_release` | number |
| `country_code_grouping_for_territory_leads` | string |
| `isrc` | string |
| `item_artist` | string |
| `item_title` | string |
| `item_type` | string |
| `labelid` | string |
| `media_duration` | string |
| `media_type` | string |
| `membership` | string |
| `membership_mode` | string |
| `num_of_customer_identifiers` | string |
| `playlist_id` | string |
| `playlist_name` | string |
| `playlist_type` | string |
| `processed_daytime` | string |
| `source_of_stream` | string |
| `orchard_grouping` | string |
| `trackid` | string |
| `upc` | string |
| `zipcode` | string |

## Measures

| Name | Type |
|------|------|
| `estimated_revenue` | sum |
| `streams` | sum |
| `count` | count |

## Dimension Groups

| Name | Type |
|------|------|
| `friday_weekof` | time |
| `monday_weekof` | time |