[]
(Showing Draft Content)

Add Totals Row

The Total Method setting allows you to calculate and display a summary value for any field bound to the Columns slot in a Data Table. This option becomes available after you drag a data attribute into the Columns binding slot.

Once the field is bound, a gear icon appears next to the attribute name. Select the gear icon to open the field settings dropdown, then locate the Total Method option. The available Total Method options depend on whether the bound field is categorical or numerical.


1. Total Method for Categorical Data

When a categorical field (such as Country, Product, or Category) is bound to the Columns slot, the Total Method provides options that summarize the number of entries rather than performing arithmetic calculations.

Available options:

  • None (Default)

    No total is calculated or displayed for the column.

  • Count

    Displays the total number of records in the column.

    This counts every row where the field contains a value. Duplicate values are included in the count.

    Example:

    If the column contains 100 rows of product names, the Count total will display 100, even if many products repeat.

  • Distinct Count

    Displays the number of unique values in the column.

    Duplicate entries are counted only once.

    Example:

    If the Product column contains 100 rows but only 15 unique products, the Distinct Count will display 15.


2. Total Method for Numerical Data

When a numerical field (such as Sales, Profit, Quantity, or Revenue) is bound to the Columns slot, the Total Method provides aggregation functions that perform mathematical calculations.

Available options:

  • None (Default)

    No total is calculated.

  • Sum

    Adds all values in the column.

  • Average

    Calculates the mean value of the column.

  • Max

    Displays the largest value in the column.

  • Min

    Displays the smallest value in the column.

  • Count

    Counts the number of records that contain a value.

  • Distinct Count

    Counts the number of unique numeric values.

For numerical fields, the Total Method determines how the data is aggregated in the totals row. Unlike categorical fields, numerical fields support full mathematical aggregation.