# View: delivery_history_snowflake_aggregated

**View Name:** delivery_history_snowflake_aggregated
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Delivery_History, Art_Relations_Prod_Art_Relations.Releases, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `delivery_history_snowflake_aggregated.view.lkml`

## Overview

- **File Size:** 2825 bytes
- **Lines of Code:** 111
- **Dimensions:** 7
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 2

## Comments & Notes

- dimension: package_size {
- hidden: yes
- type: number

## Dimensions

| Name | Type |
|------|------|
| `count_deliveries` | number |
| `delivered_status` | string |
| `encoder_id` | number |
| `upc` | string |
| `customer_master_master_id` | number |
| `max_date_delivered` | date |
| `min_date_delivered` | date |

## Measures

| Name | Type |
|------|------|
| `count_upc` | count_distinct |

## Filters

- `encoder_id_filter`
- `filter_storeid`

## Derived Table

```sql
sql:  select r.UPC
                , delivered.customer_master_master_id
                , max(delivered.date_delivered) as max_date_delivered
                , min(delivered.date_delivered) as min_date_delivered
                , CASE WHEN count(delivered.delivery_id)>0
                      THEN 'Delivered'
                      Else 'Not Delivered'
                      END AS delivered_status
                ,count(delivery_id) as count_deliveries
        from orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
        LEFT JOIN (select delivery_id
                    , UPC
                    , date_delivered
                    , customer_master_master_id
              from orchard_app_reporting_v2.art_relations_prod_art_relations.delivery_history
              where {% condition encoder_id_filter %
```