view: cm_raw_data_l_itunes_playlist_history {
 sql_table_name: chartmetric.raw_data.l_itunes_playlist_history ;;

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

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

dimension: itunes_playlist {
  label: "Playlist ID"
  type: number
  sql: ${TABLE}.itunes_playlist ;;
}

dimension_group: start_sys_period {
  type: time
  sql: ${TABLE}.start_sys_period ;;
  timeframes: [
    date
  ]
  label: "Added"
}

dimension_group: end_sys_period {
  type: time
  sql: ${TABLE}.end_sys_period ;;
  timeframes: [
    date
  ]
  label: "Removed"
}

measure: position {
  label: "Past Position"
  type: number
  sql: ${TABLE}.position;;
}

  dimension: storefront {
    label: "Country Code"
    type: string
    sql: ${TABLE}.storefront ;;
  }

}