Looker
Looker | bigquery | lookml dimension에 오름차순 내림차순 정렬 설정 방법 | How to sort looker dashboard filters
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..
2023. 6. 19. 14:01