# View: dt_tiktok_rows_by_day

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

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `displaydate` | date |

## Measures

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

## Derived Table

```sql
sql: SELECT
            (TO_CHAR(TO_DATE(facts_prod_dim_day.displaydate ), 'YYYY-MM-DD')) AS "displaydate",
            COALESCE(COUNT(FACTS.PROD.STAGING_RAW_TIKTOK.row_id), 0)  AS "rows"
        FROM facts.prod.dim_day  AS facts_prod_dim_day
        LEFT JOIN facts.prod.staging_raw_tiktok  ON facts_prod_dim_day.displaydate = facts.prod.staging_raw_tiktok.download_date
        WHERE ((( facts_prod_dim_day.displaydate  ) >= ((DATEADD('day', -29, CURRENT_DATE()))) AND ( facts_prod_dim_day.displaydate  ) <= ((DATEADD('day', -1, CURRENT_DATE() )))))
        GROUP BY
            (TO_DATE(facts_prod_dim_day.displaydate ))
        ORDER BY
            1
        FETCH NEXT 500 ROWS ONLY;;
```