# View: awa_internal_availability

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

## Overview

- **File Size:** 1144 bytes
- **Lines of Code:** 28
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `awa_displaydate` | date |
| `awa_units` | number |

## 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 = 44)
GROUP BY
    (TO_DATE(facts_prod_dim_day.displaydate ))
ORDER BY
    1
FETCH NEXT 500 ROWS ONLY;;
```