# 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:** 1167 bytes
- **Lines of Code:** 30
- **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_fact_analytics_for_master_calendar.dayid = facts_prod_dim_day.dayid and facts_prod_fact_analytics_for_master_calendar.feedid = 43
      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()))
      GROUP BY
          (TO_DATE(facts_prod_dim_day.displaydate ))
      ORDER BY
          1
      FETCH NEXT 500 ROWS ONLY;;
```