# 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:** 773 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;;
```