Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Beta release: In beta release, the summarize option enables you to display the sum (SUM) or average (AVG) for column values containing only numeric data.

Sum-up overview

  • Automatically calculate and display the sum (Sum) or average (Avg) for columns containing numeric data.

  • Sum-up (Sum-up sign.jpg ) is available in both the Edit and View mode of the macro on the Confluence page.

  • When the Sum-up row is added, the Sum value is displayed by default for the numeric columns. For columns containing both numeric and non-numeric data or only non-numeric data, the Sum-up values will remain empty.

The Sum-up type configuration defined in the macro's edit mode is saved as the default for each column and will automatically apply with each Confluence page refresh.

Configure the Sum-up row

  • To include the Sum-up row, click the Sum-up icon (image-20241209-074727.png ) in the right corner just above the table.

    Sum_up_icon.jpg
  • The Sum-up row is included as the first row of the table, just below the table header row, and is preceded by an Sum-up sign.jpg icon.

    Sum_up_row_added.jpg
  • You can see that the SUM value is displayed by default for all numeric columns except the non-numeric columns.

  • You have options to change the Sum-up type between Sum, Avg and None.

Option 1: Change the Sum-up type using the Edit column dialog

  • To display the average value for any specific column, click the column setting ellipsis (ellipsis.jpg ). For reference, to display the average value for the Tax column, click the ellipsis.

    Sum_up_row.jpg

...

  • The Edit column dialog opens. Click the Sum-up type drop-down and select the required type. For reference, Avg is selected.

    Edit column_change_sum_type.jpg
  • The Tax column displays the Avg value. Likewise, you can choose the Sum-up type for each column as required.

    Sum_up_AVG.jpg

Option 2: Switch between the Sum-up type with clicks

Quickly switch the Sum-up type with a sequence of clicks on the specific column header without opening the Edit column dialog. Each click changes the displayed values between Sum, Average, and None.

...