Within a datasheet, you can easily calculate and display summary statistics for your data values using grouping. Data grouping sorts data into groups with the same value, whether this be a variable value, a date, time or any other column of data.

By default, the Group By Box appears above the column headers in a new datasheet.

Group data

1. Right-click on a column header and select Group By This Column. The column header will appear in the Group By Box above the datasheet and the data will be sorted into groups of the same data value. These groups are shown in bold.
2. Once the Group By Box is displayed, you can drag and drop a column header into the box to sort the data into groups.
3. Multiple groupings can be made, with data sorted in the order in which you drag or select the column headers. Drag headers about to change the ordering.
4. Right-click in either the column header within the Group By Box or the Group By Box itself and select UnGroup to remove the column header.
5. Groupings can be expanded or collapsed to further interrogate the data. Within the datasheet, click to expand a group and  to collapse a group.
6. To fully expand or collapse the data, right-click in the Group By Box and select Full Expand or Full Collapse.

Sort data by groups

As a default, the count for each group is automatically displayed next to the group name header. This default setting in DataSight allows groups to be quickly sorted according to these values in ascending or descending order.

• Right-click in the column header within the Group By Box and select Sort by Summary.
  • Select Count by Value (ascending or descending). This organises the groupings from groups with the least rows of data to groups with the greatest number of rows of data, in either ascending or descending order.

Use the Group Summary Editor

1. Right-click in the column header within the Group By Box and select Group Summary Editor.
2. The Group Summary Editor Window opens showing items from the datasheet available for selection. By default the Count for values in the group is selected.
3. Click on the name of an appropriate Item you wish to summarise and select from Max, Min, Average or Sum as applicable.

4. Click on the Order tab to order the summaries within the group header.
5. Click OK. The group name header will now display the selected summaries for each group.

Date and Time Group Interval

A Group Interval feature is available for any date or time column header in a datasheet dragged to the Group By box. This setting allows data to be grouped by Day, Month, Year or Smart. See Date and Time Group Interval for more details.

See also:

• Filter Panel
• Organise Data

Date and Time Group Interval

A Group Interval can edit the period of data grouping in a datasheet when a date or time column header is dragged to the Group By box. To edit the date or time group interval of your data:

1. Drag Date or Time column header to the Group By Box.
2. Right-click in the column header within the Group By Box.
3. Select Group Interval in the context menu.
4. Select one of the following intervals:

• Day - Group data for each day together.
• Month - Group data for each month together.
• Year - Group data for each year together.
• Smart - Group data together by matching date portions such as today, yesterday, last week, etc. In this interval, the time portion is ignored; data with matching date intervals but different times will be combined into a single group.

5. Groupings can be expanded or collapsed to further interrogate the data. Within the datasheet, click to expand a group and  to collapse a group.
6. (Optional) You can then use Group Summary Editor to compute Summary Statistics for the data.
7. Right-click in either the column header within the Group By Box or the Group By Box itself and select UnGroup to remove the column header.