Defining custom sort order

You can manually sort column values in a custom order.

The custom sorting that is defined in data modules can be overwritten in dashboards or explorations that are based on this module.

About this task

Custom sorting is automatically generated for month, weekday, and season columns when new schemas and files are loaded. You can modify the automatic sorting by using the manual custom sorting. For example, in the automatically sorted weekday column Sunday is the first day of the week. If you want Monday to be the first day of the week, edit the custom sorting definition. For more information, see Automatic sorting in month, weekday, and season columns.

There is a hard-coded limit of 100 members for the custom sorting editor. If you have more than 100 members you would need to use a sort index with the Sort members by property. For more information, see Displaying relational members

Procedure

  1. Click the vertical arrows icon to open the Custom sort order panel.
  2. In the Custom sort order panel, click the add icon Add button.
  3. In the Custom sort order dialog box, select the column for which you want to specify the custom sort, and type a name for the custom sort.
  4. Move (drag, click, or type) the column members from the data tree to the expression area, and sort them in the desired order. Then click OK.

    In the following example, custom sort order Week start - Monday is defined for the Weekday column.

    Custom sort order - example

    The Week start - Monday definition appears in the Custom sort order panel.

    Custom sort order - example

Results

The new Custom sort order is now available with the Custom sort option for the column property Members display.

Custom sort order - example

The custom sorting is stored as part of the metadata of the uploaded file or schema. As such, it is available to all data modules which consume the file or schema, or in the case of an uploaded file, all dashboards which consume it directly.