# View: dt_rank_tool

**View Name:** dt_rank_tool
**Table Source:** `Derived from: Prod.Dim_Artist, Prod.Dim_Country, Prod.Dim_Genre, Prod.Dim_Isrc, Prod.Dim_Label + 3 more`
**File Path:** `dt_rank_tool.view.lkml`

## Overview

- **File Size:** 6006 bytes
- **Lines of Code:** 172
- **Dimensions:** 7
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `rank1` | number |
| `rank1_value` | string |
| `rank1_metric` | number |
| `rank2_local` | number |
| `rank2_global` | number |
| `rank2_value` | string |
| `rank2_metric` | number |

## Derived Table

```sql
sql:
      WITH dim_values AS (
        SELECT 'artist' AS source, artistid AS id, artistname AS name FROM facts.prod.dim_artist
          UNION ALL SELECT 'country', countryid, countryname FROM facts.prod.dim_country
          UNION ALL SELECT 'genre', genreid, genrename FROM facts.prod.dim_genre
          UNION ALL SELECT 'label', labelid, labelname FROM facts.prod.dim_label
          UNION ALL SELECT 'store', storeid, storename FROM facts.prod.dim_store
          UNION ALL SELECT 'transactiontype', transactiontypeid, transactiontypedesc FROM facts.prod.dim_transactiontype
          UNION ALL SELECT 'release', releaseid, (releasename||'||'||TO_VARCHAR(releaseid)) FROM facts.prod.dim_release
          UNION ALL SELECT 'isrc', isrcid, (isrcname||'||'||artistname||'||'||isrc||'||'||dr.labelid) FROM facts.prod.dim_isrc di LEFT JOIN facts.prod.dim_release dr on dr.releaseid = di.upc LEFT JOIN facts.prod.dim_artist da ON da.artistid = dr.artistid WHERE track_id != 0
      ),
      rank1 AS (
        SELECT
          RANK() OVER (ORDER BY rank1_metric {{ order_results._parameter_value
```