Open topic with navigation

Group

Grouping brings together related report data into logical groups based on particular fields. The data can be arranged in ascending or descending order, and can display the selected field value, or a summary value. You can create different groups to display information in different ways.

To configure report groups in Smart Report, create a new report, enable the edit mode and click the icon. To edit the group for the Classic report, click the group tab to open the Select Grouping menu.

Note: A report that has a group defined can only display up to 100,000 lines.

Example 1: Let's say you create a group that displays "Total Sales" in descending order (Z to A). The total sales of "East Region" is 1000 units, and total sales of "West Region" is 1900 units. In the report, the "West Region" group detail will appear before "East Region" group details.

Example 2: If the report uses a query that includes a Date field, you can group results by date. You could add additional statements to group by “User Name”, “Source Address”, “Destination Address”, and so forth, depending on what other fields are available in the report query.

Note: Selecting set Max. Rows under Select Filter Criteria (as described in Filter) and also specifying grouping may produce a different result than if you just specified Max. Rows without grouping.

See the table Run-Time Filters, Criteria, and Parameters for more information about report settings.

To define a group:

  1. From the Group By menu, select available options from the following menus to specify what event information should be grouped, in what order, and under what conditions.

    The Group By field is the primary field in the data group, organized by the ranking field, in ascending or descending order.

    Select Group By Fields

    Option

    Description

    Field

    Select an option from the menu to make it the primary field in the report group. The Field menu is populated with event data fields specified in the base query.

    • To add another grouping field, click (Add Field). In Smart report, just select the field from the drop-down list.
    • To remove a group-by field, click (Delete Field).

    Order

    Select in what order you want the information to display.

    • Ascending (0, 1, 2... or A-Z)
    • Descending (2, 1, 0... or Z-A)

    Ranking Field

    Ranking Function

    Select a field to order by (Ranking Field) and the type of information you want the report to show (Ranking Function). Logger can group the data by date, number, and character.

    For example, if you select the query object "Login Errors by User," you can group the data by "User Name", in "Ascending" order, with "Error" as the ranking field, and "Count" as the ranking function.

    This allows you to see users with the highest number of errors listed at the top of the data group section of the report.

    Show When

    Use this menu if you want information to display when more detailed criteria are met.

  2. If you want to include secondary groups, populate the Then By fields. For example, if your report uses a query that reports on password changes and includes a “User Name” field, you might want to sub-group the results for each date by “User Name”.

    Use the (Add Field) and (Remove Field) buttons to add or remove Then By fields for sub-groups.

The report will generate records organized and grouped in the order you selected.

Tip: Alternatively, you can specify only a sort order (instead of groups). See also, Sort.