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 |
Chart from Table is a macro bundled within Table Filter and Charts add-on. It allows you to generate dynamically updated charts with a capability to instantly switch between columns with different data values.
Parameters
The add-on adds the Chart from 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 dynamic chart at once. The following parameters are available to you:
Parameter | Parameter Name | Default | Description |
---|---|---|---|
id | ID | Assigned automatically | ID of the chart. |
column | Labels Column | None | The column containing labels for data values. |
aggregation | Values column | None | The column containing numerical values for chart generation. |
X-axis value column | None | The column containing numerical values for chart generation. | |
Y-axis value column | None | The column or columns containing numerical values for chart generation. | |
column | Dates column | None | You can select the column with dates for chart generation. |
datepattern | Date Format | yy-mm-dd | You can specify the date format used in the column with dates. |
type | Type | Pie | You can select the appropriate chart type. |
separator | Decimal Separator | Point | You can select the decimal separator (either point or comma). |
tfc-height | Height | None (dependable on screen area) | You can define the height of the generated chart. |
tfc-width | Width | None (dependable on screen area) | You can define the width of the generated chart. |
hide | Hide the source table | Disabled | You can hide the table with data and enable display of the chart only. |
hidecontrols | Hide chart controls | Disabled | You can hide the chart controls when you need just to display the chart without a necessity to update its view. |
Show legend | Disabled | You can hide the legend for the generated chart. | |
Show grid | Enabled | You can enabled display of the grid on the generated chart. | |
Chart Title | Disabled | You can specify the title of the chart. | |
Align chart | Enabled | You can define the appropriate alignment for the chart. | |
X-axis label | Disabled | You can specify the label for X axis of the chart. | |
Y-axis label | Disabled | You can specify the label for Y axis of the chart. | |
Minimal Value | Disabled | You can specify the minimal value for showing only data values greater than the specified minimal value. | |
Maximal Value | Disabled | You can specify the maximal value for showing only data values not greater than the specified maximal value. | |
Scale Step | Disabled | You can specify the required scale step for showing the chart. | |
Minimal X Value | You can specify the minimal value for X axis for showing only data values greater than the specified minimal value. | ||
Maximal X Value | You can specify the maximal value for X axis for showing only data values not greater than the specified maximal value. | ||
Minimal Y Value | You can specify the minimal value for Y axis for showing only data values greater than the specified minimal value. | ||
Maximal Y Value | You can specify the maximal value for Y axis for showing only data values not greater than the specified maximal value. | ||
Scale X Step | You can specify the required scale step of X axis for showing the chart. For Time Line and Time Area charts you can specify the appropriate number of days (Xd), months (Xm) or years (Xy) where the 'X' is the digit, as follows:
| ||
Scale Y Step | You can specify the required scale step of Y axis for showing the chart. |
Chart Examples
Try to see Chart from Table macro in action while working with the following 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
You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.
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.
You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.
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
You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.
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 #4
Use Hint
Try to alternate the view of the chart by adding or removing columns with values for this stacked column chart:
- Q1 2014
- Q2 2014
- Q3 2014
- Q4 2014
- Q1 2015
- Q2 2015
- Q3 2015
- Q4 2015
Alternate the view of the chart by switching between the following chart types:
- Stacked Column
- Stacked Bar
You can use the Cogwheel icon on the chart management panel to save the changes in the chart, show or hide the source table, or export your chart to PDF or Word.
Add-on | Q1 2014 | Q2 2014 | Q3 2014 | Q4 2014 | Q1 2015 | Q2 2015 | Q3 2015 | Q4 2015 |
---|---|---|---|---|---|---|---|---|
Table Filter | 139 | 114 | 145 | 106 | 106 | 103 | 148 | 105 |
Smart Attachments | 54 | 79 | 69 | 66 | 90 | 96 | 50 | 97 |
Awesome Graphs | 142 | 128 | 135 | 195 | 198 | 179 | 238 | 192 |
Quizzes | 20 | 48 | 36 | 42 | 33 | 37 | 46 | 29 |
Customer Case | 15 | 10 | 13 | 25 | 18 | 22 | 17 | 19 |