view: dt_genre_benchmarking_median {
  sql_table_name:intelligence.prod.median_units_by_genre_store_country_daily ;;

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

  dimension: identifier {
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: store_id{
    type: string
    sql: ${TABLE}.store_id ;;
  }

  dimension: country_id{
    type: string
    sql: ${TABLE}.country_id ;;
  }

  measure: units {
    type: sum
    label: "Median Units"
    sql: ${TABLE}.median_units;;
  }

}