Group Options - Group Sorting

The Group Options window Group Sorting tab allows you control how group values are sorted in your dashboard object or drill down.

Follow the steps below to specify how group values are sorted;

First, select which column the group sorting is going to be based on. This may or may not be the same column that the group itself is based on.

clip503

Next, select how you want the sort column value to be applied to sort the group.

clip504

Ascending	Groups will be sorted in ascending order using the value of the column selected.
Descending	Groups will be sorted in descending order using the value of the column selected.
Original Order	Groups will be sorted in the original order the data is returned by the query.
Specified Order	Groups will be sorted based on the order specified below.

If you select specified order, you must define the order by selecting each group value in turn and pressing the add button to add it to the list on the right.

clip505

If you want to change the order of the list, you can do so by dragging the values in the list. Click on the video below for a short demonstration.