# View: facts_prod_itunes_tickets

**View Name:** facts_prod_itunes_tickets
**Table Source:** `facts.prod.itunes_tickets`
**File Path:** `facts_prod_itunes_tickets.view.lkml`

## Overview

- **File Size:** 2284 bytes
- **Lines of Code:** 117
- **Dimensions:** 17
- **Measures:** 1
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- value_format: "0"
- TRY_TO_NUMERIC(${TABLE}.orchard_upc)

## Dimensions

| Name | Type |
|------|------|
| `file_date` | date |
| `ticketid` | string |
| `contentadamid` | number |
| `contentgenre` | string |
| `contentlanguage` | string |
| `contentprovider` | string |
| `contentticketstate` | string |
| `contenttickettype` | string |
| `contenttype` | string |
| `contentupc` | string |
| `contentvendorid` | string |
| `discnumber` | number |
| `last_modified` | date |
| `name` | string |
| `openedby` | string |
| `orchard_upc` | string |
| `tracknumber` | number |

## Measures

| Name | Type |
|------|------|
| `count_tickets` | count_distinct |

## Dimension Groups

| Name | Type |
|------|------|
| `created` | time |