Table Filter for Confluence add-on allows you to visualize your table data and create dynamic charts that you can configure and update on the fly while viewing Confluence pages. You can select the column containing labels and set one or multiple columns containing number values used for chart creation. Additionally, you can select the appropriate chart or graph type ( pie, donut and 3D donut, column, bar, line, area, t ime line and time area). Optionally, you can set the decimal separator, specify the dimensions of the chart, and enable the hiding of the source table. You can modify settings of your charts and save modifications in the macro body while viewing the page.

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.

ParameterDefaultCompatible withDescription
Labels ColumnNone
  • Pie
  • Donut
  • 3D Donut
  • Column (Stacked)
  • Bar (Stacked)
  • Gantt

The column containing labels for data values.

Values columnNone
  • Pie
  • Donut
  • 3D Donut
  • Column (Stacked)
  • Bar (Stacked)
  • Time Line
  • Time Area
  • Gantt

The column containing numerical values for chart generation.

X-axis value columnNone
  • Line
  • Area
The column containing numerical values for chart generation.
Y-axis value columnNone
  • Line
  • Area
The column or columns containing numerical values for chart generation.
Dates columnNone
  • Time Line
  • Time Area
You can select the column with dates for chart generation.
Date Formatyy-mm-dd
  • Time Line
  • Time Area
  • Gantt
You can specify the date format used in the column with dates.
TypePieGlobalYou can select the appropriate chart type.
Decimal SeparatorPointGlobalYou can select the decimal separator (either point or comma).
Height

None

(dependable on screen area)

GlobalYou can define the height of the generated chart.
Width

None

(dependable on screen area)

GlobalYou can define the width of the generated chart.
Hide the source tableDisabledGlobalYou can hide the table with data and enable display of the chart only.
Hide chart controlsDisabledGlobalYou can hide the chart controls when you need just to display the chart without a necessity to update its view.
Show legendNone
  • None
  • To the right of the chart
  • Under the chart
You can hide the legend for the generated chart or regulate the position for its showing.
Show gridEnabled
  • Line
  • Area
  • Time Line
  • Time Area
You can enabled display of the grid on the generated chart.
Chart TitleDisabledGlobalYou can specify the title of the chart.
Align chartEnabledCenterYou can define the appropriate alignment for the chart.
X-axis labelDisabledGlobalYou can specify the label for X axis of the chart.
Y-axis labelDisabledGlobalYou can specify the label for Y axis of the chart.
Minimal ValueDisabled
  • Column
  • Bar
  • Stacked Column
  • Stacked Bar
  • Gantt
You can specify the minimal value for showing only data values greater than the specified minimal value.
Maximal ValueDisabled
  • Column
  • Bar
  • Stacked Column
  • Stacked Bar
  • Gantt
You can specify the maximal value for showing only data values not greater than the specified maximal value.
Scale StepDisabled
  • Column
  • Bar
  • Stacked Column
  • Stacked Bar
  • Gantt
You can specify the required scale step for showing the chart.

Minimal X Value

 
  • Line
  • Area
  • Time Line
  • Time Area
You can specify the minimal value for X axis for showing only data values greater than the specified minimal value.
Maximal X Value  
  • Line
  • Area
  • Time Line
  • Time Area
You can specify the maximal value for X axis for showing only data values not greater than the specified maximal value.
Minimal Y Value  
  • Line
  • Area
  • Time Line
  • Time Area
You can specify the minimal value for Y axis for showing only data values greater than the specified minimal value.
Maximal Y Value  
  • Line
  • Area
  • Time Line
  • Time Area
You can specify the maximal value for Y axis for showing only data values not greater than the specified maximal value.
Scale X Step 
  • Line
  • Area
  • Time Line
  • Time Area

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:

  • 10d = 10 days as a scale step
  • 1m = 1 month as a scale step
  • 2y = 2 years as a scale step
Scale Y Step  
  • Line
  • Area
  • Time Line
  • Time Area
You can specify the required scale step of Y axis for showing the chart.
Logarithmic scale YDisabled
  • Line
  • Area
You can enable this option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
Logarithmic scale XDisabled
  • Line
  • Area
