Page History

Mybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:

Panel

bgColor	white
titleBGColor	#f5f5f5
title	Managing Dynamic Charts from Table Data

The Table Filter and Charts for Confluence app allows you to visualize your table data and create dynamic charts 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, bubble pie, column, bar, Gantt, line, area, time line, time area and other). Optionally, you can configure your chart according to your use case.

Table of Contents

maxLevel	2

Widget Connector

width	432
url	https://www.youtube.com/watch?v=eiVywX8Hmp4
height	243

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.

Expand

title	Click here to expand the available parameters of the Chart from Table macro...

Parameter	Default	Compatible with	Description
Labels Column	None	Pie Donut 3D Donut Column (Stacked) Bar (Stacked) Gantt	The column containing labels for data values.
Values column	None	Pie Donut 3D Donut Column (Stacked) Bar (Stacked) Bubble Pie Time Line Time Area Stacked Time Area Gantt	The column containing numerical values for chart generation.
X-axis value column	None	Line Area Stacked Area Bubble Pie	The column containing numerical values for chart generation.
Y-axis value column	None	Line Area Stacked Area Bubble Pie	The column or columns containing numerical values for chart generation.
Dates column	None	Time Line Time Area Stacked Time Area	You can select the column with dates for chart generation.
Date Format	yy-mm-dd	Time Line Time Area Stacked Time Area Gantt Bubble Pie	You can specify the date format used in the column with dates.
Type	Pie	Global	You can select the appropriate chart type.
3D	Disabled	Pie Donut Column (Stacked) Bar (Stacked)	You can select the display of the chart in 3D view.
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.
Hide chart controls	Disabled	Global	You can hide the chart controls when you need just to display the chart without a necessity to update its view.
Show grid	Enabled

Panel

bgColor	white
titleBGColor	#f5f5f5
title	Managing Dynamic Charts from Table Data

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, time 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.

Table of Contents

maxLevel	2

Widget Connector

width	432
url	https://www.youtube.com/watch?v=eiVywX8Hmp4
height	243

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.

Expand

title	Click here to expand the available parameters of the Chart from Table macro...

Parameter

Default

Compatible with

Description

Labels Column

None

Pie
Donut
3D Donut
Column (Stacked)
Bar (Stacked)

The column containing labels for data values.

Values column

None

Pie
Donut
3D Donut
Column (Stacked)
Bar (Stacked)
Time Line
Time Area

The column containing numerical values for chart generation.

X-axis value column

None

Line
Area

The column containing numerical values for chart generation.

Y-axis value column

None

Line
Area

The column or columns containing numerical values for chart generation.

Dates column

None

Time Line
Time Area

You can select the column with dates for chart generation.

Date Format

yy-mm-dd

Time Line
Time Area

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.

Hide chart controls

Disabled

Global

You can hide the chart controls when you need just to display the chart without a necessity to update its view.

Show legend

Disabled

Global

You can hide the legend for the generated chart.

Show grid

Enabled

Line
Area
Time Line
Time Area

You can enabled display of the grid on the generated chart.

Chart Title

Disabled

Global

You can specify the title of the chart.

Align chart

Enabled

Center

You can define the appropriate alignment for the chart.

X-axis label

Disabled

Global

You can specify the label for X axis of the chart.

Y-axis label

Disabled

Global

You can specify the label for Y axis of the chart.

Minimal Value

Disabled

Column
Bar
Stacked Column
Stacked Bar

You can specify the minimal value for showing only data values greater than the specified minimal value.

Maximal Value

Disabled

Column
Bar
Stacked Column
Stacked Bar

You can specify the maximal value for showing only data values not greater than the specified maximal value.

Scale Step

Disabled

Column
Bar
Stacked Column
Stacked Bar

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

Stacked Time Area Bubble Pie	You can enabled display of the grid on the generated chart.
Chart Title	Disabled	Global

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.

Inserting Chart from Table macro

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

Macro Insertion

Instructions

Supported Data

Inserting the macro through the action icon on the editor pane

Switch Confluence page to the edit mode.
Position the mouse pointer within the table.
Image Removed
On the editor pane, click the Create a chart from table Image Removedicon.

Info
This option is available in Confluence Server only.

Manually created and copied tables

Manual entry of the {Chart from Table} query on the page

Switch Confluence page to the edit mode.
Position the mouse pointer in the appropriate place on the page.
Start entering {Chart from Table}.
From the prompted list of macro choices, select Chart from Table.
Image Removed

Manually created and copied tables
Macros outputting table data

Selection of the Chart from Table macro in the Select Macro form

Switch Confluence page to the edit mode.
Position the mouse pointer in the appropriate place on the page.
On the editor pane, click Insert.
In the Select Macro form, locate the Chart from Table macro and insert it on the page.
Image Removed
Place the table within the macro.

Manually created and copied tables
Macros outputting table data

Selecting the chart type and data series

