# View: dt_isrc_assignment_history

**View Name:** dt_isrc_assignment_history
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Isrcs, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `views/dt_isrc_assignment_history.view.lkml`

## Overview

- **File Size:** 655 bytes
- **Lines of Code:** 33
- **Dimensions:** 0
- **Measures:** 1
- **Dimension Groups:** 1
- **Filters:** 0

## Measures

| Name | Type |
|------|------|
| `count_isrc` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `last_updated` | time |

## Derived Table

```sql
sql:
    select last_updated,
      count(distinct(isrc)) as count_isrc
      from orchard_app_reporting_v2.art_relations_prod_art_relations.isrcs
      where status = 'used'
      and isrc is not null
      group by last_updated;;
```