view: facts_prod_chartable_podcast_rankings {
  sql_table_name: facts.prod.chartable_podcast_rankings ;;

  dimension: report_date {
    label: "Chart Report Date"
    type: date
    sql: ${TABLE}.report_date ;;
    view_label: "Chart"
  }

  dimension: podcast_title {
    label: "Podcast Title"
    type: string
    sql: ${TABLE}.podcast_title ;;
    view_label: "Podcast"
  }

  dimension: network_title {
    label: "Network Title"
    type: string
    sql: ${TABLE}.network_title ;;
    view_label: "Podcast"
  }

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

  dimension: genre {
    label: "Genre"
    type: string
    sql: ${TABLE}.genre ;;
    view_label: "Chart"
  }

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

  dimension: ranking {
    label: "Ranking"
    type: number
    sql: ${TABLE}.ranking ;;
    view_label: "Chart"
  }

  dimension:rating_count {
    label: "Ratings"
    type: number
    sql: ${TABLE}.rating_count ;;
    view_label: "Podcast"
  }

  dimension: review_count {
    label: "Reviews"
    type: number
    sql: ${TABLE}.review_count ;;
    view_label: "Podcast"
  }

  dimension: ranking_change {
    label: "Ranking Change"
    type: number
    sql: ${TABLE}.ranking_change ;;
    view_label: "Chart"
  }

  dimension: average_rating {
    label: "Average Rating"
    type: number
    sql: ${TABLE}.average_rating ;;
    view_label: "Podcast"
  }

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

}