Customizing order and top K
Sorting is one of the most common tools for data management. In CDP Data Visualization, you can sort your data in ascending or descending order by implementing the 'ORDER BY' clause on the query. You can also choose to limit the number of records displayed to examine the most significant entries. This can be implemented through the 'LIMIT' clause.
- Click the field you want to modify to open the Field Properties menu.
Click Order and Top K to expand the menu.
Review the following options and configure the sorting and limiting according to your
Additionally, you can also apply Top K/Bottom K to granular dimensions.
- Click REFRESH VISUAL to update your visual.