Column Summaries
Add a summary to any numeric column in your table layout
Last updated
Add a summary to any numeric column in your table layout
Last updated
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.
Open the Field Settings Locate the numeric field (column) you want to summarize and open its field settings.
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.
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.
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.