view: cm_raw_data_spotify_playlist_stat {
  sql_table_name: chartmetric.raw_data.spotify_playlist ;;

  dimension: id {
    type: number
    hidden: yes
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

  measure: followers {
    label: "Followers"
    type: max
    sql: ${TABLE}.followers ;;
    view_label: "Spotify"
  }

  measure: num_tracks {
    label: "Number of Tracks"
    type: max
    sql: ${TABLE}.num_tracks ;;
    view_label: "Spotify"
  }

  measure: listeners {
    label: "Listeners"
    type: max
    sql: ${TABLE}.listeners ;;
    view_label: "Spotify"
  }

  dimension: spotify_playlist {
    type: number
    hidden: yes
    sql: ${TABLE}.spotify_playlist ;;
  }

  dimension_group: Date {
    type: time
    hidden: no
    sql: ${TABLE}.timestp ;;
    timeframes: [
      date,
      week,
      month,
      quarter,
      year
    ]
    label: "Date"
    view_label: "Spotify"
  }

}