| Agent | Date | Tickets per Hour | Ticket Response (min) | Calls per Hour | Answered TIckets |
|---|---|---|---|---|---|
| Remy Dempo | 25.06.2015 | 7.3 | 3.2 | 3.3 | 89 |
| Rahul Dickstein | 26.06.2015 | 8.5 | 3.1 | 1.8 | 95 |
| Radu Donahue | 27.06.2015 | 5.0 | 3.7 | 4.5 | 65 |
| Preston Doorey | 28.06.2015 | 2.2 | 5.8 | 2.7 | 28 |
| Phill Doyle | 29.06.2015 | 3.9 | 5.2 | 2.9 | 37 |
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:
| Parameter | Parameter Name | Default | Description |
|---|---|---|---|
| tfc-width | Width | Width of the chart in pixels. | |
| tfc-height | Height | Height of the chart in pixels. | |
| column | Row labels / Dates column | Name of the column containing data labels or dates. | |
| datepattern | Date format | Format of dates used in the table. | |
| aggregation | Values column | Name of the column containing data values. | |
| id | ID | Assigned automatically | ID of the chart. |
| type | Type | Type of the chart to generate. | |
| separator | Decimal Separator | Decimal separator used in data values. | |
| hide | Hide the source table | Disabled | Option to hide the source table with data. |
| hidecontrols | Hide controls | DIsabled | Option to hide the controls used to manage parameters of the Table Chart macro. |
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.
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.
Table chart examples
Sample Chart #1
Use Hint
Try to alternate the view of the chart by switching among the following chart types:
- Pie
- Donut
- 3D Donut
- Column
- Bar
You can also select a new column with data values of the following ones:
- Answered Tickets
- Call per Hour
- Ticket Response (min)
- Tickets per Hour
Sample Chart #2
Use Hint
Try to alternate the view of the chart by switching among the following chart types:
- Line
- Area
For the Row Labels and Values Column use only table columns containing numbers.
| Date | Income | Spendings | Balance |
|---|---|---|---|
| 8/1/2015 | 4366.50 | 4332.43 | 34.07 |
| 8/2/2015 | 3369.00 | 4251.00 | -882.00 |
| 8/3/2015 | 4685.00 | 5212.57 | -527.57 |
| 8/4/2015 | 3284.25 | 2912.14 | 372.11 |
| 8/5/2015 | 2892.75 | 4260.00 | -1367.25 |
| 8/6/2015 | 2833.38 | 3034.29 | -200.91 |
| 8/7/2015 | 3827.63 | 4318.00 | -490.38 |
| 8/8/2015 | 3936.38 | 5706.71 | -1770.34 |
| 8/9/2015 | 4804.38 | 3199.57 | 1604.80 |
| 8/10/2015 | 4325.38 | 4151.86 | 173.52 |
| 8/11/2015 | 4884.13 | 3800.71 | 1083.41 |
| 8/12/2015 | 4265.38 | 3469.86 | 795.52 |
| 8/13/2015 | 4737.25 | 3301.14 | 1436.11 |
| 8/14/2015 | 3201.75 | 4026.86 | -825.11 |
| 8/15/2015 | 4498.88 | 4910.00 | -411.13 |
| 8/16/2015 | 4823.88 | 3562.86 | 1261.02 |
| 8/17/2015 | 3833.63 | 4584.57 | -750.95 |
| 8/18/2015 | 2753.25 | 2933.71 | -180.46 |
| 8/19/2015 | 3685.25 | 4079.57 | -394.32 |
| 8/20/2015 | 4313.50 | 4852.71 | -539.21 |
| 8/21/2015 | 2726.25 | 5172.00 | -2445.75 |
| 8/22/2015 | 4849.25 | 4364.57 | 484.68 |
| 8/23/2015 | 3778.50 | 5115.14 | -1336.64 |
| 8/24/2015 | 3225.50 | 3665.71 | -440.21 |
| 8/25/2015 | 4719.13 | 3601.57 | 1117.55 |
| 8/26/2015 | 3815.25 | 3517.00 | 298.25 |
| 8/27/2015 | 4983.88 | 3913.86 | 1070.02 |
| 8/28/2015 | 4219.00 | 5315.14 | -1096.14 |
| 8/29/2015 | 3282.00 | 5555.86 | -2273.86 |
| 8/30/2015 | 3746.13 | 3921.57 | -175.45 |
| 8/31/2015 | 4939.50 | 4909.29 | 30.21 |
Sample Chart #3
Use Hint
Try to alternate the view of the chart by switching among the following chart types:
- Time Line
- Time Area
Alternate the Values Column among the following table columns:
- Income
- Spendings
- Balance
| Date | Income | Spendings | Balance |
|---|---|---|---|
| 8/1/2015 | 4366.50 | 4332.43 | 34.07 |
| 8/2/2015 | 3369.00 | 4251.00 | -882.00 |
| 8/3/2015 | 4685.00 | 5212.57 | -527.57 |
| 8/4/2015 | 3284.25 | 2912.14 | 372.11 |
| 8/5/2015 | 2892.75 | 4260.00 | -1367.25 |
| 8/6/2015 | 2833.38 | 3034.29 | -200.91 |
| 8/7/2015 | 3827.63 | 4318.00 | -490.38 |
| 8/8/2015 | 3936.38 | 5706.71 | -1770.34 |
| 8/9/2015 | 4804.38 | 3199.57 | 1604.80 |
| 8/10/2015 | 4325.38 | 4151.86 | 173.52 |
| 8/11/2015 | 4884.13 | 3800.71 | 1083.41 |
| 8/12/2015 | 4265.38 | 3469.86 | 795.52 |
| 8/13/2015 | 4737.25 | 3301.14 | 1436.11 |
| 8/14/2015 | 3201.75 | 4026.86 | -825.11 |
| 8/15/2015 | 4498.88 | 4910.00 | -411.13 |
| 8/16/2015 | 4823.88 | 3562.86 | 1261.02 |
| 8/17/2015 | 3833.63 | 4584.57 | -750.95 |
| 8/18/2015 | 2753.25 | 2933.71 | -180.46 |
| 8/19/2015 | 3685.25 | 4079.57 | -394.32 |
| 8/20/2015 | 4313.50 | 4852.71 | -539.21 |
| 8/21/2015 | 2726.25 | 5172.00 | -2445.75 |
| 8/22/2015 | 4849.25 | 4364.57 | 484.68 |
| 8/23/2015 | 3778.50 | 5115.14 | -1336.64 |
| 8/24/2015 | 3225.50 | 3665.71 | -440.21 |
| 8/25/2015 | 4719.13 | 3601.57 | 1117.55 |
| 8/26/2015 | 3815.25 | 3517.00 | 298.25 |
| 8/27/2015 | 4983.88 | 3913.86 | 1070.02 |
| 8/28/2015 | 4219.00 | 5315.14 | -1096.14 |
| 8/29/2015 | 3282.00 | 5555.86 | -2273.86 |
| 8/30/2015 | 3746.13 | 3921.57 | -175.45 |
| 8/31/2015 | 4939.50 | 4909.29 | 30.21 |