view: cm_raw_data_deezer_daily_top_chart {
  sql_table_name: chartmetric.raw_data.deezer_chart ;;

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

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

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

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

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

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

}