# View: int_dbt_prod_streaming_totals_last_7_days_isrc_level

**View Name:** int_dbt_prod_streaming_totals_last_7_days_isrc_level
**Table Source:** `intelligence.dbt_prod.streaming_totals_last_7_days_isrc_level`
**File Path:** `int_dbt_prod_streaming_totals_last_7_days_isrc_level.view.lkml`

## Overview

- **File Size:** 2164 bytes
- **Lines of Code:** 100
- **Dimensions:** 7
- **Measures:** 1
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- view: int_dbt_prod_streaming_totals_last_7_days_isrc_level {
- # Or, you could make this view a derived table, like this:
- derived_table: {

## Dimensions

| Name | Type |
|------|------|
| `rowid` | number |
| `labelid` | number |
| `artistid` | number |
| `storeid` | number |
| `countryid` | number |
| `isrc` | string |
| `track_name` | string |

## Measures

| Name | Type |
|------|------|
| `store_units` | sum |

## Dimension Groups

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

## 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
#       ;;
#
```