# View: dt_labelcopy_ingest_rows_by_day

**View Name:** dt_labelcopy_ingest_rows_by_day
**Table Source:** `Derived from: Labelcopy_Ingest_Rows_By_Day, Prod.Dim_Day, Prod.Sme_Labelcopy_Ingest`
**File Path:** `dt_labelcopy_ingest_rows_by_day.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `display_date` | date |

## Measures

| Name | Type |
|------|------|
| `rows` | sum |

## Derived Table

```sql
sql:  WITH labelcopy_ingest_rows_by_day AS (SELECT
            (TO_CHAR(TO_DATE(facts_prod_dim_day.displaydate ), 'YYYY-MM-DD')) AS "displaydate",
            COALESCE(COUNT(labelcopy_ingest.stagingrawid), 0)  AS "rows"
        FROM facts.prod.dim_day  AS facts_prod_dim_day
        LEFT JOIN facts.prod.sme_labelcopy_ingest labelcopy_ingest  ON facts_prod_dim_day.displaydate = TO_DATE(labelcopy_ingest.date_succeeded)
        WHERE ((( facts_prod_dim_day.displaydate  ) >= ((DATEADD('day', -29, CURRENT_DATE()))) AND ( facts_prod_dim_day.displaydate  ) <=  CURRENT_DATE()
            AND status = 'INGESTED'
               ))
        GROUP BY
            (TO_DATE(facts_prod_dim_day.displaydate ))
        ORDER BY
            1
        FETCH NEXT 500 ROWS ONLY)
        SELECT
        (TO_CHAR(TO_DATE(labelcopy_ingest_rows_by_day."displaydate" ), 'YYYY-MM-DD')) AS displaydate,
        COALESCE(SUM(labelcopy_ingest_rows_by_day."rows"), 0) AS ingest_rows
    FROM labelcopy_ingest_rows_by_day
    GROUP BY
        (TO_DATE(labelcopy_ingest_rows_by_day."displaydate" ))
    ORDER BY
        1 DESC
    FETCH NEXT 500 ROWS ONLY;;
```