view: cm_raw_data_itunes_chart {
  sql_table_name: chartmetric.raw_data.itunes_chart ;;

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

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

  dimension: genre {
    label: "Genre"
    type: string
    hidden: no
    sql: TRIM(${TABLE}.genre) ;;
    view_label: "iTunes"
  }

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

  dimension: rank {
    label: "Chart Rank"
    type: number
    hidden: no
    sql: TRIM(${TABLE}.rank) ;;
    view_label: "iTunes"
  }

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

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

}