# View: prod_hidden_content_itunes_hidden

**View Name:** prod_hidden_content_itunes_hidden
**Table Source:** `prod.hidden_content.itunes_hidden`
**File Path:** `prod_hidden_content_itunes_hidden.view.lkml`

## Overview

- **File Size:** 3676 bytes
- **Lines of Code:** 177
- **Dimensions:** 20
- **Measures:** 4
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- sql_table_name: prod.hidden_content.itunes_hidden ;;
- ff0000; font-size:100%;">{{ rendered_value }}</div>
- dimension: album_name_via_itunes {

## Dimensions

| Name | Type |
|------|------|
| `apple_id` | number |
| `audio_must_be_redelivered_for_itunes_plus` | yesno |
| `content_owner` | string |
| `date_hidden` | date |
| `date_imported` | date |
| `date_ingested` | date |
| `report_date` | date |
| `days_since_hidden` | number |
| `imprint` | string |
| `within_window` | yesno |
| `genre` | string |
| `grid` | string |
| `is_complete` | yesno |
| `reason` | string |
| `upc` | number |
| `vendor_id` | string |
| `track_apple_id` | number |
| `track_isrc` | string |
| `track_name` | string |
| `is_unhidden` | string |

## Measures

| Name | Type |
|------|------|
| `count_apple_id` | count_distinct |
| `count_upc` | count_distinct |
| `total_discs` | sum |
| `total_tracks` | sum |

## Derived Table

```sql
sql:
    select distinct m.*,
      case when (l.apple_id is null and l.upc is null) then 'Yes' else 'No' end as is_unhidden
    from PROD.HIDDEN_CONTENT.ITUNES_HIDDEN m
    left join PROD.HIDDEN_CONTENT.VW_ITUNES_HIDDEN_LATEST l
      on m.upc = l.upc and m.apple_id = l.apple_id
  ;;
```