Pivot Table is a macro bundled within Table Filter and Charts for Confluence add-onapp. 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:
...
values
...
The sign used as a decimal separator.
...
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.
| Expand |
|---|
| title | Click here to expand the source table ... |
|---|
|
| Agent | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour | Average Time per Call (min) | Money ($) |
|---|
| Remy Deomampo | 6.9 | 3.0 | 2.2 | 6.1 | 2 875.00 | | Rahul Dickson | 8.0 | 1.6 | 4.4 | 4.8 | 5 270.00 | | Radu Donahue | 3.6 | 7.0 | 3.7 | 5.2 | 4 886.00 | | Preston Doorey | 2.2 | 6.9 | 4.8 | 7.5 | 5 237.00 | | Remy Deomampo | 4.4 | 5.7 | 2.4 | 4.6 | 3 140.00 | | Rahul Dickson | 4.5 | 2.3 | 2.6 | 4.3 | 5 249.00 | | Radu Donahue | 7.5 | 3.2 | 1.1 | 5.3 | 2 572.00 | | Preston Doorey | 6.7 | 6.1 | 4.7 | 6 | 2 944.00 | | Phill Doyle | 8.1 | 5.9 | 2.1 | 6.3 | 3 767.00 | | Remy Deomampo | 2.7 | 5.3 | 4.6 | 6.2 | 3 206.00 | | Rahul Dickson | 4.3 | 3.2 | 4.0 | 7.2 | 3 625.00 | | Radu Donahue | 5.6 | 1.7 | 4.9 | 7.6 | 1 399.00 | | Preston Doorey | 5.8 | 3.5 | 3.8 | 4.3 | 5 121.00 | | Remy Deomampo | 8.7 | 4.9 | 2.0 | 7.3 | 4 170.00 | | Rahul Dickson | 8.8 | 1.4 | 2.9 | 4.2 | 2 032.00 | | Radu Donahue | 2.9 | 4.4 | 3.6 | 5 | 3 418.00 | | Preston Doorey | 2.6 | 5.0 | 1.3 | 4.9 | 1 364.00 | | Phill Doyle | 6.3 | 3.3 | 2.0 | 6.8 | 3 554.00 | | Remy Deomampo | 5.7 | 2.4 | 4.8 | 3.9 | 4 005.00 | | Remy Deomampo | 3.6 | 3.1 | 3.4 | 3.3 | 4 672.00 | | Rahul Dickson | 4.9 | 1.1 | 1.8 | 7.1 | 4 711.00 | | Radu Donahue | 2.9 | 5.8 | 1.6 | 5.4 | 4 908.00 | | Preston Doorey | 5.7 | 1.2 | 4.6 | 5.5 | 5 162.00 | | Phill Doyle | 2.7 | 4.1 | 3.0 | 5.4 | 4 227.00 | | Philip Druckman | 5.8 | 2.6 | 4.2 | 4.3 | 2 701.00 |
|
You can use the dedicated panel to change the calculated column and select the appropriate operation type from the following ones:
...
the source table
...
.
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 settingschanges in the page view mode.
Sample Pivot Table
| Info |
|---|
|
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: Select multiple operations for the same column to view the correlations between values at once. |
...
| Pivot Table |
|---|
| decimals | 2 |
|---|
| showrawdata | true |
|---|
| column | Agent |
|---|
| decimalseparator | Point (.) |
|---|
| aggregation | Money ($) |
|---|
| id | 1438704621179_-2011274780 |
|---|
| row | |
|---|
| type | Average‚Min‚Max |
|---|
| separator | Space ( ) |
|---|
| version | 1 |
|---|
|
| Agent | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour | Average Time per Call (min) | Money ($) |
|---|
| Remy Deomampo | 6.9 | 3.0 | 2.2 | 6.1 | 2 875.00 | | Rahul Dickson | 8.0 | 1.6 | 4.4 | 4.8 | 5 270.00 | | Radu Donahue | 3.6 | 7.0 | 3.7 | 5.2 | 4 886.00 | | Preston Doorey | 2.2 | 6.9 | 4.8 | 7.5 | 5 237.00 | | Remy Deomampo | 4.4 | 5.7 | 2.4 | 4.6 | 3 140.00 | | Rahul Dickson | 4.5 | 2.3 | 2.6 | 4.3 | 5 249.00 | | Radu Donahue | 7.5 | 3.2 | 1.1 | 5.3 | 2 572.00 | | Preston Doorey | 6.7 | 6.1 | 4.7 | 6 | 2 944.00 | | Phill Doyle | 8.1 | 5.9 | 2.1 | 6.3 | 3 767.00 | | Remy Deomampo | 2.7 | 5.3 | 4.6 | 6.2 | 3 206.00 | | Rahul Dickson | 4.3 | 3.2 | 4.0 | 7.2 | 3 625.00 | | Radu Donahue | 5.6 | 1.7 | 4.9 | 7.6 | 1 399.00 | | Preston Doorey | 5.8 | 3.5 | 3.8 | 4.3 | 5 121.00 | | Remy Deomampo | 8.7 | 4.9 | 2.0 | 7.3 | 4 170.00 | | Rahul Dickson | 8.8 | 1.4 | 2.9 | 4.2 | 2 032.00 | | Radu Donahue | 2.9 | 4.4 | 3.6 | 5 | 3 418.00 | | Preston Doorey | 2.6 | 5.0 | 1.3 | 4.9 | 1 364.00 | | Phill Doyle | 6.3 | 3.3 | 2.0 | 6.8 | 3 554.00 | | Remy Deomampo | 5.7 | 2.4 | 4.8 | 3.9 | 4 005.00 | | Remy Deomampo | 3.6 | 3.1 | 3.4 | 3.3 | 4 672.00 | | Rahul Dickson | 4.9 | 1.1 | 1.8 | 7.1 | 4 711.00 | | Radu Donahue | 2.9 | 5.8 | 1.6 | 5.4 | 4 908.00 | | Preston Doorey | 5.7 | 1.2 | 4.6 | 5.5 | 5 162.00 | | Phill Doyle | 2.7 | 4.1 | 3.0 | 5.4 | 4 227.00 | | Philip Druckman | 5.8 | 2.6 | 4.2 | 4.3 | 2 701.00 | |