1.view sql select문에 순위함수 사용
dense_rank() OVER(ORDER BY *column name* DESC) as order_desc
dense_rank() OVER(ORDER BY *column name* ASC) as order_asc
rank() OVER(ORDER BY *column name* DESC)
rank() OVER(ORDER BY *column name* ASC)
2.dimension에 order_by_field 사용
dimension : order_desc {
type: number
sql: ${TABLE}.order_desc
}
dimension : *column name*{
type: number
sql: ${TABLE}.*column name*
order_by_field: order_desc
}
