Customizing order and top K

CDP Data Visualization enables you to adjust the sort order of values by implementing ORDER BY clause on the query. You may also choose to limit the number of records displayed to examine the most significant entries, implemented through LIMIT clause.

  1. Click the field you plan to modify to open the Field Properties menu.
  2. Under Field Properties, click to expand the Order and Top K menu.
  3. From the Order and Top K menu, select one of the options.
    • Descending sorts [field] in descending order.

    • Ascending sorts [field] in ascending order.

    • Top K displays only the number of values you specify, starting from the top of the specified sort.

    • Bottom K displays only the number of values you specify, starting from the bottom of the specified sort.

    Valid choices are: [ Descending | Ascending | None ] AND [ Top K | Bottom K | None ]

    A checkmark precedes the selected option.

  4. Click Refresh Visual to see the changes.