Ad-Hoc Reporting: Grouping
Purpose
- This article will review the Ad-Hoc Grouping within the Reports module.
- The Grouping section in the ad-hoc reporting module allows users to organize their report data by specific fields, making it easier to analyze and interpret related information. Grouping is particularly useful when you want to categorize data into logical sections, such as grouping incidents by type, location, or personnel. This feature helps to summarize data and identify trends within subsets of your dataset.
How Grouping Works
- Grouping organizes your report data based on selected fields, displaying aggregated data for each group. For example, instead of showing every individual incident on separate rows, you can group the incidents by type and display a summary for each category.
- Once data is grouped, you can apply additional calculations like counts, averages, or sums, further enhancing the usefulness of the report.
- Navigate to the Grouping Section: When setting up your report, go to the Grouping section, where you can define how your data should be grouped.
- Choose the Field(s) to Group By: Select the field(s) by which you want to group the data. Common grouping fields include:
- In this case, we have selected name
- Apply Grouping: Once you have selected the field(s), the report will automatically group the data, organizing it based on the criteria you’ve set. For example, if you group by “Name,” all name's of the same type will be grouped together in the report.
- Add Aggregates (Optional): After grouping the data, you can apply aggregate functions to summarize information within each group. Common aggregates include:
- Count: Show the number of records in each group (e.g., the number of incidents of each type).
- Sum: Add up a numeric field (e.g., total response time for each group).
- Average: Display the average value for a numeric field (e.g., average response time for each incident type).
Grouping with Summary Report
- When selecting the Summary Report type, grouping becomes even more critical, as the main purpose of a summary report is to provide high-level insights based on grouped data. Grouping in summary reports allows users to aggregate data into categories and display relevant metrics for each group.
Best Practices for Using Grouping
- Choose the Right Fields for Grouping: Group by fields that help you achieve your analysis goals. For example, group by incident type if you’re interested in understanding how incidents are distributed across categories.
- Use Aggregates Wisely: Applying aggregates like counts or averages can make your grouped data more insightful by showing totals or summaries within each group.
Related Articles
Ad-Hoc Summary Reports: Grouping
Purpose This article demonstrates uses cases and provides an overview of grouping options available within a Summary Ad-Hoc report. Summary Reports Grouping is in beta phase. The First Due Team will be making quick and frequent updates to this ...
Ad-Hoc Reporting: Sort
Purpose This article will review the Ad-Hoc Sorting Section within the Reports module. Information The Sorting section in the ad-hoc reporting module allows users to organize data in a specific order to make it easier to read, analyze, and ...
Inspection Record - Ad Hoc Violations
Purpose To demonstrate how to add Ad Hoc Violations to an Inspection Checklist. An Ad-Hoc Violation is a feature to add a violation to the Checklist that is not contained within the current Checklist. Video Instructions Note: Ad-Hoc Violations must ...
Ad-Hoc Reporting: Filters
Purpose This article will review the Ad-Hoc Filters within the Reports module. Information The Filters section in the ad-hoc reporting module allows users to refine the data included in their reports by applying specific conditions. Filters are ...
Ad-Hoc Reporting: Criteria
Purpose This article will review the Ad-Hoc Criteria Information within the Reports module. Information The Criteria section in the ad-hoc reporting module allows users to apply filters that narrow down the data included in the report. By setting ...