# View: project_moments_ma_calculation

**View Name:** project_moments_ma_calculation
**Table Source:** `INTELLIGENCE.DBT_PROD_PROJECT_MOMENTS.project_moments_ma_calculation_key_identifier`
**File Path:** `views/project_moments_ma_calculation.view.lkml`

## Overview

- **File Size:** 12946 bytes
- **Lines of Code:** 428
- **Dimensions:** 27
- **Measures:** 20
- **Dimension Groups:** 4
- **Filters:** 0

## Comments & Notes

- Future Iteration - use liquid variables and user input parameters to allow the user to change the pre-requisites
- Future Iteration - use liquid variables and user input parameters to allow the user to change the pre-requisites
- ACTIONABLE vs WATCHLIST

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `artistid` | number |
| `date_diff` | number |
| `isrc` | string |
| `linear_gradient` | number |
| `max_week_rolling_seven_day_ma_value` | number |
| `perc_change` | number |
| `releasename` | string |
| `seven_day_ma_eight_week_later` | number |
| `seven_day_ma_five_week_later` | number |
| `seven_day_ma_four_week_later` | number |
| `seven_day_ma_one_week_later` | number |
| `seven_day_ma_process_run_date` | number |
| `seven_day_ma_seven_week_later` | number |
| `seven_day_ma_six_week_later` | number |
| `seven_day_ma_three_week_later` | number |
| `seven_day_ma_two_week_later` | number |
| `stream_diff` | number |
| `track_name` | string |
| `transaction_country_code` | string |
| `actionable_vs_watchlist_dimension` | string |
| `upc` | number |
| `perc_change_search` | number |
| `linear_gradient_search` | number |
| `perc_change_all_sources` | number |
| `linear_gradient_all_sources` | number |
| `perc_search_collection` | number |

## Measures

| Name | Type |
|------|------|
| `isrc_distinct_count` | count_distinct |
| `isrc_distinct_count_actionable` | count_distinct |
| `isrc_distinct_count_watchlist` | count_distinct |
| `latest_max_week_rolling_seven_day_ma` | time |
| `latest_max_week_rolling_seven_day_ma_value` | number |
| `max_perc_change` | number |
| `latest_process_run_date` | time |
| `max_seven_day_ma_process_run_date` | number |
| `country_distinct_count` | count_distinct |
| `country_distinct_count_actionable` | count_distinct |
| `country_distinct_count_watchlist` | count_distinct |
| `actionable_vs_watchlist` | string |
| `count` | count |
| `latest_max_week_rolling_seven_day_ma_search` | time |
| `latest_max_week_rolling_seven_day_ma_value_search` | number |
| `max_perc_change_search` | number |
| `latest_max_week_rolling_seven_day_ma_all_sources` | time |
| `latest_max_week_rolling_seven_day_ma_value_all_sources` | number |
| `max_perc_change_all_sources` | number |
| `max_perc_search_collection` | number |

## Dimension Groups

| Name | Type |
|------|------|
| `max_week_rolling_seven_day_ma` | time |
| `process_run_date` | time |
| `max_week_rolling_seven_day_ma_search` | time |
| `max_week_rolling_seven_day_ma_all_sources` | time |