# View: dt_soundcloud_units_by_day

**View Name:** dt_soundcloud_units_by_day
**Table Source:** `Derived from: Prod.Dim_Day, Prod.Dim_Licensor, Prod.Fact_Analytics`
**File Path:** `dt_soundcloud_units_by_day.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `displaydate` | date |

## Measures

| Name | Type |
|------|------|
| `units` | sum |

## Derived Table

```sql
sql:SELECT
          (TO_CHAR(TO_DATE(facts_prod_dim_day.displaydate ), 'YYYY-MM-DD')) AS displaydate,
          COALESCE(SUM(facts_prod_fact_analytics_for_master_calendar.units), 0)  AS units
      FROM facts.prod.dim_day  AS facts_prod_dim_day
      LEFT JOIN facts.prod.fact_analytics  AS facts_prod_fact_analytics_for_master_calendar ON facts_prod_dim_day.dayid = facts_prod_fact_analytics_for_master_calendar.dayid
      LEFT JOIN facts.prod.dim_licensor  AS facts_prod_dim_licensor ON facts_prod_dim_licensor.licensorid = facts_prod_fact_analytics_for_master_calendar.licensorid
      WHERE ((( facts_prod_dim_day.displaydate  ) >= ((DATEADD('day', -29, CURRENT_DATE()))) AND ( facts_prod_dim_day.displaydate  ) < ((DATEADD('day', 30, DATEADD('day', -29, CURRENT_DATE()))))))
      AND (facts_prod_fact_analytics_for_master_calendar.feedid = 43)
      GROUP BY
          (TO_DATE(facts_prod_dim_day.displaydate ))
      ORDER BY
          1
      FETCH NEXT 500 ROWS ONLY;;
```