This feature allows users to create Summary Reports that provide broad analytical views of totals, averages, trends, and percentages from agency data. Summary grouping transforms detailed records into meaningful aggregated insights that can be used for performance analysis, trend identification, and creating custom graphs or charts for presentations and decision-making.
Summary grouping is specifically designed for Summary Report types in the Ad-Hoc reporting system and is accessed after completing data source configuration, column selection, sorting, and criteria filtering. Unlike tabular reports that display individual records, summary reports aggregate data into calculated totals, averages, counts, and other statistical measures. This feature is essential for executive dashboards, performance metrics, compliance reporting, and operational analysis. Summary reports can include row groups for categorical organization, summary columns for calculations, computed columns for advanced formulas, column groups for cross-tabulation analysis, and integrated charts for visual representation.
Users must have access to the Reports Module and Ad-Hoc reporting functionality. Specific permissions are required based on the data sources and fields being summarized. Contact your system administrator if you encounter access restrictions when creating summary reports or accessing certain data fields.
Single Row Group Result: Creates one line item for each unique value in the selected field (e.g., one row each for Shift A, B, and C)
Multiple Row Groups Result: Creates a hierarchical structure with expandable/collapsible sections showing secondary groups nested within primary groups
B. Column for Aggregation: Choose which data field the calculation will be performed on
C. Filter Conditions: Apply additional filtering specific to this summary column
D. Name: Enter a descriptive column header (e.g., "Calls per Shift")
E. Value Format: Select appropriate formatting for your calculation results:
F. Decimals: Specify decimal places to display (0 for counts, 2 for currency)
G. Alias: System-generated identifier used for computed column formulas
A. Formula Creation:
col_1 / col_1_total * 100
(calculates percentage of total)col_1 + col_2
(adds two columns together)C. Name: Provide descriptive name for the computed result
D. Value Format: Choose display format (Percent, Currency, Number, etc.)
A. Data Source Field: Select the field to group columns by
B. Calculation Type: Choose the measurement method for the grouped data
C. Data Source: Select the field to calculate against
Result: Transforms simple row-based reports into cross-tabulated data showing intersections of row and column groups
A. Chart Type Selection:
B. Grouping: Select the Data Source Field from your Row Group configuration
C. Measure: Choose calculation method for chart data
Chart Interaction: Hover over chart elements to display specific values and percentages
Do:
Don't:
Optimization Tips:
Q: My row groups aren't displaying any data. What's wrong? A: Ensure you have configured at least one Summary Column with appropriate measure and aggregation settings.
Q: Can I use the same field for both row groups and column groups? A: Yes, but this may create redundant information. Consider using different fields for more meaningful cross-tabulation.
Q: My computed column formula shows an error. How do I fix it? A: Verify that all column aliases in your formula exist and are spelled correctly. Ensure mathematical operators are valid.
Q: What's the difference between criteria filtering and summary column filtering? A: Criteria filtering applies to the entire report, while summary column filtering applies only to that specific column's calculation.
Q: Can I export summary reports with charts? A: Chart functionality depends on your export format. Contact your system administrator for specific export capabilities.
Q: How do I create percentage calculations?
A: Use computed columns with formulas like col_1 / col_1_total * 100
and set the value format to "Percent."
Call Volume Analysis by Shift:
Apparatus Performance with Cross-Tabulation:
Training Completion Rates:
Revenue Analysis with Visualization:
Response Time Performance:
Multi-Level Grouping:
Cross-Tabulation Analysis:
Integrated Visualization: