Custom sorting

Create a custom sort order that is not governed by the data and does not require a calculation.

Before you begin

If any of the following apply to your data, you might not see all the items in the list you assemble for a custom sort:

  • The data in a visualization might get clipped and can affect your custom sort.
  • There is an applied filter that removes an item in your list.
  • An item in your list no longer exists in the data.
Note: Consider the following implications of custom sorting:
  • If you select too many items in your custom sort, performance can be degraded.
  • When you copy and paste a visualization from a dashboard to a report, custom sorting is not applied to the visualization in the report.

Procedure

  1. Open a visualization.
  2. Click the Fields icon Fields icon.
  3. From the column that you want to custom sort click the menu 3 dots on a column icon.
    You can sort the data in either the x-axis or y-axis, depending on what type of data is in an axis.
  4. Click Sort > Custom.
    Animated gif showing sort icon and selecting custom from the list of sort options
  5. From the Create custom sort window, complete the following steps:
    1. From the Available items list, select items to sort.
    2. From the Custom sort order list, drag items and place them in the order you want.
    3. From the Sort remaining items by list, select how you want the remaining items that are not in your custom sort order list to be displayed.
    4. Click Create.

Results

Your custom sort order is displayed in the visualization.

What to do next

If you want to remove a custom sort, Ctrl+click the axis label, click the sort icon, and select an option other than Custom from the list. For example, select Sort ascending.