# View: orch_app_sales_goals_target_market_goal

**View Name:** orch_app_sales_goals_target_market_goal
**Table Source:** `Derived from: Fill_Nulls, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Prod_Sales_Goals_Sales_Goals, Prod_Sales_Goals_Sales_Goals.Sales_Goal, Prod_Sales_Goals_Sales_Goals.Store + 1 more`
**File Path:** `orch_app_sales_goals_target_market_goal.view.lkml`

## Overview

- **File Size:** 1836 bytes
- **Lines of Code:** 69
- **Dimensions:** 6
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | number |
| `sales_goal_id` | number |
| `store_name` | string |
| `country_id` | number |
| `country_name` | string |
| `store_id` | number |

## Measures

| Name | Type |
|------|------|
| `distribution_goal` | sum |
| `label_goal` | sum |

## Derived Table

```sql
sql:
WITH fill_nulls AS (
    SELECT DISTINCT id, store_id, country_id, country_name
    FROM orchard_app_reporting_v2.prod_sales_goals_sales_goals.sales_goal
        CROSS JOIN ( SELECT DISTINCT store_id FROM orchard_app_reporting_v2.prod_sales_goals_sales_goals.target_market_goal ) a
        CROSS JOIN ( SELECT DISTINCT country_id, country_name FROM orchard_app_reporting_v2.prod_sales_goals_sales_goals.target_market_goal ) b
)
SELECT
    ROW_NUMBER() OVER (ORDER BY fn.id) AS primary_key,
    fn.id AS sales_goal_id,
    fn.store_id,
    s.name AS store_name,
    fn.country_id,
    fn.country_name,
    ZEROIFNULL(distribution_goal_value) AS distribution_goal,
    ZEROIFNULL(label_goal_value) AS label_goal
FROM fill_nulls fn
    INNER JOIN orchard_app_reporting_v2.prod_sales_goals_sales_goals.store s ON fn.store_id = s.id
    LEFT JOIN ORCHARD_APP_REPORTING_V2.PROD_SALES_GOALS_SALES_GOALS.TARGET_MARKET_GOAL tmg ON fn.id = tmg.sales_goal_id
        AND fn.store_id = tmg.store_id
        AND fn.country_id = tmg.country_id ;;
```