Adding Totals to Tables

You can add totals to a table.
To add totals to a table:
  1. Click Dashboards tab, the Dashboards tab.
  2. Click Dashboard Designer, in the bottom-left corner.
  3. On the Analyses dialog, click Options button, the Options button, next to an analysis and select Edit.
  4. On the analysis page, select a table.
  5. Click Menu options button, the Menu options button, in the top-right corner of the table and select Show totals.
    You can remove the totals by selecting Hide totals from the menu.
  6. To unpin the row with the totals so that it moves along with the other rows when you scroll, click Menu options button, the Menu options button and select Unpin totals.
  7. To change the default aggregation method for the totals, click Options button, the Options button, next to a field from the Value field well in the Visuals panel, then select Total and one of the available aggregate functions:
    • Default – Uses the same aggregation as the metric field.
    • Sum – Calculates the sum of the data.
    • Average – Calculates the average of the data.
    • Min – Calculates the minimum value of the data.
    • Max – Calculates the maximum value of the data.
    • None (Hide) – The totals are not calculated and the total cells are left blank.

    These limitations apply to custom totals:

    • Conditional formatting is not supported for custom totals.
    • Total aggregations, such as Min, Max, Sum, and Average, are not supported for string columns.
    • The Average and Sum total aggregation functions are not supported for date and time columns.

  8. Click Format visual icon, the Format visual icon, in the top-right corner of the table to open the Properties panel and configure the formatting settings from the Totals section.
    You can customize the position, the label, the background color, the text color and size, and the border settings for the row with the totals.
Parent topic: Using Tables