# View: spotify_sme

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

## Overview

- **File Size:** 1820 bytes
- **Lines of Code:** 39
- **Dimensions:** 2
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `facts_prod_dim_day_displaydate` | string |
| `facts_prod_fact_analytics_for_master_calendar_units` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## SQL Comments

- raw sql results do not include filled-in values for 'facts_prod_dim_day.displaydate'

## Derived Table

```sql
sql: -- raw sql results do not include filled-in values for 'facts_prod_dim_day.displaydate'


      SELECT
        TO_CHAR(TO_DATE(facts_prod_dim_day.displaydate ), 'YYYY-MM-DD') AS "facts_prod_dim_day.displaydate",
        COALESCE(SUM(facts_prod_fact_analytics_for_master_calendar.units), 0)  AS "facts_prod_fact_analytics_for_master_calendar.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.labelid != 32551 AND facts_prod_fact_analytics_for_master_calendar.feedid NOT IN (8)
          AND facts_prod_dim_licensor.distributor = 'sme') AND (facts_prod_fact_analytics_for_master_calendar.feedid = 1)
      GROUP BY TO_DATE(facts_prod_dim_day.displaydate )
      ORDER BY 1
      LIMIT 500
       ;;
```