Add a summary to any numeric column in your table layout
The Column Summary feature in Noloco allows you to add a summary to any numeric column in your table layout (Grid or Table). This feature is particularly useful for quickly calculating and displaying key data metrics like totals, averages, and more.
Financial Tables: Calculate the total sum of invoice amounts.
Sales Data: Determine the average sales per item.
Inventory Management: Find the maximum or minimum stock levels.
Steps to Add a Column Summary
Navigate to Your Table
Enable Build Mode
Activate build mode from the Build Mode Toolbar. This allows you to make changes to your table layout.
Open the Field Settings
Locate the numeric field (column) you want to summarize and open its field settings.
Select Your Desired Summary
Choose the type of summary you wish to display from the following options:
Count: Number of non-empty items in the column.
Sum: Total sum of all numeric values in the column.
Maximum: Highest value in the column.
Minimum: Lowest value in the column.
Average: Average of all numeric values in the column.
Examples of Column Summaries
Example 1: Summing Invoice Amounts
Use Case: In a financial table, add a Sum summary to the 'Invoice Amount' column to see the total amount across all invoices.
Example 2: Calculating Average Sales
Use Case: In a sales table, use the Average summary on the 'Units Sold' column to understand the average sales per item.
Example 3: Finding Maximum Stock Level
Use Case: In an inventory table, apply a Maximum summary to the 'Stock Level' column to identify the item with the highest stock.
Grouped Table Summaries
When your table is grouped by one or more categories (e.g., by product type, region, etc.), the summaries will be calculated for each group separately, providing detailed insights per category.