(OUTDATED) Table Filter and Charts for Confluence

Space shortcuts

Page tree

Versions Compared

Old Version 4

changes.mady.by.user Andrey Khaneev

Saved on

compared with

New Version 5

changes.mady.by.user Vadim Rutkevich

Saved on

Key

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

...

talk-547all the data different from numbers are skipped during processing.
Info

Before inserting the master table into the macro ensure the following things:

  1. The master table should contain the repeated labels that will be used for data summarization.
  2. Columns should have data of the same type. If the column has data of different types, you may get an error when summarizing data in the pivot table.
Talk
id

Configuring Pivot table macro

  1. On the Confluence page opened in the edit mode, click the Pivot table macro.
  2. Click Edit.
  3. In the Edit Pivot table Macro form, define parameters of the macro, as follows:
    • Row Labels - select the column with labels, which the data will be summarized for.
    • Calculated Column - select the column you want to perform calculations for.
    • Operation Type - select the operation you want to perform.
    • Decimal separator - select the correct decimal character.
    • Thousands separator - select the correct thousands separator . Talkidtalk-548(optional, for better data presentation).
    • Decimal places - enter the number of decimal places to show in the pivot table.
  4. Click Save.

...