In order to use the plugins please login as a Guest
Skip to end of metadata
Go to start of metadata

Pivot Table is a macro bundled within Table Filter and Charts for Confluence add-on. It allows you to create pivot tables with aggregated and summarized data on the basis of repeated values from the source table.

Parameters

The add-on adds the Pivot table macro. You can add this macro onto your Confluence page and further paste any table into the macro body. You can also insert the macros that generate the table data and get a pivot table with aggregated values. The following parameters are available to you:

ParameterParameter NameDefaultDescription
columnRow Labels The column that contains row labels that will be grouped into a pivot table.
aggregationCalculated Column The column with data values that will be processed according to the selected operation type.
decimalsDecimal places Number of decimal places in data values.
decimalseparatorDecimal separatorPoint (.)

The sign used as a decimal separator.

idMacro IDAssigned automaticallyID of the macro in Confluence.
typeOperation TypeCountType of the operation that is performed on data values containing in the Calculated Column.
separatorThousands separator The sign that is used as a thousands separator.
showrawdataShow the source tableFalseOption that enables display of the source table data used for generation of the pivot table.
hidePaneHide control panelFalseOption that hides the control panel for management of the pivot table.

Pivot tables in Confluence

You can expand the section below and see the source table that is used for generation of a pivot table with aggregated values.

 Click here to expand the source table ...
AgentTickets per HourAverage Time per Ticket (min)Calls per HourAverage Time per Call (min)Money ($)
Remy Deomampo6.93.02.26.12 875.00
Rahul Dickson8.01.64.44.85 270.00
Radu Donahue3.67.03.75.24 886.00
Preston Doorey2.26.94.87.55 237.00
Remy Deomampo4.45.72.44.63 140.00
Rahul Dickson4.52.32.64.35 249.00
Radu Donahue7.53.21.15.32 572.00
Preston Doorey6.76.14.762 944.00
Phill Doyle8.15.92.16.33 767.00
Remy Deomampo2.75.34.66.23 206.00
Rahul Dickson4.33.24.07.23 625.00
Radu Donahue5.61.74.97.61 399.00
Preston Doorey5.83.53.84.35 121.00
Remy Deomampo8.74.92.07.34 170.00
Rahul Dickson8.81.42.94.22 032.00
Radu Donahue2.94.43.653 418.00
Preston Doorey2.65.01.34.91 364.00
Phill Doyle6.33.32.06.83 554.00
Remy Deomampo5.72.44.83.94 005.00
Remy Deomampo3.63.13.43.34 672.00
Rahul Dickson4.91.11.87.14 711.00
Radu Donahue2.95.81.65.44 908.00
Preston Doorey5.71.24.65.55 162.00
Phill Doyle2.74.13.05.44 227.00
Philip Druckman5.82.64.24.32 701.00

You can use the dedicated panel to change the calculated column and select the appropriate operation type from the following ones:

  • Count - counts the number of values pertaining to one label in the source table.
  • Max - determines the maximal value per each label.
  • Min - determines the minimal value per each label.
  • Average - calculates the average values per each label.
  • Sum - calculates the sum of values per each label.

Feel free to work with the sample Pivot table for getting aggregated data values. You can always save any modifications made in the macro's parameters by clicking Save settings in the page view mode.

Sample Pivot Table

Use Hint

Try to change the calculated column among the following table columns:

  • Tickets per Hour
  • Average Time per Ticket (min)
  • Calls per Hour
  • Average Time per Call (min)
  • Money ($)

Try to change the operation type among the following ones:

  • Max
  • Min
  • Average
  • Sum
  • Count

Select multiple operations for the same column to view the correlations between values at once.

 

 

Probably, there is no table within the Pivot Table macro. Please place the table or the macro generating a table within it. Once this is done, configure parameters of aggregation and summarization.

The table is being loaded. Please wait for a bit ...
AgentTickets per HourAverage Time per Ticket (min)Calls per HourAverage Time per Call (min)Money ($)
Remy Deomampo6.93.02.26.12 875.00
Rahul Dickson8.01.64.44.85 270.00
Radu Donahue3.67.03.75.24 886.00
Preston Doorey2.26.94.87.55 237.00
Remy Deomampo4.45.72.44.63 140.00
Rahul Dickson4.52.32.64.35 249.00
Radu Donahue7.53.21.15.32 572.00
Preston Doorey6.76.14.762 944.00
Phill Doyle8.15.92.16.33 767.00
Remy Deomampo2.75.34.66.23 206.00
Rahul Dickson4.33.24.07.23 625.00
Radu Donahue5.61.74.97.61 399.00
Preston Doorey5.83.53.84.35 121.00
Remy Deomampo8.74.92.07.34 170.00
Rahul Dickson8.81.42.94.22 032.00
Radu Donahue2.94.43.653 418.00
Preston Doorey2.65.01.34.91 364.00
Phill Doyle6.33.32.06.83 554.00
Remy Deomampo5.72.44.83.94 005.00
Remy Deomampo3.63.13.43.34 672.00
Rahul Dickson4.91.11.87.14 711.00
Radu Donahue2.95.81.65.44 908.00
Preston Doorey5.71.24.65.55 162.00
Phill Doyle2.74.13.05.44 227.00
Philip Druckman5.82.64.24.32 701.00
  • No labels