Image Added
| Handy Button |
|---|
| blank | true |
|---|
| color | Blue |
|---|
| link | http://events.eventzilla.net/e/table-data-management-in-confluence-workshop-2138891872 |
|---|
| name | Register for Free Workshop |
|---|
|
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.
...
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:
| Parameter | Parameter Name | Default | Description |
|---|
| column | Row Labels | | The column that contains row labels that will be grouped into a pivot table. |
|---|
| aggregation | Calculated Column | | The column with data values that will be processed according to the selected operation type. |
|---|
| decimals | Decimal places | | Number of decimal places in data values. |
|---|
| decimalseparator | Decimal separator | Point (.) | The sign used as a decimal separator. |
|---|
| id | Macro ID | Assigned automatically | ID of the macro in Confluence. |
|---|
| type | Operation Type | Count | Type of the operation that is performed on data values containing in the Calculated Column. |
|---|
| separator | Thousands separator | | The sign that is used as a thousands separator. |
|---|
| showrawdata | Show the source table | False | Option that enables display of the source table data used for generation of the pivot table. |
|---|
| hidePane | Hide control panel | False | Option that hides the control panel for management of the pivot table. |
|---|
Pivot tables in Confluence
...
| 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:
...
| Pivot Table |
|---|
| decimals | 2 |
|---|
| showrawdata | false |
|---|
| column | Agent |
|---|
| decimalseparator | Point (.) |
|---|
| aggregation | Money ($) |
|---|
| id | 1438704621179_-2011274780 |
|---|
| type | Average‚Min‚Max |
|---|
| separator | Space ( ) |
|---|
|
| 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 | |