# View: line_anomaly_testing

**View Name:** line_anomaly_testing
**Table Source:** `Derived from: Dbt_Prod.Agg_Line_Model, Intelligence.Dbt_Prod, Max_Week`
**File Path:** `line_anomaly_testing.view.lkml`

## Overview

- **File Size:** 2891 bytes
- **Lines of Code:** 95
- **Dimensions:** 6
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- ea9999; padding: 2px 6px; border-radius: 4px;">{{ value | round: 2 }}%</span>
- ea9999; padding: 2px 6px; border-radius: 4px;">{{ value | round: 2 }}%</span>
- 72c275; padding: 2px 6px; border-radius: 4px;">{{ value | round: 2 }}%</span>

## Dimensions

| Name | Type |
|------|------|
| `store_name` | string |
| `week_start` | date |
| `row_count` | number |
| `total_streams` | number |
| `row_count_pct_change` | number |
| `streams_pct_change` | number |

## Measures

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

## Derived Table

```sql
sql: WITH max_week AS (
              SELECT DATEADD(WEEK, -1, MAX(DATE_TRUNC('WEEK', activity_date))) AS max_wk
              FROM intelligence.dbt_prod.agg_line_model
          )
          SELECT
              'Line' AS store_name,
              DATE_TRUNC('WEEK', activity_date) AS week_start,
              COUNT(*) AS row_count,
              SUM(streams) AS total_streams,
              ROUND(
                  (
                      (row_count - LAG(row_count) OVER (ORDER BY week_start)) /
                      NULLIF(LAG(row_count) OVER (ORDER BY week_start), 0)
                  ) * 100, 2
              ) AS row_count_pct_change,
              ROUND(
                  (
                      (SUM(streams) - LAG(SUM(streams)) OVER (ORDER BY week_start)) /
                      NULLIF(LAG(SUM(streams)) OVER (ORDER BY week_start), 0)
                  ) * 100, 2
              ) AS streams_pct_change
          FROM intelligence.dbt_prod.agg_line_model
          WHERE DATE_TRUNC('WEEK', activity_date) >= (
              SELECT DATEADD(WEEK, -1, max_wk) FROM max_week
          )
          GROUP BY week_start ;;
```