# View: orch_app_sg_sales_goal

**View Name:** orch_app_sg_sales_goal
**Table Source:** `my_schema_name.tester`
**File Path:** `orch_app_sg_sales_goal.view.lkml`

## Overview

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

## Description

Unique ID for each user that has ordered

## Comments & Notes

- # You can specify the table name if it's different from the view name:
- sql_table_name: my_schema_name.tester ;;
- # # Define your dimensions and measures here, like this:

## Derived Table

```sql
#     sql: SELECT
#         user_id as user_id
#         , COUNT(*) as lifetime_orders
#         , MAX(orders.created_at) as most_recent_purchase_at
#       FROM orders
#       GROUP BY user_id
#       ;;
#
```