You can enable this option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
Colors GlobalYou can select the appropriate colors for charts and graphs instead of using the automatically assigned colors.
Logarithmic ScaleDisabled
  • Column (Stacked)
  • Bar (Stacked)
  • Time Line
  • Time Area
You can enable this option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
Table Data OrientationVerticalGlobalYou can define the appropriate orientation of values in your data table.
Show inner labelsEnabled
  • Pie
  • Bar
  • Column
  • Stacked Column
  • Stacked Bar
You can enable or disable display of data values (including percents) on the charts.
Show legendTo the right of the graph
  • Bar
  • Column
  • Stacked Column
  • Stacked Bar
You can regulate the position of showing the legend for a specific chart. You can also hide the legend or show it below the chart.
Show trend lineDisabled
  • Line
  • Area
  • Time Line
  • Time Area
You can enable display of the trend line for each label of your chart.


Inserting Chart from Table macro

There exist three ways to insert the Chart from Table macro on the page.

Macro InsertionInstructionsSupported Data
 Inserting the macro through the action icon on the editor pane
  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer within the table.
  3. On the editor pane, click the Create a chart from table icon.

This option is available in Confluence Server only.

  •  Manually created and copied tables
Manual entry of the {Chart from Table} query on the page
  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer in the appropriate place on the page.
  3. Start entering {Chart from Table}.
  4. From the prompted list of macro choices, select Chart from Table.
  • Manually created and copied tables
  • Macros outputting table data
Selection of the Chart from Table macro in the Select Macro form
  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer in the appropriate place on the page.
  3. On the editor pane, click Insert.
  4. In the Select Macro form, locate the Chart from Table macro and insert it on the page.
  5. Place the table within the macro.
  • Manually created and copied tables
  • Macros outputting table data


 

 

Selecting the chart type and data series

  1. On the Confluence page opened in the edit mode, click the Chart from Table macro.
  2. Click Edit.
  3. In the Insert/Edit Charts from Table Macro form, define parameters of the macro, as follows:
    • Labels / Dates / X-axis value column - select the appropriate column containing the required data for chart generation. The name of the parameter, as well as data type may vary for different chart types.
    • Values column - select the column containing numbering values for chart generation.
    • Type - select the type of chart to generate.
  4. Click Save.
  • For the line and area charts, you will have to select the columns with numbers through the X-axis value column and Y-axis value column dropdown boxes.
  • For the time line and time area charts, you will have to select the columns with dates through the Dates column dropdown box.

 

 

Configuring look of the chart

  1. On the Confluence page opened in the edit mode, click the Chart from Table macro.
  2. Click Edit.
  3. Switch to the Look tab.
  4. Configure the parameters affecting the look of chart.
  5. Click Save.
  6. Save the page.

For the details on the list of all available parameters, see this.

 

 

Adjusting chart configuration

  1. On the Confluence page opened in the edit mode, click the Chart from Table macro.
  2. Click Edit.
  3. Switch to the Adjustments tab.
  4. Adjust the parameters affecting presentation of data series.
  5. Click Save.
  6. Save the page.

 

 

Managing Charts in the Page View Mode

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:

  • Labels column - change the column with labels for another one. 
  • Values column - change the column with data values. The chart will be automatically re-generated. Depending on the used chart type you may select column with numerical through Values column X and Values column Y fields.
  • 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.
  • Type - change the chart type for another one. You may need to re-select the table columns when changing the chart type.
  • Height/Width - specify the required dimensions of the chart.
  • For the line and area charts, you will have to select the columns with numbers through the X-axis value column and Y-axis value column dropdown boxes.
  • For the time line and time area charts, you will have to select the columns with dates through the Dates column dropdown box.

To save new parameters in the macro body:

  1. Click the Cogwheel  icon.
  2. Select Save changes.

To export the chart:

  1. Click the Cogwheel   icon.
  2. Select  Export to PDF  or  Export to Word.

To save the chart as image:

  1. Click the Cogwheel  icon.
  2. Select Chart as image.

To update the colors used for charts and graphs:

  1. Click the Cogwheel  icon.
  2. Click Select colors.
  3. Click the color picker and select the appropriate color on the palette. 
  4. Click Apply to use the selected colors and redraw your chart or graph.

To show the source table:

  1. Click the Cogwheel  icon.
  2. Select Show source table.

 

 

