Understanding Sorting in Visualize

Sorting in Visualize works hierarchically. When multiple fields are sorted, each field is sorted within the grouping created by the field before it.

This can make the results look different from a standard data grid where each column may appear to sort independently.

How sorting works in Visualize

Visualize applies sorting based on the order of the fields in the grid.

For example, if the grid contains:

Visualize first sorts the data by Year.

Within each Year, the Month values are then sorted in descending order.

Within each Month, the Day values are sorted in descending order.

In the example below, the grid is configured with three OrderDate fields:

The results show 1996 first. Within 1996, December is displayed before November. Within each month, the Day values are shown in descending order.

OrderDate sorted by Year ascending, followed by Month and Day descending.

When working with sorting in Visualize:

The order of the fields affects the sort hierarchy.
The first sorted field has the highest priority.
Each additional sorted field is applied within the previous field's grouping.
Moving a field to a different position can change the resulting sort order.
The displayed results may look different from sorting in a standard VDM data grid.