view: cm_raw_data_l_itunes_playlist_stat {
  sql_table_name: chartmetric.raw_data.l_itunes_playlist_stat ;;

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

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

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

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

  dimension: storefront {
    label: "Storefornt"
    type: string
    hidden: yes
    sql: ${TABLE}.storefront;;
  }


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