Starting from version 3.0.0 Table Filter add-on allows you to generate charts based on values from your data tables. The add-on supports the following types of charts:
Chart Parameters
These parameters determine the procedure of chart generation on Confluence page. The set of parameters
Parameter | Default | Compatible with | Description |
---|
Row Labels | None | - Pie
- Donut
- 3D Donut
- Column
- Bar
- Line
- Area
| The column containing labels for data values. For the line chart, you should select the column containing numbers. For the Time Line and Time Area charts, you should select the column with dates. |
|
Values column | None | - Pie
- Donut
- 3D Donut
- Column
- Bar
- Line
- Area
- Time Line
- Time Area
| The column containing numerical values for chart generation. |
Dates column | None | | You can select the column with dates for chart generation. |
Date Format | yy-mm-dd | | You can specify the date format used in the column with dates. |
Type | Pie | Global | You can select the appropriate chart type. |
Decimal Separator | Point | Global | You can select the decimal separator (either point or comma). |
Height | None (dependable on screen area) | Global | You can define the height of the generated chart. |
Width | None (dependable on screen area) | Global | You can define the width of the generated chart. |
Hide the source table | Disabled | Global | You can hide the table with data and enable display of the chart only. |
Inserting Table chart macro
- Switch the Confluence page to the edit mode.
- Start entering {Table chart} and select the Table chart macro from the prompted context menu.
- Click Insert.
- The macro will be added to your page.
- Insert your table into the Table chart macro.
Configuring Table chart macro
- On the Confluence page opened in the edit mode, click the Table chart macro.
- Click Edit.
- In the Edit Table chart Macro form, define parameters of the macro.
- Click Save.
Using the Table charts
Once you have defined settings of the Table chart macro and saved the page, you get a page with the generated chart.
To the right side of your chart, you can locate the chart management sidebar. It allows you to alternate the following parameters of Chart table macro:
- Row Labels - change the column with labels for another one.
- Values column - change the column with data values. The chart will be automatically re-generated.
- Dates column - change the column with dates. The chart will be automatically re-generated. This select box is shown for Time Line and Time Area charts only.
- Chart Type - change the chart type for another one.
- Height/Width - specify the required dimensions of the chart.
To save new parameters in the macro body, click Save settings. To download the chart image, click .
Chart Examples
Pie chart
Parameters in Macro Browser | Data Table in Macro Placeholder | Rendered Chart |
---|
Row Labels | Customer |
---|
Values column | Tickets per Hour |
---|
Type | Pie |
---|
Decimal separator | Point (.) |
---|
Height | Default |
---|
Width | Default |
---|
| Customer | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour |
---|
Remy Deomampo | 4.6 | 5.1 | 4.2 | Rahul Dickstein | 4.8 | 1.6 | 1.3 | Radu Donahue | 6.4 | 5.6 | 1.5 | Preston Doorey | 4.7 | 1.3 | 1.6 | Phill Doyle | 2.0 | 3.4 | 2.7 |
| |
Donut / 3D Donut chart
Parameters in Macro Browser | Data Table in Macro Placeholder | Rendered Chart |
---|
Row Labels | Customer |
---|
Values column | Tickets per Hour |
---|
Type | Donut / 3D Donut |
---|
Decimal separator | Point (.) |
---|
Height | Default |
---|
Width | Default |
---|
| Customer | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour |
---|
Remy Deomampo | 4.6 | 5.1 | 4.2 | Rahul Dickstein | 4.8 | 1.6 | 1.3 | Radu Donahue | 6.4 | 5.6 | 1.5 | Preston Doorey | 4.7 | 1.3 | 1.6 | Phill Doyle | 2.0 | 3.4 | 2.7 |
| |
Line chart
Parameters in Macro Browser | Data Table in Macro Placeholder | Rendered Chart |
---|
Row Labels | Tickets per Hour |
---|
Values column | Average Time per Ticket (min) |
---|
Type | Line |
---|
Decimal separator | Point (.) |
---|
Height | 200 |
---|
Width | 400 |
---|
| Customer | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour |
---|
Remy Deomampo | 4.6 | 5.1 | 4.2 | Rahul Dickstein | 4.8 | 1.6 | 1.3 | Radu Donahue | 6.4 | 5.6 | 1.5 | Preston Doorey | 4.7 | 1.3 | 1.6 | Phill Doyle | 2.0 | 3.4 | 2.7 |
| |
Column chart
Parameters in Macro Browser | Data Table in Macro Placeholder | Rendered Chart |
---|
Row Labels | Agent |
---|
Values column | Average Time per Ticket (min) |
---|
Type | Column |
---|
Decimal separator | Point (.) |
---|
Height | 300 |
---|
Width | 400 |
---|
| Customer | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour |
---|
Remy Deomampo | 4.6 | 5.1 | 4.2 | Rahul Dickstein | 4.8 | 1.6 | 1.3 | Radu Donahue | 6.4 | 5.6 | 1.5 | Preston Doorey | 4.7 | 1.3 | 1.6 | Phill Doyle | 2.0 | 3.4 | 2.7 |
| |
Bar chart
Parameters in Macro Browser | Data Table in Macro Placeholder | Rendered Chart |
---|
Row Labels | Agent |
---|
Values column | Calls per Hour |
---|
Type | Bar |
---|
Decimal separator | Point (.) |
---|
Height | 300 |
---|
Width | 400 |
---|
| Customer | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour |
---|
Remy Deomampo | 4.6 | 5.1 | 4.2 | Rahul Dickstein | 4.8 | 1.6 | 1.3 | Radu Donahue | 6.4 | 5.6 | 1.5 | Preston Doorey | 4.7 | 1.3 | 1.6 | Phill Doyle | 2.0 | 3.4 | 2.7 |
| |
Area chart
Parameters in Macro Browser | Data Table in Macro Placeholder | Rendered Chart |
---|
Row Labels | Agent |
---|
Values column | Calls per Hour |
---|
Type | Bar |
---|
Decimal separator | Point (.) |
---|
Height | 300 |
---|
Width | 400 |
---|
| Customer | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour |
---|
Remy Deomampo | 4.6 | 5.1 | 4.2 | Rahul Dickstein | 4.8 | 1.6 | 1.3 | Radu Donahue | 6.4 | 5.6 | 1.5 | Preston Doorey | 4.7 | 1.3 | 1.6 | Phill Doyle | 2.0 | 3.4 | 2.7 |
| |
Time Line / Area chart
Parameters in Macro Browser | Data Table in Macro Placeholder | Rendered Chart |
---|
Row Labels | Agent |
---|
Dates column | Date |
---|
Type | Bar |
---|
Decimal separator | Point (.) |
---|
Date format | dd.mm.yy |
---|
Height | 300 |
---|
Width | 400 |
---|
| Date | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour |
---|
25.06.2015 | 7.3 | 3.2 | 3.3 | 26.06.2015 | 8.5 | 3.1 | 1.8 | 27.06.2015 | 5.0 | 3.7 | 4.5 | 28.06.2015 | 2.2 | 5.8 | 2.7 | 29.06.2015 | 2.0 | 3.4 | 2.7 |
| |