On the Confluence page opened in the edit mode, click the Chart from Table macro.
Click Edit.
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.
Click Save.

Info
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.

Image Removed

Configuring look of the chart

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

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

Image Removed

Adjusting chart configuration

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

Image Removed

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.

Info
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:

Click the Cogwheel Image Removed icon.
Select Save changes.

To export the chart:

Click the Cogwheel Image Removed icon.
Select Export to PDF or Export to Word.

To save the chart as image:

Click the Cogwheel Image Removed icon.
Select Chart as image.

To update the colors used for charts and graphs:

Click the Cogwheel Image Removed icon.
Click Select colors.
Click the color picker and select the appropriate color on the palette.
Click Apply to use the selected colors and redraw your chart or graph.

To show the source table:

Click the Cogwheel Image Removed icon.
Select Show source table.

Image Removed

Removing Chart from Table macro for Table

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

Image Removed

title of the chart.
Show data labels	Percentage	Pie Donut Column Bar Stacked Column Stacked Bar Bubble Pie	You can specify the way to show data labels (none, value, percentage, value (percentage), percentage (value)).
Align chart	Enabled	Center	You can define the appropriate alignment for the chart.
X-axis label	Disabled	Global	You can specify the label for X axis of the chart.
Y-axis label	Disabled	Global	You can specify the label for Y axis of the chart.
Minimal Value	Disabled	Column Bar Stacked Column Stacked Bar Gantt Bubble Pie	You can specify the minimal value for showing only data values greater than the specified minimal value.
Maximal Value	Disabled	Column Bar Stacked Column Stacked Bar Gantt Bubble Pie	You can specify the maximal value for showing only data values not greater than the specified maximal value.
Scale Step	Disabled	Column Bar Stacked Column Stacked Bar Gantt Bubble Pie	You can specify the required scale step for showing the chart.
Minimal X Value		Line Area Stacked Area Time Line Time Area Stacked Time Area Bubble Pie	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 Stacked Area Time Line Time Area Stacked Time Area Bubble Pie	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 Stacked Area Time Line Time Area Stacked 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 Stacked Area Time Line Time Area Stacked 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 Stacked Area Time Line Time Area Stacked Time Area Bubble Pie	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 Stacked Area Time Line Time Area Stacked Time Area	You can specify the required scale step of Y axis for showing the chart.
Logarithmic scale Y	Disabled	Line Area Stacked 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 X	Disabled	Line Area Stacked Area	You can enable this option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
Select colors		Global	You can select the appropriate colors for charts and graphs instead of using the automatically assigned colors.
Line settings	Solid 1.5 px	Line Time Line	You can select the line type (solid, dash, dot) and set its width for each line in your charts.
Logarithmic Scale	Disabled	Column (Stacked) Bar (Stacked) Time Line Time Area Stacked 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.
Interpolation	Linear Step Natural cubic Monotone X cubic Monotone Y cubic Cubic Catmull-Rom Cubic cardinal Cubic basis Straightened cubic basis	Line Area Stacked Area Time Line Time Area Stacked Time Area	You can select the interpolation method for each line in your charts.
Table Data Orientation	Vertical	Global	You can define the appropriate orientation of values in your data table.
Show inner labels	Enabled	Pie Bar Column Stacked Column Stacked Bar	You can enable or disable display of data values (including percents) on the charts.
Legend position	Right	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 trendline	Disabled	Line Area Stacked Area Time Line Time Area Stacked Time Area Column Stacked Column Bar Stacked Bar	You can enable display of the trend line for each label of your chart.
Days in week	5	Global	You can enter the number of business days in a week.
Hours in day	8	Global	You can enter the number of working hours in one business day.
Output format	w d h m	Global	You can select the appropriate output format for worklog values.

Inserting Chart from Table macro

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

Macro Insertion

Instructions

Supported Data

Inserting the macro in the page view mode

Info
You can disable the inline macro insertion on a global or individual basis.

Open a page with a table.
Hove over the table.
Click the Create a chart from data series Image Added icon on the panel that appears to the right side of the table.

Image Added

Info
This option is available in Confluence Server only.

Manually created and copied tables
Macros outputting table data

Inserting the macro through the action icon on the editor pane

Switch Confluence page to the edit mode.
Position the mouse pointer within the table.
Image Added
On the editor pane, click the Create a chart from table Image Added icon.

Info
This option is available in Confluence Server only.

Manually created and copied tables

Manual entry of the {Chart from Table} query on the page

Switch Confluence page to the edit mode.
Position the mouse pointer in the appropriate place on the page.
Start entering {Chart from Table}.
From the prompted list of macro choices, select Chart from Table.
Image Added

Manually created and copied tables
Macros outputting table data

Selection of the Chart from Table macro in the Select Macro form

Switch Confluence page to the edit mode.
Position the mouse pointer in the appropriate place on the page.
On the editor pane, click Insert.
In the Select Macro form, locate the Chart from Table macro and insert it on the page.
Image Added
Place the table within the macro.

