view: dt_project_moments_cluster_groups_audio_upper_x_lower_bounds_som_logic {
  derived_table: {
    sql:
    with cluster_groups as (
select
*,
case
    when som_cluster = 'SOM Cluster 1' then 'A'
    when som_cluster = 'SOM Cluster 2' then 'B'
    when som_cluster = 'SOM Cluster 3' then 'C'
    when som_cluster = 'SOM Cluster 4' then 'D'
    when som_cluster = 'SOM Cluster 5' then 'E'
    when som_cluster = 'SOM Cluster 6' then 'F'
    when som_cluster = 'SOM Cluster 7' then 'G'
    when som_cluster = 'SOM Cluster 8' then 'H'
else null
end as Trending_Group
from DEV_ENGINEERING.EIMPARA.MOMENTS_CLUSTERS_TABLE_APR_SEPT_22_POSITIVE_SIGN_V4

union all

select
*,
case
    when som_cluster = 'SOM Cluster 2' then 'I'
    when som_cluster = 'SOM Cluster 3' then 'J'
    when som_cluster = 'SOM Cluster 4' then 'K'
    when som_cluster = 'SOM Cluster 5' then 'L'
    when som_cluster = 'SOM Cluster 6' then 'M'
    when som_cluster = 'SOM Cluster 7' then 'N'
    when som_cluster = 'SOM Cluster 8' then 'O'
    when som_cluster = 'SOM Cluster 9' then 'P'
    when som_cluster = 'SOM Cluster 10' then 'Q'
    when som_cluster = 'SOM Cluster 11' then 'R'
    when som_cluster = 'SOM Cluster 12' then 'S'
    when som_cluster = 'SOM Cluster 13' then 'T'
    when som_cluster = 'SOM Cluster 14' then 'U'
    when som_cluster = 'SOM Cluster 15' then 'V'
    when som_cluster = 'SOM Cluster 16' then 'W'

else null
end as Trending_Group
from DEV_ENGINEERING.EIMPARA.MOMENTS_CLUSTERS_TABLE_APR_SEPT_22_NEGATIVE_SIGN_V4
      ),

      audio_feature_cluster_profile as (
      select
      cg.trending_group as trending_group,
      avg(af.ACOUSTICNESS) as avg_acousticness,
      stddev(af.ACOUSTICNESS) as stddev_acousticness,
      avg(af.ENERGY) as avg_energy,
      stddev(af.ENERGY) as stddev_energy,
      avg(af.INSTRUMENTALNESS) as avg_instrumentalness,
      stddev(af.INSTRUMENTALNESS) as stddev_instrumentalness,
      avg(af.LIVENESS) as avg_liveness,
      stddev(af.LIVENESS) as stddev_liveness,
      avg(af.LOUDNESS) as avg_loudness,
      stddev(af.LOUDNESS) as stddev_loudness,
      avg(af.SPEECHINESS) as avg_speechiness,
      stddev(af.SPEECHINESS) as stddev_speechiness,
      avg(af.TEMPO) as avg_tempo,
      stddev(af.TEMPO) as stddev_tempo,
      avg(af.duration_ms) as avg_duration_ms,
      stddev(af.duration_ms) as stddev_duration_ms,
      avg(af.key) as avg_key,
      stddev(af.key) as stddev_key,
      avg(af.mode) as avg_mode,
      stddev(af.mode) as stddev_mode,
      avg(af.time_signature) as avg_time_signature,
      stddev(af.time_signature) as stddev_time_signature,
      avg(af.danceability) as avg_danceability,
      stddev(af.danceability) as stddev_danceability,
      avg(af.valence) as avg_valence,
      stddev(af.valence) as stddev_valence


      from cluster_groups cg
      Left Join intelligence.dbt_prod.spotify_track_audio_features af on af.isrc = cg.isrc


      group by 1
      order by 6),


      cluster_group_upper as (
      select
      'Cluster Group Upper' as cluster_group_range_type,
      trending_group,
      avg(avg_acousticness) as cluster_group_avg_acousticness,
      avg(stddev_acousticness) as cluster_group_stddev_acousticness,
      avg(avg_danceability) as cluster_group_avg_danceability,
      avg(stddev_danceability) as cluster_group_stddev_danceability,
      avg(avg_energy) as cluster_group_avg_energy,
      avg(stddev_energy) as cluster_group_stddev_energy,
      avg(avg_instrumentalness) as cluster_group_avg_instrumentalness,
      avg(stddev_instrumentalness) as cluster_group_stddev_instrumentalness,
      avg(avg_liveness) as cluster_group_avg_liveness,
      avg(stddev_liveness) as cluster_group_stddev_liveness,
      avg(avg_loudness) as cluster_group_avg_loudness,
      avg(stddev_loudness) as cluster_group_stddev_loudness,
      avg(avg_speechiness) as cluster_group_avg_speechiness,
      avg(stddev_speechiness) as cluster_group_stddev_speechiness,
      avg(avg_tempo) as cluster_group_avg_tempo,
      avg(stddev_tempo) as cluster_group_stddev_tempo,
      avg(avg_duration_ms) as cluster_group_avg_duration_ms,
      avg(stddev_duration_ms) as cluster_group_stddev_duration_ms,
      avg(avg_key) as cluster_group_avg_key,
      avg(stddev_key) as cluster_group_stddev_key,
      avg(avg_mode) as cluster_group_avg_mode,
      avg(stddev_mode) as cluster_group_stddev_mode,
      avg(avg_time_signature) as cluster_group_avg_time_signature,
      avg(stddev_time_signature) as cluster_group_stddev_time_signature,
      avg(avg_valence) as cluster_group_avg_valence,
      avg(stddev_valence) as cluster_group_stddev_valence,
      iff(((cluster_group_avg_acousticness + cluster_group_stddev_acousticness) > 1), 1, (cluster_group_avg_acousticness + cluster_group_stddev_acousticness))as cluster_group_stddev_range_acousticenss,
      iff(((cluster_group_avg_danceability + cluster_group_stddev_danceability) > 1), 1, (cluster_group_avg_danceability + cluster_group_stddev_danceability))as cluster_group_stddev_range_danceability,
      (cluster_group_avg_duration_ms + cluster_group_stddev_duration_ms)as cluster_group_stddev_range_duration_ms,
      iff(((cluster_group_avg_energy + cluster_group_stddev_energy) > 1), 1, (cluster_group_avg_energy + cluster_group_stddev_energy))as cluster_group_stddev_range_energy,
      iff(((cluster_group_avg_instrumentalness + cluster_group_stddev_instrumentalness) > 1), 1, (cluster_group_avg_instrumentalness + cluster_group_stddev_instrumentalness))as cluster_group_stddev_range_instrumentalness,
      (cluster_group_avg_key + cluster_group_stddev_key)as cluster_group_stddev_range_key,
      iff(((cluster_group_avg_liveness + cluster_group_stddev_liveness) > 1), 1, (cluster_group_avg_liveness + cluster_group_stddev_liveness))as cluster_group_stddev_range_liveness,
      iff(((cluster_group_avg_loudness + cluster_group_stddev_loudness) > 1), 1, (cluster_group_avg_loudness + cluster_group_stddev_loudness))as cluster_group_stddev_range_loudness,
      iff(((cluster_group_avg_mode + cluster_group_stddev_mode) > 1), 1, (cluster_group_avg_mode + cluster_group_stddev_mode))as cluster_group_stddev_range_mode,
      iff(((cluster_group_avg_speechiness + cluster_group_stddev_speechiness) > 1), 1, (cluster_group_avg_speechiness + cluster_group_stddev_speechiness))as cluster_group_stddev_range_speechiness,
      (cluster_group_avg_tempo + cluster_group_stddev_tempo)as cluster_group_stddev_range_tempo,
      (cluster_group_avg_time_signature + cluster_group_stddev_time_signature)as cluster_group_stddev_range_time_signature,
      iff(((cluster_group_avg_valence + cluster_group_stddev_valence) > 1), 1, (cluster_group_avg_valence + cluster_group_stddev_valence))as cluster_group_stddev_range_valence
      from audio_feature_cluster_profile
      group by 1,2
      ),

      cluster_group_lower as (
      select
      'Cluster Group Lower' as cluster_group_range_type,
      trending_group,
      avg(avg_acousticness) as cluster_group_avg_acousticness,
      avg(stddev_acousticness) as cluster_group_stddev_acousticness,
      avg(avg_danceability) as cluster_group_avg_danceability,
      avg(stddev_danceability) as cluster_group_stddev_danceability,
      avg(avg_energy) as cluster_group_avg_energy,
      avg(stddev_energy) as cluster_group_stddev_energy,
      avg(avg_instrumentalness) as cluster_group_avg_instrumentalness,
      avg(stddev_instrumentalness) as cluster_group_stddev_instrumentalness,
      avg(avg_liveness) as cluster_group_avg_liveness,
      avg(stddev_liveness) as cluster_group_stddev_liveness,
      avg(avg_loudness) as cluster_group_avg_loudness,
      avg(stddev_loudness) as cluster_group_stddev_loudness,
      avg(avg_speechiness) as cluster_group_avg_speechiness,
      avg(stddev_speechiness) as cluster_group_stddev_speechiness,
      avg(avg_tempo) as cluster_group_avg_tempo,
      avg(stddev_tempo) as cluster_group_stddev_tempo,
      avg(avg_duration_ms) as cluster_group_avg_duration_ms,
      avg(stddev_duration_ms) as cluster_group_stddev_duration_ms,
      avg(avg_key) as cluster_group_avg_key,
      avg(stddev_key) as cluster_group_stddev_key,
      avg(avg_mode) as cluster_group_avg_mode,
      avg(stddev_mode) as cluster_group_stddev_mode,
      avg(avg_time_signature) as cluster_group_avg_time_signature,
      avg(stddev_time_signature) as cluster_group_stddev_time_signature,
      avg(avg_valence) as cluster_group_avg_valence,
      avg(stddev_valence) as cluster_group_stddev_valence,
      iff(((cluster_group_avg_acousticness - cluster_group_stddev_acousticness) < 0), 0, (cluster_group_avg_acousticness - cluster_group_stddev_acousticness))as cluster_group_stddev_range_acousticenss,
      iff(((cluster_group_avg_danceability - cluster_group_stddev_danceability) < 0), 0, (cluster_group_avg_danceability - cluster_group_stddev_danceability))as cluster_group_stddev_range_danceability,
      iff(((cluster_group_avg_duration_ms - cluster_group_stddev_duration_ms) < 0), 0, (cluster_group_avg_duration_ms - cluster_group_stddev_duration_ms))as cluster_group_stddev_range_duration_ms,
      iff(((cluster_group_avg_energy - cluster_group_stddev_energy) < 0), 0, (cluster_group_avg_energy - cluster_group_stddev_energy))as cluster_group_stddev_range_energy,
      iff(((cluster_group_avg_instrumentalness - cluster_group_stddev_instrumentalness) < 0), 0, (cluster_group_avg_instrumentalness - cluster_group_stddev_instrumentalness))as cluster_group_stddev_range_instrumentalness,
      (cluster_group_avg_key - cluster_group_stddev_key)as cluster_group_stddev_range_key,
      iff(((cluster_group_avg_liveness - cluster_group_stddev_liveness) < 0), 0, (cluster_group_avg_liveness - cluster_group_stddev_liveness))as cluster_group_stddev_range_liveness,
      iff(((cluster_group_avg_loudness - cluster_group_stddev_loudness) < 0), 0, (cluster_group_avg_loudness - cluster_group_stddev_loudness))as cluster_group_stddev_range_loudness,
      iff(((cluster_group_avg_mode - cluster_group_stddev_mode) < 0), 0, (cluster_group_avg_mode - cluster_group_stddev_mode))as cluster_group_stddev_range_mode,
      iff(((cluster_group_avg_speechiness - cluster_group_stddev_speechiness) < 0), 0, (cluster_group_avg_speechiness - cluster_group_stddev_speechiness))as cluster_group_stddev_range_speechiness,
      iff(((cluster_group_avg_tempo - cluster_group_stddev_tempo) < 0), 0, (cluster_group_avg_tempo - cluster_group_stddev_tempo))as cluster_group_stddev_range_tempo,
      iff(((cluster_group_avg_time_signature - cluster_group_stddev_time_signature) < 0), 0, (cluster_group_avg_time_signature - cluster_group_stddev_time_signature))as cluster_group_stddev_range_time_signature,
      iff(((cluster_group_avg_valence - cluster_group_stddev_valence) < 0), 0, (cluster_group_avg_valence - cluster_group_stddev_valence))as cluster_group_stddev_range_valence
      from audio_feature_cluster_profile
      group by 1,2
      )

      select
      *
      from cluster_group_upper
      union
      select
      *
      from cluster_group_lower
      ;;
  }

  dimension: cluster_group {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Cluster Group"
    type: string
    sql: ${TABLE}.trending_group ;;
  }


  dimension: cluster_group_range_type {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Cluster Group Range Type"
    type: string
    sql: ${TABLE}.cluster_group_range_type ;;
  }



  dimension: cluster_group_avg_acousticness {
    view_label: "Audio Features - cluster_group"
    label: "Avg Acousticness"
    type: number
    sql: ${TABLE}.cluster_group_avg_acousticness ;;
  }

  measure: cluster_group_avg_acousticness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Acousticness"
    type: average
    sql: ${TABLE}.cluster_group_avg_acousticness ;;
  }

  dimension: cluster_group_stddev_acousticness {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Acousticness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_acousticness ;;
  }

  measure: cluster_group_stddev_acousticness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Acousticness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_acousticness ;;
  }

  dimension: cluster_group_avg_danceability {
    view_label: "Audio Features - cluster_group"
    label: "Avg Danceability"
    type: number
    sql: ${TABLE}.cluster_group_avg_danceability ;;
  }

  measure: cluster_group_avg_danceability_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Danceability"
    type: average
    sql: ${TABLE}.cluster_group_avg_danceability ;;
  }

  dimension: cluster_group_stddev_danceability {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Danceability"
    type: number
    sql: ${TABLE}.cluster_group_stddev_danceability ;;
  }

  measure: cluster_group_stddev_danceability_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Danceability"
    type: average
    sql: ${TABLE}.cluster_group_stddev_danceability ;;
  }

  dimension: cluster_group_avg_energy {
    view_label: "Audio Features - cluster_group"
    label: "Avg Energy"
    type: number
    sql: ${TABLE}.cluster_group_avg_energy ;;
  }

  measure: cluster_group_avg_energy_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Energy"
    type: average
    sql: ${TABLE}.cluster_group_avg_energy ;;
  }

  dimension: cluster_group_stddev_energy {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Energy"
    type: number
    sql: ${TABLE}.cluster_group_stddev_energy ;;
  }

  measure: cluster_group_stddev_energy_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Energy"
    type: average
    sql: ${TABLE}.cluster_group_stddev_energy ;;
  }

  dimension: cluster_group_avg_instrumentalness {
    view_label: "Audio Features - cluster_group"
    label: "Avg Instrumentalness"
    type: number
    sql: ${TABLE}.cluster_group_avg_instrumentalness ;;
  }

  measure: cluster_group_avg_instrumentalness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Instrumentalness"
    type: average
    sql: ${TABLE}.cluster_group_avg_instrumentalness ;;
  }

  dimension: cluster_group_stddev_instrumentalness {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Instrumentalness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_instrumentalness ;;
  }

  measure: cluster_group_stddev_instrumentalness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Instrumentalness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_instrumentalness ;;
  }

  dimension: cluster_group_avg_liveness {
    view_label: "Audio Features - cluster_group"
    label: "Avg Liveness"
    type: number
    sql: ${TABLE}.cluster_group_avg_liveness ;;
  }

  measure: cluster_group_avg_liveness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Liveness"
    type: average
    sql: ${TABLE}.cluster_group_avg_liveness ;;
  }

  dimension: cluster_group_stddev_liveness {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Liveness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_liveness ;;
  }

  measure: cluster_group_stddev_liveness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Liveness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_liveness ;;
  }

  dimension: cluster_group_avg_loudness {
    view_label: "Audio Features - cluster_group"
    label: "Avg Loudness"
    type: number
    sql: ${TABLE}.cluster_group_avg_loudness ;;
  }

  measure: cluster_group_avg_loudness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Loudness"
    type: average
    sql: ${TABLE}.cluster_group_avg_loudness ;;
  }

  dimension: cluster_group_stddev_loudness {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Loudness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_loudness ;;
  }

  measure: cluster_group_stddev_loudness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Loudness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_loudness ;;
  }

  dimension: cluster_group_avg_speechiness {
    view_label: "Audio Features - cluster_group"
    label: "Avg Speechiness"
    type: number
    sql: ${TABLE}.cluster_group_avg_speechiness ;;
  }

  measure: cluster_group_avg_speechiness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Speechiness"
    type: average
    sql: ${TABLE}.cluster_group_avg_speechiness ;;
  }

  dimension: cluster_group_stddev_speechiness {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Speechiness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_speechiness ;;
  }

  measure: cluster_group_stddev_speechiness_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Speechiness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_speechiness ;;
  }

  dimension: cluster_group_avg_tempo {
    view_label: "Audio Features - cluster_group"
    label: "Avg Tempo"
    type: number
    sql: ${TABLE}.cluster_group_avg_tempo ;;
  }

  measure: cluster_group_avg_tempo_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Tempo"
    type: average
    sql: ${TABLE}.cluster_group_avg_tempo ;;
  }

  dimension: cluster_group_stddev_tempo {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Tempo"
    type: number
    sql: ${TABLE}.cluster_group_stddev_tempo ;;
  }

  measure: cluster_group_stddev_tempo_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Tempo"
    type: average
    sql: ${TABLE}.cluster_group_stddev_tempo ;;
  }

  dimension: cluster_group_avg_duration_ms {
    view_label: "Audio Features - cluster_group"
    label: "Avg Duration (ms)"
    type: number
    sql: ${TABLE}.cluster_group_avg_duration_ms ;;
  }

  measure: cluster_group_avg_duration_ms_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Duration (ms)"
    type: average
    sql: ${TABLE}.cluster_group_avg_duration_ms ;;
  }

  dimension: cluster_group_stddev_duration_ms {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Duration (ms)"
    type: number
    sql: ${TABLE}.cluster_group_stddev_duration_ms ;;
  }

  measure: cluster_group_stddev_duration_ms_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Duration (ms)"
    type: average
    sql: ${TABLE}.cluster_group_stddev_duration_ms ;;
  }

  dimension: cluster_group_avg_key {
    view_label: "Audio Features - cluster_group"
    label: "Avg Key"
    type: number
    sql: ${TABLE}.cluster_group_avg_key ;;
  }

  measure: cluster_group_avg_key_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Key"
    type: average
    sql: ${TABLE}.cluster_group_avg_key ;;
  }

  dimension: cluster_group_stddev_key {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Key"
    type: number
    sql: ${TABLE}.cluster_group_stddev_key ;;
  }

  measure: cluster_group_stddev_key_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Key"
    type: average
    sql: ${TABLE}.cluster_group_stddev_key ;;
  }

  dimension: cluster_group_avg_mode {
    view_label: "Audio Features - cluster_group"
    label: "Avg Mode"
    type: number
    sql: ${TABLE}.cluster_group_avg_mode ;;
  }

  measure: cluster_group_avg_mode_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Mode"
    type: average
    sql: ${TABLE}.cluster_group_avg_mode ;;
  }

  dimension: cluster_group_stddev_mode {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Mode"
    type: number
    sql: ${TABLE}.cluster_group_stddev_mode ;;
  }

  measure: cluster_group_stddev_mode_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Mode"
    type: average
    sql: ${TABLE}.cluster_group_stddev_mode ;;
  }

  dimension: cluster_group_avg_time_signature {
    view_label: "Audio Features - cluster_group"
    label: "Avg Time Signature"
    type: number
    sql: ${TABLE}.cluster_group_avg_time_signature ;;
  }

  measure: cluster_group_avg_time_signature_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Time Signature"
    type: average
    sql: ${TABLE}.cluster_group_avg_time_signature ;;
  }

  dimension: cluster_group_stddev_time_signature {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Time Signature"
    type: number
    sql: ${TABLE}.cluster_group_stddev_time_signature ;;
  }

  measure: cluster_group_stddev_time_signature_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Time Signature"
    type: average
    sql: ${TABLE}.cluster_group_stddev_time_signature ;;
  }

  dimension: cluster_group_avg_valence {
    view_label: "Audio Features - cluster_group"
    label: "Avg Valence"
    type: number
    sql: ${TABLE}.cluster_group_avg_valence ;;
  }

  measure: cluster_group_avg_valence_measure {
    view_label: "Audio Features - cluster_group"
    label: "Avg Valence"
    type: average
    sql: ${TABLE}.cluster_group_avg_valence ;;
  }

  dimension: cluster_group_stddev_valence {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Valence"
    type: number
    sql: ${TABLE}.cluster_group_stddev_valence ;;
  }

  measure: cluster_group_stddev_valence_measure {
    view_label: "Audio Features - cluster_group"
    label: "Stddev Valence"
    type: average
    sql: ${TABLE}.cluster_group_stddev_valence ;;
  }

  # cluster_group Range Dimensions & Measures
  dimension: cluster_group_stddev_range_acousticenss {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Acousticness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_acousticenss ;;
  }

  measure: cluster_group_stddev_range_acousticenss_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Acousticness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_acousticenss ;;
  }

  dimension: cluster_group_stddev_range_danceability {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Danceability"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_danceability ;;
  }

  measure: cluster_group_stddev_range_danceability_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Danceability"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_danceability ;;
  }
  dimension: cluster_group_stddev_range_duration_ms {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Duration (ms)"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_duration_ms ;;
  }

  measure: cluster_group_stddev_range_duration_mss_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Duration (ms)"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_duration_ms ;;
  }
  dimension: cluster_group_stddev_range_energy {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Energy"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_energy ;;
  }

  measure: cluster_group_stddev_range_energy_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Energy"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_energy ;;
  }

  dimension: cluster_group_stddev_range_instrumentalness {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Instrumentalness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_instrumentalness ;;
  }

  measure: cluster_group_stddev_range_instrumentalness_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Instrumentalness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_instrumentalness ;;
  }

  dimension: cluster_group_stddev_range_key {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Key"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_key ;;
  }

  measure: cluster_group_stddev_range_key_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Key"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_key ;;
  }

  dimension: cluster_group_stddev_range_liveness {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Liveness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_liveness ;;
  }

  measure: cluster_group_stddev_range_liveness_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Liveness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_liveness ;;
  }

  dimension: cluster_group_stddev_range_loudness {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Loudness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_loudness ;;
  }

  measure: cluster_group_stddev_range_loudness_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Loudness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_loudness ;;
  }

  dimension: cluster_group_stddev_range_mode {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Mode"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_mode ;;
  }

  measure: cluster_group_stddev_range_mode_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Mode"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_mode ;;
  }

  dimension: cluster_group_stddev_range_speechiness {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Speechiness"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_speechiness ;;
  }

  measure: cluster_group_stddev_range_speechiness_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Speechiness"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_speechiness;;
  }

  dimension: cluster_group_stddev_range_tempo {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Tempo"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_tempo ;;
  }

  measure: cluster_group_stddev_range_tempo_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Tempo"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_tempo ;;
  }

  dimension: cluster_group_stddev_range_time_signature {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Time Signature"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_time_signature ;;
  }

  measure: cluster_group_stddev_range_time_signature_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Time Signature"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_time_signature ;;
  }

  dimension: cluster_group_stddev_range_valence {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Valence"
    type: number
    sql: ${TABLE}.cluster_group_stddev_range_valence ;;
  }

  measure: cluster_group_stddev_range_valence_measure {
    view_label: "Audio Features - Cluster Group Bounds"
    label: "Stddev Range Valence"
    type: average
    sql: ${TABLE}.cluster_group_stddev_range_valence ;;
  }


}