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 |
|---|
| 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. |
|---|
Chart Examples
Try to see Chart from Table macro in action while working with the following chart examples.
Sample Chart #1
| Info |
|---|
|
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
|
| Chart from Table |
|---|
| tfc-width | 700 |
|---|
| tfc-height | 350 |
|---|
| column | Agent |
|---|
| datepattern | dd.mm.yy |
|---|
| aggregation | Answered TIckets |
|---|
| id | 1438704803153_646027804 |
|---|
| type | Pie |
|---|
| separator | Point (.) |
|---|
|
| 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 |
|
Sample Chart #2
| Info |
|---|
|
Try to alternate the view of the chart by switching among the following chart types: For the Row Labels and Values Column use only table columns containing numbers. |
| Chart from Table |
|---|
| tfc-width | 700 |
|---|
| tfc-height | 250 |
|---|
| column | Income‚Balance |
|---|
| datepattern | m/d/yy |
|---|
| aggregation | Spendings |
|---|
| id | 1441007490232_-1416480034 |
|---|
| type | Line |
|---|
| separator | Point (.) |
|---|
|
| 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
| Info |
|---|
|
Try to alternate the view of the chart by switching among the following chart types: Alternate the Values Column among the following table columns: |
| Chart from Table |
|---|
| tfc-width | 800 |
|---|
| tfc-height | 250 |
|---|
| column | Income‚Balance‚Spendings |
|---|
| datepattern | m/d/yy |
|---|
| aggregation | Date |
|---|
| id | 1441010024413_-1416480034 |
|---|
| type | Time Line |
|---|
| separator | Point (.) |
|---|
|
| 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
| Info |
|---|
|
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
|
...