Links

Column Summaries

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.

Use Cases

  • 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

  1. 1.
  2. 2.

    Enable Build Mode

    Activate build mode from the Build Mode Toolbar. This allows you to make changes to your table layout.
  3. 3.
    Open the Field Settings Locate the numeric field (column) you want to summarize and open its field settings.
  4. 4.

    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.