view: facts_prod_chartable_podcast_ranking_peaks {
  sql_table_name: facts.prod.chartable_podcast_ranking_peaks ;;

  dimension: peak_date {
    label: "Peak Date"
    type: date
    sql: ${TABLE}.peak_date ;;
  }

  dimension: store {
    label: "Store Name"
    type: string
    sql: ${TABLE}.store ;;
    hidden: yes
  }

  dimension: genre {
    label: "Genre"
    type: string
    sql: ${TABLE}.genre ;;
    hidden: yes
  }

  dimension: country {
    label: "Country Code"
    type: string
    sql: ${TABLE}.country ;;
    hidden: yes
  }

  dimension: peak_ranking {
    label: "Peak Ranking"
    type: number
    sql: ${TABLE}.peak_ranking ;;
  }

  dimension: time_on_chart {
    label: "Time on Chart"
    type: number
    sql: ${TABLE}.time_on_chart ;;
  }

  dimension: entrance_date {
    label: "Peak Entrance Date"
    type: date
    sql: ${TABLE}.entrance_date ;;
  }

  dimension: exit_date {
    label: "Peak Exit Date"
    type: date
    sql: ${TABLE}.exit_date ;;
  }

  dimension: store_id {
    label: "Store ID"
    type: string
    sql: ${TABLE}.store_id ;;
    hidden: yes
  }

}