# View: dt_top_stores_by_artist

**View Name:** dt_top_stores_by_artist
**Table Source:** `Derived from: Prod.Fact_Analytics`
**File Path:** `dt_top_stores_by_artist.view.lkml`

## Overview

- **File Size:** 1270 bytes
- **Lines of Code:** 59
- **Dimensions:** 3
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 2

## Dimensions

| Name | Type |
|------|------|
| `rank` | number |
| `store_name` | string |
| `activity_date` | date |

## Measures

| Name | Type |
|------|------|
| `streams` | sum |

## Filters

- `label_id`
- `artistid`

## Derived Table

```sql
sql:

  WITH content_filter AS (
    SELECT storeid, dayid, SUM(units) AS streams
    FROM facts.prod.fact_analytics
    WHERE {% condition label_id %
```