Overview: Group Functions

Group functions can be used to take detailed data and summarize it by specific fields (columns). You can apply a group function to one field and use one or two other fields to group the data by. When you create a graph, you will use the group function called Count.

There are six types of group functions (some fields do not use average and sum):

Count Example

Gender grouped by Class Code

Count (and Display) Example

Gender Count (and Display) grouped by Class

Maximum Example

Youngest employee (DOB=Maximum) grouped by Class code and Gender

Minimum Example

Oldest employee (DOB=Minimum) grouped by Class Code and Gender

Average Example

Average Accrued hours grouped by Leave and Class code

Sum Example

Total (Sum) Enrolled grouped by Term and CRN
Concatenate Example

Generally, group functions aren't used with unique fields, for example, date or internal id, because they already have summarized data.