# View: dt_itunes_tickets_by_day

**View Name:** dt_itunes_tickets_by_day
**Table Source:** `Derived from: Prod.Dim_Day, Prod.Itunes_Tickets, Tickets_By_Day`
**File Path:** `dt_itunes_tickets_by_day.view.lkml`

## Overview

- **File Size:** 683 bytes
- **Lines of Code:** 32
- **Dimensions:** 1
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `filedate` | date |

## Measures

| Name | Type |
|------|------|
| `totaltickets` | sum |

## Derived Table

```sql
sql: WITH TICKETS_BY_DAY AS (SELECT
  TO_CHAR(TO_DATE(D.DISPLAYDATE), 'YYYY-MM-DD') AS FILE_DATE,
  TICKETS.TICKETID  AS TICKET
FROM FACTS.PROD.ITUNES_TICKETS AS TICKETS
LEFT JOIN FACTS.PROD.DIM_DAY D
ON D.DISPLAYDATE = TICKETS.FILE_DATE
ORDER BY 1)
SELECT
(TO_CHAR(TO_DATE(TICKETS_BY_DAY.FILE_DATE), 'YYYY-MM-DD')) AS filedate,
    COUNT(TICKETS_BY_DAY.TICKET) AS totaltickets
FROM TICKETS_BY_DAY
GROUP BY
    filedate
ORDER BY
    1 DESC
FETCH NEXT 500 ROWS ONLY;;
```