#
# If necessary, uncomment the line below to include explore_source.
# include: "core_accounting.model.lkml"

view: dt_country_gross_revenue_rank{
  derived_table: {
    explore_source: facts_prod_fact_sales {
      column: country_id {}
      column: gross_revenue_usd {}
      column: rolling_date_windows { field: dt_rolling_date_windows_accounting.rolling_date_windows }
      sort: {
        desc: yes
        field: gross_revenue_usd
      }
      derived_column: gross_revenue_rank{
        sql: rank() OVER (order by gross_revenue_usd desc)  ;;
#         sql: rank(${facts_prod_fact_sales.gross_revenue_usd},${facts_prod_fact_sales.gross_revenue_usd}) ;;
#         sql: rank(${TABLE}.gross_revenue_usd, ${TABLE}.gross_revenue_usd ;;
      }
    }
  }
  dimension: country_id {
    primary_key: yes
    type: number
  }
  dimension: gross_revenue_usd {
    type: number
  }
  dimension: rolling_date_windows {

  }
  dimension: gross_revenue_rank {
    view_label: "Xtra Date (Do NOT use)"
    type: number
  }
}