Removing Chart from Table macro for Table

  1. Switch Confluence page to the edit mode.
  2. Select the Chart from Table macro with the table or macro outputting the table.
  3. Click Unwrap.

 

 

Copying a table into Chart from Table macro

  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer into any cell of the table you want to copy.
  3. Click the Copy Table  icon on the editor pane.
  4. Paste the table into the Chart from Table macro on the same or on a new page.

You can also use the Table Excerpt and Table Excerpt Include macros for using the same table for different objectives.

 

 

Zooming in Chart

  1. Open the page with the chart you want to zoom in.
  2. Hover your mouse pointer over this chart.
  3. Hold down Ctrl and rotate the wheel button forward to zoom in the chart.

You can also do the following:

To zoom in over the desired chart area:

  1. Click and hold the left mouse button.
  2. Drag the mouse pointer down and right over the chart.

To zoom out the chart:

  1. Click and hold down the left mouse button.
  2. Drag the mouse pointer left over the chart.

To scale up values along chart axes:

  1. Hold down Shift and drag the mouse pointer left or right. (for X axis)
  2. Hold down Shift and drag the mouse pointer upwards or downwards. (for Y axis)

To navigate across the chart:

  1. Hold down Ctrl (for Windows) or Alt (for MacOS) and drag the mouse pointer across the chart.

 

 

Chart Examples

Below you can find examples of chart configuration and data series used to generate a specific chart type.

Pie chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelAgent
Values columnTickets per Hour
TypePie
Decimal separatorPoint (.)
HeightDefault
WidthDefault
AgentTickets per HourAverage Time per Ticket (min)Calls per Hour
Remy Deomampo4.65.14.2
Rahul Dickstein4.81.61.3
Radu Donahue6.45.61.5
Preston Doorey4.71.31.6
Phill Doyle2.03.42.7

You can select multiple table columns for building multiple pie charts at once on the basis of a single table.

Donut / 3D Donut chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelAgent
Values columnTickets per Hour
TypeDonut / 3D Donut
Decimal separatorPoint (.)
HeightDefault
WidthDefault
AgentTickets per HourAverage Time per Ticket (min)Calls per Hour
Remy Deomampo4.65.14.2
Rahul Dickstein4.81.61.3
Radu Donahue6.45.61.5
Preston Doorey4.71.31.6
Phill Doyle2.03.42.7

 

 

Line chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelTickets per Hour
Values columnAverage Time per Ticket (min)
TypeLine
Decimal separatorPoint (.)
Height200
Width

400

AgentTickets per HourAverage Time per Ticket (min)Calls per Hour
Remy Deomampo4.65.14.2
Rahul Dickstein4.81.61.3
Radu Donahue6.45.61.5
Preston Doorey4.71.31.6
Phill Doyle2.03.42.7

 

 

 

Column chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelPeriod
Values column
  • Opened Tickets
  • Pending Tickets
  • Successfully Closed Tickets
  • Tickets Closed w/o Response
  • Unsuccessfully Closed Tickets
  • Total Tickets
TypeColumn
Height300
Width600
PeriodOpened TicketsPending TicketsSuccessfully Closed TicketsTickets Closed w/o ResponseUnsuccessfully Closed TicketsTotal Tickets
Q1 2015207423812014664
Q2 2015278312475839653
Q3 2015227272002331508
Q4 2015257202375840612

Stacked Column chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelPeriod
Values column
  • Opened Tickets
  • Pending Tickets
  • Successfully Closed Tickets
  • Tickets Closed w/o Response
  • Unsuccessfully Closed Tickets
  • Total Tickets
TypeStacked Column
Height300
Width

600

 

 

PeriodOpened TicketsPending TicketsSuccessfully Closed TicketsTickets Closed w/o ResponseUnsuccessfully Closed TicketsTotal Tickets
Q1 2015207423812014664
Q2 2015278312475839653
Q3 2015227272002331508
Q4 2015257202375840612

Bar chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelPeriod
Values column
  • Opened Tickets
  • Pending Tickets
  • Successfully Closed Tickets
  • Tickets Closed w/o Response
  • Unsuccessfully Closed Tickets
  • Total Tickets
