# View: dt_playlist_track_fit_v2_2stddev

**View Name:** dt_playlist_track_fit_v2_2stddev
**Table Source:** `Derived from: Dbt_Prod.Artist_Track_Metadata, Intelligence.Dbt_Prod`
**File Path:** `dt_playlist_track_fit_v2_2stddev.view.lkml`

## Overview

- **File Size:** 49200 bytes
- **Lines of Code:** 1106
- **Dimensions:** 49
- **Measures:** 54
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- Playlist Dimensions and Measures
- Track Dimensions and Measures
- Track Dimensions and Measures

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `storeid` | number |
| `cm_playlist_id` | number |
| `playlist_name` | string |
| `previous_artist_tracks_on_playlist_dimension` | number |
| `playlist_url` | string |
| `playlist_uri` | string |
| `playlist_avg_acousticness` | number |
| `playlist_stddev_acousticness` | number |
| `playlist_avg_danceability` | number |
| `playlist_stddev_danceability` | number |
| `playlist_avg_energy` | number |
| `playlist_stddev_energy` | number |
| `playlist_avg_instrumentalness` | number |
| `playlist_stddev_instrumentalness` | number |
| `playlist_avg_liveness` | number |
| `playlist_stddev_liveness` | number |
| `playlist_avg_loudness` | number |
| `playlist_stddev_loudness` | number |
| `playlist_avg_speechiness` | number |
| `playlist_stddev_speechiness` | number |
| `playlist_avg_tempo` | number |
| `playlist_stddev_tempo` | number |
| `playlist_avg_duration_ms` | number |
| `playlist_stddev_duration_ms` | number |
| `playlist_avg_key` | number |
| `playlist_stddev_key` | number |
| `playlist_avg_mode` | number |
| `playlist_stddev_mode` | number |
| `playlist_avg_time_signature` | number |
| `playlist_stddev_time_signature` | number |
| `playlist_avg_valence` | number |
| `playlist_stddev_valence` | number |
| `track_isrc` | string |
| `track_uri` | string |
| `track_acousticness` | number |
| `track_danceability` | number |
| `track_duration_ms` | number |
| `track_energy` | number |
| `track_instrumentalness` | number |
| `track_key` | number |
| `track_liveness` | number |
| `track_loudness` | number |
| `track_mode` | number |
| `track_speechiness` | number |
| `track_tempo` | number |
| `track_time_signature` | number |
| `track_valence` | number |
| `stddev_multiplier` | number |

## Measures

| Name | Type |
|------|------|
| `previous_artist_tracks_on_playlist` | number |
| `playlist_avg_acousticness_measure` | average |
| `playlist_stddev_acousticness_measure` | average |
| `playlist_avg_danceability_measure` | average |
| `playlist_stddev_danceability_measure` | average |
| `playlist_avg_energy_measure` | average |
| `playlist_stddev_energy_measure` | average |
| `playlist_avg_instrumentalness_measure` | average |
| `playlist_stddev_instrumentalness_measure` | average |
| `playlist_avg_liveness_measure` | average |
| `playlist_stddev_liveness_measure` | average |
| `playlist_avg_loudness_measure` | average |
| `playlist_stddev_loudness_measure` | average |
| `playlist_avg_speechiness_measure` | average |
| `playlist_stddev_speechiness_measure` | average |
| `playlist_avg_tempo_measure` | average |
| `playlist_stddev_tempo_measure` | average |
| `playlist_avg_duration_ms_measure` | average |
| `playlist_stddev_duration_ms_measure` | average |
| `playlist_avg_key_measure` | average |
| `playlist_stddev_key_measure` | average |
| `playlist_avg_mode_measure` | average |
| `playlist_stddev_mode_measure` | average |
| `playlist_avg_time_signature_measure` | average |
| `playlist_stddev_time_signature_measure` | average |
| `playlist_avg_valence_measure` | average |
| `playlist_stddev_valence_measure` | average |
| `track_acousticness_in_playlist_range` | string |
| `track_danceability_in_playlist_range` | string |
| `track_energy_in_playlist_range` | string |
| `track_duration_ms_in_playlist_range` | string |
| `track_instrumentalness_in_playlist_range` | string |
| `track_key_in_playlist_range` | string |
| `track_liveness_in_playlist_range` | string |
| `track_loudness_in_playlist_range` | string |
| `track_mode_in_playlist_range` | string |
| `track_speechiness_in_playlist_range` | string |
| `track_tempo_in_playlist_range` | string |
| `track_time_signature_in_playlist_range` | string |
| `track_valence_in_playlist_range` | string |
| `track_acousticness_playlist_percentage_fit` | number |
| `track_danceability_playlist_percentage_fit` | number |
| `track_energy_playlist_percentage_fit` | number |
| `track_duration_ms_playlist_percentage_fit` | number |
| `track_instrumentalness_playlist_percentage_fit` | number |
| `track_key_playlist_percentage_fit` | number |
| `track_liveness_playlist_percentage_fit` | number |
| `track_loudness_playlist_percentage_fit` | number |
| `track_mode_playlist_percentage_fit` | number |
| `track_speechiness_playlist_percentage_fit` | number |
| `track_tempo_playlist_percentage_fit` | number |
| `track_valence_playlist_percentage_fit` | number |
| `track_time_signature_playlist_percentage_fit` | number |
| `overall_percentage_fit` | number |

## Dimension Groups

| Name | Type |
|------|------|
| `recorded_date` | time |

## Derived Table

```sql
sql:
  with artist_name as (
    select
        artist_name as artist_name
        from
        intelligence.dbt_prod.artist_track_metadata a
        where a.isrc = {% parameter input_isrc %
```