Footer Aggregations¶
The grid footer displays calculated aggregations for numeric columns, helping you understand your data at a glance.
Screenshot Placeholder
TODO: Add screenshot of footer aggregations
DataGrid footer showing calculated aggregations (Sum, Average, Min, Max, Count) aligned with their respective columns
Enabling the Footer¶
- Open Grid Settings (gear icon)
- Navigate to the Footer tab
- Toggle Show Footer on
The footer appears at the bottom of the grid with sticky positioning.
Footer Rows¶
Page Aggregations¶
Shows calculations for the currently visible page only.
Total Aggregations¶
Shows calculations across all data (even when paginated).
You can enable one or both rows depending on your needs.
Aggregation Types¶
| Type | Description | Example |
|---|---|---|
| Sum | Total of all values | 1,234.56 |
| Average | Mean of all values | 45.67 |
| Min | Lowest value | 0.50 |
| Max | Highest value | 999.99 |
| Count | Number of values | 150 |
Adding Aggregations¶
- Open Grid Settings > Footer
- Click Add Aggregation
- Select a column (numeric columns only)
- Choose the aggregation type
- Click Add
The aggregation appears in the footer below the selected column.
Configuring Aggregations¶
Per-Column Settings¶
Each column can have its own aggregation:
- Some columns benefit from Sum (quantities, costs)
- Others make sense with Average (ratings, percentages)
- Count works for any column
Multiple Aggregations¶
You can add multiple aggregations:
- Different columns with different types
- Same column cannot have duplicate types
Reading the Footer¶
Cell Alignment¶
Footer values align with their respective columns for easy reading.
Formatting¶
Values follow the column's number format:
- Currency columns show currency symbols
- Percentage columns show % suffix
- Decimals match column settings
Empty Values¶
Columns without numeric data or without configured aggregations show empty cells.
Common Use Cases¶
Construction Quantities¶
| Column | Aggregation |
|---|---|
| Area | Sum |
| Length | Sum |
| Volume | Sum |
| Count | Count |
Cost Planning¶
| Column | Aggregation |
|---|---|
| Unit Cost | Average |
| Total Cost | Sum |
| Items | Count |
Quality Metrics¶
| Column | Aggregation |
|---|---|
| Score | Average |
| Completion % | Average |
| Issues | Count |
| Max Deviation | Max |
Performance Notes¶
Page vs Total¶
- Page aggregations calculate quickly (visible data only)
- Total aggregations may take longer for large datasets
Large Datasets¶
For datasets with 10,000+ rows:
- Total aggregations are calculated server-side when possible
- A loading indicator appears during calculation
- Consider using page aggregations for faster updates
Customization¶
Column Visibility¶
- Aggregations only appear for visible columns
- Hiding a column hides its aggregation
Sticky Behavior¶
The footer sticks to the bottom of the viewport when scrolling, remaining visible at all times.
Styling¶
Footer cells inherit grid styling but can be customized through the style system.
Removing Aggregations¶
- Open Grid Settings > Footer
- Find the aggregation in the list
- Click the remove/delete button
- Confirm removal
Troubleshooting¶
Aggregation Shows Wrong Value¶
- Verify the column data type is numeric
- Check for text values that can't be summed
- Ensure filters aren't excluding data
Footer Not Visible¶
- Check that footer is enabled in settings
- Scroll to see if it's outside the viewport
- Verify at least one aggregation is configured
Performance Issues¶
- Reduce total aggregations on large datasets
- Use page aggregations when totals aren't needed
- Consider filtering to reduce data volume
Best Practices¶
- Choose Relevant Types - Sum makes sense for additive values; Average for rates
- Limit Aggregations - Too many can clutter the footer
- Use Formatting - Configure number formats for readability
- Consider Context - Page vs Total depends on your workflow