# View: dt_track_playlist_audio_feature_comparison_2stddev

**View Name:** dt_track_playlist_audio_feature_comparison_2stddev
**Table Source:** `Derived from: Dbt_Prod.Spotify_Editorial_Audio_Feature_Roll_Up, Dbt_Prod.Spotify_Track_Audio_Features, Intelligence.Dbt_Prod`
**File Path:** `dt_track_playlist_audio_feature_comparison_2stddev.view.lkml`

## Overview

- **File Size:** 47032 bytes
- **Lines of Code:** 1012
- **Dimensions:** 47
- **Measures:** 53
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

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

## Dimensions

| Name | Type |
|------|------|
| `storeid` | number |
| `cm_playlist_id` | number |
| `playlist_name` | string |
| `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 |
|------|------|
| `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 |

## SQL Comments

- iff(track_acousticness < (playlist_avg_acousticness + playlist_stddev_acousticness) AND track_acousticness > (playlist_avg_acousticness - playlist_stddev_acousticness), 'yes', 'no') as track_acousticness_in_playlist_acousticness_range

## Derived Table

```sql
sql:



    select
        paf.date as recorded_date,
        paf.store_id as store_id,
        paf.cm_playlist_id as cm_playlist_id,
        paf.playlist_name as playlist_name,
        paf.playlist_url as playlist_url,
        paf.playlist_uri as playlist_uri,
        paf.avg_acousticness as playlist_avg_acousticness,
        paf.stddev_acousticness as playlist_stddev_acousticness,
        paf.avg_danceability as playlist_avg_danceability,
        paf.stddev_danceability as playlist_stddev_danceability,
        paf.avg_energy as playlist_avg_energy,
        paf.stddev_energy as playlist_stddev_energy,
        paf.avg_instrumentalness as playlist_avg_instrumentalness,
        paf.stddev_instrumentalness as playlist_stddev_instrumentalness,
        paf.avg_liveness as playlist_avg_liveness,
        paf.stddev_liveness as playlist_stddev_liveness,
        paf.avg_loudness as playlist_avg_loudness,
        paf.stddev_loudness as playlist_stddev_loudness,
        paf.avg_speechiness as playlist_avg_speechiness,
        paf.stddev_speechiness as playlist_stddev_speechiness,
        paf.avg_tempo as playlist_avg_tempo,
        paf.stddev_tempo as playlist_stddev_tempo,
        paf.avg_duration_ms as playlist_avg_duration_ms,
        paf.stddev_duration_ms as playlist_stddev_duration_ms,
        paf.avg_key as playlist_avg_key,
        paf.stddev_key as playlist_stddev_key,
        paf.avg_mode as playlist_avg_mode,
        paf.stddev_mode as playlist_stddev_mode,
        paf.avg_time_signature as playlist_avg_time_signature,
        paf.stddev_time_signature as playlist_stddev_time_signature,
        paf.avg_valence as playlist_avg_valence,
        paf.stddev_valence as playlist_stddev_valence,

      af.isrc as track_isrc,
      af.uri as track_uri,
      af.acousticness as track_acousticness,
      af.danceability as track_danceability,
      af.duration_ms as track_duration_ms,
      af.energy as track_energy,
      af.instrumentalness as track_instrumentalness,
      af.key as track_key,
      af.liveness as track_liveness,
      af.loudness as track_loudness,
      af.mode as track_mode,
      af.speechiness as track_speechiness,
      af.tempo as track_tempo,
      af.time_signature as track_time_signature,
      af.valence as track_valence

      --iff(track_acousticness < (playlist_avg_acousticness + playlist_stddev_acousticness) AND track_acousticness > (playlist_avg_acousticness - playlist_stddev_acousticness), 'yes', 'no') as track_acousticness_in_playlist_acousticness_range

      from INTELLIGENCE.DBT_PROD.spotify_editorial_audio_feature_roll_up paf
      cross join INTELLIGENCE.DBT_PROD.SPOTIFY_TRACK_AUDIO_FEATURES af

      where
      paf.playlist_uri = {% parameter input_playlist_uri %
```