# View: dt_playlist_audio_features_upper_x_lower_bounds

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

## Overview

- **File Size:** 32135 bytes
- **Lines of Code:** 894
- **Dimensions:** 43
- **Measures:** 39
- **Dimension Groups:** 1
- **Filters:** 0

## Comments & Notes

- Playlist Dimensions and Measures
- Playlist Range Dimensions & Measures

## Dimensions

| Name | Type |
|------|------|
| `playlist_name` | string |
| `playlist_range_type` | 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 |
| `playlist_stddev_range_acousticenss` | number |
| `playlist_stddev_range_danceability` | number |
| `playlist_stddev_range_duration_ms` | number |
| `playlist_stddev_range_energy` | number |
| `playlist_stddev_range_instrumentalness` | number |
| `playlist_stddev_range_key` | number |
| `playlist_stddev_range_liveness` | number |
| `playlist_stddev_range_loudness` | number |
| `playlist_stddev_range_mode` | number |
| `playlist_stddev_range_speechiness` | number |
| `playlist_stddev_range_tempo` | number |
| `playlist_stddev_range_time_signature` | number |
| `playlist_stddev_range_valence` | 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 |
| `playlist_stddev_range_acousticenss_measure` | average |
| `playlist_stddev_range_danceability_measure` | average |
| `playlist_stddev_range_duration_mss_measure` | average |
| `playlist_stddev_range_energy_measure` | average |
| `playlist_stddev_range_instrumentalness_measure` | average |
| `playlist_stddev_range_key_measure` | average |
| `playlist_stddev_range_liveness_measure` | average |
| `playlist_stddev_range_loudness_measure` | average |
| `playlist_stddev_range_mode_measure` | average |
| `playlist_stddev_range_speechiness_measure` | average |
| `playlist_stddev_range_tempo_measure` | average |
| `playlist_stddev_range_time_signature_measure` | average |
| `playlist_stddev_range_valence_measure` | average |

## Dimension Groups

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

## Derived Table

```sql
sql:
    with playlist_audio_feature_rollup as (
select
    date,
    store_id,
    cm_playlist_id,
    playlist_name,
    playlist_url,
    playlist_uri,
    avg_acousticness,
    stddev_acousticness,
    avg_energy,
    stddev_energy,
    avg_instrumentalness,
    stddev_instrumentalness,
    avg_liveness,
    stddev_liveness,
    avg_loudness,
    stddev_loudness,
    avg_speechiness,
    stddev_speechiness,
    avg_tempo,
    stddev_tempo,
    avg_duration_ms,
    stddev_duration_ms,
    avg_key,
    stddev_key,
    avg_mode,
    stddev_mode,
    avg_time_signature,
    stddev_time_signature,
    avg_danceability,
    stddev_danceability,
    avg_valence,
    stddev_valence


from INTELLIGENCE.DBT_PROD.spotify_editorial_audio_feature_roll_up
where playlist_uri = {% parameter input_playlist_uri %
```