TypeBar
Height300
Width400
PeriodOpened TicketsPending TicketsSuccessfully Closed TicketsTickets Closed w/o ResponseUnsuccessfully Closed TicketsTotal Tickets
Q1 2015207423812014664
Q2 2015278312475839653
Q3 2015227272002331508
Q4 2015257202375840612

 

 

Stacked Bar chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelPeriod
Values column
  • Opened Tickets
  • Pending Tickets
  • Successfully Closed Tickets
  • Tickets Closed w/o Response
  • Unsuccessfully Closed Tickets
  • Total Tickets
TypeStacked Bar
Height300
Width

600

PeriodOpened TicketsPending TicketsSuccessfully Closed TicketsTickets Closed w/o ResponseUnsuccessfully Closed TicketsTotal Tickets
Q1 2015207423812014664
Q2 2015278312475839653
Q3 2015227272002331508
Q4 2015257202375840612

Area chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Columns labelTickets per Hours
Values columnCalls per Hour
TypeArea
Decimal separatorPoint (.)
Height300
Width400
AgentTickets per HourAverage Time per Ticket (min)Calls per Hour
Remy Deomampo4.65.14.2
Rahul Dickstein4.81.61.3
Radu Donahue6.45.61.5
Preston Doorey4.71.31.6
Phill Doyle2.03.42.7

 

 

Time Line / Time Area chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Values ColumnAverage Time per Ticket (min)
Dates columnDate
TypeBar
Decimal separatorPoint (.)
Date formatdd.mm.yy
Height300
Width400
DateTickets per HourAverage Time per Ticket (min)Calls per Hour
25.06.20157.33.23.3
26.06.20158.53.11.8
27.06.20155.03.74.5
28.06.20152.25.82.7
29.06.20152.03.42.7

 

 

Line / Area chart (Logarithmic scale)

Instead of using the default arithmetic scale, you can use the logarithmic scale that is convenient for too large or too small numbers.

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
X-axis value columnTemperature (Celcium degree)
Y-axis value columnEvaporation heat, Joule/kg
TypeLine
Logarithmic scale YEnabled
Temperature (Celcium degree)Evaporation heat, Joule/kg
0.52.500E+6
75.42.322E+6
142.92.137E+6
200.41.930E+6
270.01.605E+6
3500.893E+6
374.150.001E+6

Gantt chart

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Labels columnAddon Name
Values column
  • Start Date
  • End Date
  • Completion Ratio
TypeGantt
Scale Step1m
Date Formatd-M-y
TitleAddon NameStart DateEnd DateCompletion Ratio
Sprint - Quiz Results Report + Mobile UIQuizzes18-Sep-1631-Sep-1695%
Sprint - Question Management ImprovementsQuizzes4-Sep-1615-Sep-1690%
Sprint - Handy Task ReportHandy Macros4-Sep-1615-Sep-1681%
Sprint - Handy Task ListHandy Macros21-Aug-161-Sep-1680%
Sprint - Handy CarouselHandy Macros7-Aug-1618-Aug-1697%
Sprint - Functions and CalculationsTable Filter and Charts17-Jul-1611-Aug-16100%
Sprint - Comparison of Tables for DuplicatesTable Filter and Charts14-Aug-1625-Aug-1693%
Sprint - Cell Value Indicator and If AnalyzerTable Filter and Charts18-Sep-1629-Sep-1695%
Sprint - Cell Consolidation and Table MergingTable Filter and Charts15-Sep-1615-Sep-1688%

Time Line chart with Trend

Parameters in Macro BrowserData Table in Macro PlaceholderRendered Chart
Dates ColumnAdd-on
Values Column
  • Table Filter and Charts
  • Smart Attachments
  • Quizzes
  • Awesome Graphs
  • TeamCity Integration
TypeTime Line
Date FormatM-y
Show trend lineEnabled
Add-onTable Filter and ChartsSmart AttachmentsQuizzesAwesome GraphsTeamCity Integration
Jan-16216247348
Feb-16155979551
Mar-16142140141
Apr-16194663482
May-16203850386
Jun-16105666582
Jul-162430591064
Aug-16102149480
Sep-16203341862
Oct-16541481041
Nov-1672652655
Dec-1694170651