# View: awa_internal_availability

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

## Overview

- **File Size:** 930 bytes
- **Lines of Code:** 27
- **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 OUTER 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 = 44
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
    displaydate
ORDER BY
    1 DESC
FETCH NEXT 500 ROWS ONLY;;
```