Using Group Functions to Summarize Data

  1. On any FAST report, locate the Advanced Options Tab (which may be in the + More Tab)

  2. Under Grid Options, one of the available fields is called Group Functions.

  1. In the Display column, clear the check boxes for the columns you do not want to see. You can also click Select No Columns and then select the check boxes for the columns you want to add back in.

  1. For the field you want to summarize the data for, select one of the following from the Group Function list from the drop-down option. Please note that not every option is available on every column; FAST will provide the best options based on the data type in that field.

  1. Count

  2. Count (and Display)

  3. Maximum

  4. Minimum

  5. Average

  6. Sum

  7. Concatenate

This example uses the Count function for Student ID:

  1. You could also then choose to re-name the column to better align with the dataset. In this example, you could re-name the column from Student ID to Student Count. To re-name the column, Click the Edit Pencil and type in your column name. If you change your mind, click the red X to discard:

  1. Click Execute Report.

The report will display only your selected columns and will now COUNT rather than list the Student ID's. Notice the column title has also been updated for your report only. Also notice that your total record count of 968 has been limited to a total of 5.

  1. You can now do any of the following:

  2. To display the full report and remove your changes: Click Clear Advanced Options and then Execute Report.

  3. To discard your changes: simply leave the page without saving

  4. To save your report options: Click Save as to create a Pinned Report.

  5. To create a graph, click the Graph Icon on the toolbar.

Related topics