Manually created and copied tables
Macros outputting table data

Selecting the chart type and data series

On the Confluence page opened in the edit mode, click the Chart from Table macro.
Click Edit.
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.
Click Save.

Info
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.

Image Added

Configuring look of the chart

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

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

To set the chart dimensions:

Locate the Height and Width fields.
Enter the appropriate dimensions of the chart.

To set colors for chart elements (labels):

Locate the Select colors button and click it.
Select the appropriate colors for each label.

To set the chart alignment:

Locate the Align chart option.
Select the appropriate chart alignment, as follows:
- Left
- Center
- Right

To show the chart legend:

Locate the Legend Position option.
Select the appropriate legend position, as follows:
- None
- Right
- Bottom

Image Added

Adjusting chart configuration

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

To set the date format:

Locate the Date format option.
Specify the correct date format for date values in the source table.

To show the trendline:

Locate and enable the Show trendline option.

Info
The trendline can be displayed for the line/area and date line/area charts only.

Image Added

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.

Info
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:

Click the Cogwheel Image Added icon.
Select Save changes.

To export the chart:

Click the Cogwheel Image Added icon.
Select Export to PDF or Export to Word.

To save the chart as image:

Click the Cogwheel Image Added icon.
Select Chart as image.

To update the colors used for charts and graphs:

Click the Cogwheel Image Added icon.
Click Select colors.
Click the color picker and select the appropriate color on the palette.
Click Apply to use the selected colors and redraw your chart or graph.

To show the source table:

Click the Cogwheel Image Added icon.
Select Show source table.

To set the date format:

From 3.12.0 version, the Table Filter and Charts app allows you to set the correct date format in the page view mode. If the app detects the incorrect date format it presents you with the note panel where you can enter the correct date format. It is saved automatically if it is treated as the correct date format.

Image Added

Removing Chart from Table macro for Table

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

Image Added

Copying a table into Chart from Table macro

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

Info
You can also use the Table Excerpt and Table Excerpt Include macros for building multiple charts on the basis of a single source table.

Image Added

Zooming in Chart

Open the page with the chart you want to zoom in.
Hover your mouse pointer over this chart.
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:

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

To zoom out the chart:

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

To scale up values along chart axes:

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

To navigate across the chart:

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

Image Added

Filtering the source table

Select one or more chart columns/sectors/bars.
Only the related rows of the source table are displayed.
Deselect all the columns/sectors/bars to display the whole source table.

Image Added

Setting worklog settings

Excerpt Include

	Managing Filtration Parameters
	Managing Filtration Parameters
nopanel	true

Image Added

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 Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Agent
Values column	Tickets per Hour
Type	Pie
Decimal separator	Point (.)
Height	Default
Width	Default

Agent	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

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

Image Added

Donut / 3D Donut chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Agent
Values column	Tickets per Hour
Type	Donut / 3D Donut
Decimal separator	Point (.)
Height	Default
Width	Default

Agent	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

Image Added

Line chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Tickets per Hour
Values column	Average Time per Ticket (min)
Type	Line
Decimal separator	Point (.)
Height	200
Width	400

Agent	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

Image Added

Column chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Column
Height	300
Width	600

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Image Added

Stacked Column chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Stacked Column
Height	300
Width	600

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Image Added

Bar chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Bar
Height	300
Width	400

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Image Added

Stacked Bar chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Stacked Bar
Height	300
Width	600

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Image Added

Bubble Pie chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

X-axis and Y-axis columns	Date Total requests
Values column	Bugs Improvements Tasks New features
Type	Bubble Pie
Height	600
Width	1000

Date	Total requests	Bugs	Improvements	Tasks	New features
Jan 2019	89	18	19	24	28
Feb 2019	132	24	38	23	47
Mar 2019	93	25	36	23	9
Apr 2019	103	15	28	23	37
May 2019	87	16	35	26	10
June 2019	133	29	31	40	33
Jul 2019	76	12	4	10	50

Image Added

Area chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Columns label	Tickets per Hours
Values column	Calls per Hour
Type	Area
Decimal separator	Point (.)
Height	300
Width	400

Agent	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

Image Added

Time Line / Time Area

Chart Examples

Pie

chart

Parameters in Macro Browser	Data Table in Macro Placeholder	Rendered Chart

Columns labelAgent

Values Column	Average Time per Ticket (min)
Dates column	Date

Values columnTickets per Hour

Type

Pie

Height
Bar
Decimal separator	Point (.)
Date format	dd.mm.yy

Default

Width
300

Default

400

Agent

Date	Tickets per Hour	Average Time per Ticket (min)	Calls per Hour

Remy Deomampo4.65.14.2Rahul Dickstein4.81.61.3Radu Donahue6.45.61.5Preston Doorey4.71.31.6Phill Doyle

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

Image Removed

Donut / 3D Donut chart

Image Added