Boards: Totals and selection statistics

Use the summary row at the bottom of Table to see calculations for fields. When the table is grouped, each group can also show a subtotal. The row stays at the bottom of the table as you scroll.

Choose a summary

Select a cell in the bottom summary row, then choose a calculation. The available calculations depend on the field type. Numeric fields can show sum, average, median, minimum, maximum, or range. For example, choose Sum on a number field to add its values, or Average to see their mean. Currency summaries use that field’s currency and format.

Other fields can show the number of records, empty or filled values, unique values, or percentages for empty, filled, and checked values where supported. A text formula does not offer numeric calculations. If a field has no numeric values for the selected calculation, its summary shows a dash.

The first column can summarize record titles. Select the summary cell to choose among the available count and completeness calculations. In grouped tables, each subtotal row summarizes the records in that group. The summary row at the bottom still covers the table as a whole.

See statistics for selected cells

Select a range of at least two cells to show selection statistics below the table. The statistics include count and, for numeric values, sum, average, minimum, and maximum. A range can cover more than one row or column. Only numeric values are included in the calculations; empty and non-numeric cells do not affect the numeric results.

Currency values remain grouped by currency, and values with different number formats are kept separate. This prevents values such as different currencies or decimal formats from being combined into one total.

Select the statistics to show from the menu. Count, sum, average, minimum, and maximum can be turned on or off individually. Your selection is saved for your user and view, so it applies when you use that view again. Clear the cell selection to hide the statistics.

Notes

Summaries use the records in the current table data. A filter changes which records appear in the table. Selection statistics describe the selected cell range, not every selected row.