# View: dt_project_moments_pred_vs_actual_140_days

**View Name:** dt_project_moments_pred_vs_actual_140_days
**Table Source:** `INTELLIGENCE.DBT_PROD_PROJECT_MOMENTS.PROJECT_MOMENTS_SPOTIFY_ACTUAL_VS_PREDICTED`
**File Path:** `dt_project_moments_pred_vs_actual_140_days.view.lkml`

## Overview

- **File Size:** 1899 bytes
- **Lines of Code:** 94
- **Dimensions:** 1
- **Measures:** 4
- **Dimension Groups:** 2
- **Filters:** 0

## Comments & Notes

- derived_table: {
- when activity_date = '2023-10-14' then 1
- end as seven_day_marker

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |

## Measures

| Name | Type |
|------|------|
| `count_isrc` | count_distinct |
| `actual_streams` | sum |
| `predicted_streams` | sum |
| `seven_day_marker` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_date` | time |
| `process_run_date` | time |

## Derived Table

```sql
#  sql:
  #  select
  #    *,
  #    case
  #      when activity_date = '2023-10-14' then 1
  #      else 0
  #      end as seven_day_marker
  #  from intelligence.dev_tallman.SUBSET_PREDICTED_VALUES_2023_DATA
  #  ;;
  #
```