view: cm_raw_data_l_deezer_playlist_stat {
  sql_table_name: chartmetric.raw_data.l_deezer_playlist_stat ;;

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

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

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

  measure: position {
    label: "Historic Track Positions"
    type: min
    sql: ${TABLE}.position;;
  }

  dimension_group: Date {
    type: time
    hidden: no
    sql: ${TABLE}.timestp ;;
    timeframes: [
      date
    ]
    label: "Track Position"
  }
}