view: cm_raw_data_spotify_chart {
  sql_table_name: chartmetric.raw_data.spotify_chart ;;

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

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

  dimension: rank {
    label: "Chart Rank"
    type: number
    hidden: no
    sql: ${TABLE}.rank ;;
    view_label: "Spotify"
  }

  measure: plays {
    label: "Track Plays"
    type: sum
    hidden: no
    sql: ${TABLE}.plays ;;
    view_label: "Spotify"
  }

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

  dimension: timestp {
    type: date
    hidden: yes
    sql: ${TABLE}.timestp ;;
  }

  dimension: country {
    label: "Chart Country"
    type: string
    hidden: no
    sql: TRIM(${TABLE}.country) ;;
    view_label: "Spotify"
  }

  dimension: chart_type {
    label: "Chart Type"
    type: string
    hidden: no
    sql: ${TABLE}.Chart_type ;;
    view_label: "Spotify"
  }

  dimension: duration {
    label: "Track Duration"
    type: string
    hidden: yes
    sql: ${TABLE}.duration ;;
    view_label: "Spotify"
  }

}