Grouping, sorting, and selecting columns

After a query has been created it is time to sort and group the result. This is very important in making the mined data set from the query more understandable.

A report result can be sorted by first one and the and a second column, ascending or descending.

Grouping a report is done first with a main and then a sub group. The following column types are applicable for grouping: Text, Multi-line text, Drop list single choice, Drop list multiple choice, and People.

You can also select which columns that are going to be visible and decide in which order they should appear(Left - Right).

This image depicts the column options for a report created in the Planning section of Hansoft.

The "Assigned to" column will appear at the far left followed by "Status".