Arcadia 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.

To set order, follow these steps.

  1. When creating or editing a visual, determine for which field variable you must change sort order.

    The shelves that support sort order depend on the visual type, and are typically available for X and Y axes, Measures, Dimensions, Colors, and Tooltips.

  2. Click the icon to the right of the variable.

  3. In the dropdown, click Order.
  4. From the Order menu, select one of the following options:

    • Descending sorts [field] in descending order.
    • Ascending sorts [field] in ascending order.
    • Top K displays only the number of values you specify in the Enter a number modal window that appears after you make this choice, K.

      Note that this setting overrides the Limit shelf setting. So, if the value of Limit is 100 and Top K is set to 50, the query returns 50 rows.

    • Remove Sort Order removes all of the above.

  5. Click Refresh Visual.