Versions Compared

Old Version 5

changes.mady.by.user StiltSoft

Saved on

compared with

New Version Current

changes.mady.by.user StiltSoft

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Chart from Table Chart is a macro bundled within Table Filter add-on, Charts & Spreadsheets app. It allows you to generate dynamically updated charts with a the capability to instantly switch between columns with different data values.

Parameters

The add-on adds the Table Chart 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:

Table of Contents
maxLevel3
minLevel2

Adding Simple Smart Charts

Hover over the table, click the Image Added icon on the top right corner of the table and select the Image Added option.

Select the chart type, select one of the charts suggested. To remove the chart, click the Image Added icon and select the Remove the macro option.

Try to build a chart based on the sample table below.

Expand
titleSee how to insert and remove a chart...

Image Added

AgentDateTickets per HourTicket Response (min)Calls per HourAnswered TIckets
Remy Dempo25.06.20207.33.23.389
Rahul Dickstein26.06.20208.53.11.895
Radu Donahue27.06.20205.03.74.565
Preston Doorey28.06.20202.25.82.728
Phill Doyle29.06.20203.95.22.937
ParameterParameter NameDefaultDescriptiontfc-widthWidth Width of the chart in pixels.tfc-heightHeight Height of the chart in pixels.columnRow labels / Dates column Name of the column containing data labels or dates.datepatternDate format Format of dates used in the table.aggregationValues column Name of the column containing data values.idIDAssigned automaticallyID of the chart.typeType Type of the chart to generate.separatorDecimal Separator Decimal separator used in data values.hideHide the source tableDisabledOption to hide the source table with data.hidecontrolsHide controlsDIsabledOption to hide the controls used to manage parameters of the Table Chart macro.

Chart Examples

Try to see Chart from Table Chart macro in action while working with the following chart examples.

Table of Contents
minLevel3

Sample Chart #1 - Pie/Donut, Column, Bar

...

Info
titleUse 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 Image Added 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.

Chart from Table
columnseparator
tfc-width700
columnAgent
aggregationAnswered TIckets
is3d
typePie
separatorPoint (.)
version2
colors#8eb021,#d04437,#3572b0,#f6c342,#654982
hidetrue
tfc-height350
Agentdatepatterndd.mm.yy
pieKeysRemy Dempo‚Rahul Dickstein‚Radu Donahue‚Preston Doorey‚Phill DoyleaggregationTickets per Hour
id1438704803153_646027804
typePie
Point (.)
AgentDateTickets per HourTicket Response (min)Calls per HourAnswered TIckets
Remy Dempo25.06.
2015
20207.33.23.389
Rahul Dickstein26.06.
2015
20208.53.11.895
Radu Donahue27.06.
2015
20205.03.74.565
Preston Doorey28.06.
2015
20202.25.82.728
Phill Doyle29.06.
2015
20203.95.22.937

Sample Chart #2 - Line/Area

...

Info
titleUse 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 Image Added 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.

Chart from Table
tfc-width700
hidetrue
tfc-height250
columnIncome‚BalanceSpendings
datepatternm/d/yy
aggregationSpendingsIncome‚Balance
id1441007490232_-1416480034
typeLine
separatorPoint (.)
version2
DateIncomeSpendingsBalance
8/1/
2015
20214366.504332.4334.07
8/2/
2015
20213369.004251.00-882.00
8/3/
2015
20214685.005212.57-527.57
8/4/
2015
20213284.252912.14372.11
8/5/
2015
20212892.754260.00-1367.25
8/6/
2015
20212833.383034.29-200.91
8/7/
2015
20213827.634318.00-490.38
8/8/
2015
20213936.385706.71-1770.34
8/9/
2015
20214804.383199.571604.80
8/10/
2015
20214325.384151.86173.52
8/11/
2015
20214884.133800.711083.41
8/12/
2015
20214265.383469.86795.52
8/13/
2015
20214737.253301.141436.11
8/14/
2015
20213201.754026.86-825.11
8/15/
2015
20214498.884910.00-411.13
8/16/
2015
20214823.883562.861261.02
8/17/
2015
20213833.634584.57-750.95
8/18/
2015
20212753.252933.71-180.46
8/19/
2015
20213685.254079.57-394.32
8/20/
2015
20214313.504852.71-539.21
8/21/
2015
20212726.255172.00-2445.75
8/22/
2015
20214849.254364.57484.68
8/23/
2015
20213778.505115.14-1336.64
8/24/
2015
20213225.503665.71-440.21
8/25/
2015
20214719.133601.571117.55
8/26/
2015
20213815.253517.00298.25
8/27/
2015
20214983.883913.861070.02
8/28/
2015
20214219.005315.14-1096.14
8/29/
2015
20213282.005555.86-2273.86
8/30/
2015
20213746.133921.57-175.45
8/31/
2015
20214939.504909.2930.21

Sample Chart #3 - Time Line/Area

Info
titleUse 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 Image Added 

...

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.

You can display the trendlines to better understand data movements over the entire time period.

...

Chart from Table
tfc-width800
tfc-heightdataorientation250Vertical
columnlegendIncome‚Balance‚Spendingsright
columnDatedatepatternm/d/yy
aggregationDateIncome‚Balance‚Spendings
alignCenterid1441010024413_-1416480034
typeTime Line
separatorPoint (.)
version2
colors#8eb021,#d04437,#3572b0
hidetrue
tfc-height250
trendlinetrue
datepatternm/d/yy
id1513330652085_1371528485
worklog5|8|w d h m
DateIncomeSpendingsBalance
8/1/
2015
20214366.504332.4334.07
8/2/
2015
20213369.004251.00-882.00
8/3/
2015
20214685.005212.57-527.57
8/4/
2015
20213284.252912.14372.11
8/5/
2015
20212892.754260.00-1367.25
8/6/
2015
20212833.383034.29-200.91
8/7/
2015
20213827.634318.00-490.38
8/8/
2015
20213936.385706.71-1770.34
8/9/
2015
20214804.383199.571604.80
8/10/
2015
20214325.384151.86173.52
8/11/
2015
20214884.133800.711083.41
8/12/
2015
20214265.383469.86795.52
8/13/
2015
20214737.253301.141436.11
8/14/
2015
20213201.754026.86-825.11
8/15/
2015
20214498.884910.00-411.13
8/16/
2015
20214823.883562.861261.02
8/17/
2015
20213833.634584.57-750.95
8/18/
2015
20212753.252933.71-180.46
8/19/
2015
20213685.254079.57-394.32
8/20/
2015
20214313.504852.71-539.21
8/21/
2015
20212726.255172.00-2445.75
8/22/
2015
20214849.254364.57484.68
8/23/
2015
20213778.505115.14-1336.64
8/24/
2015
20213225.503665.71-440.21
8/25/
2015
20214719.133601.571117.55
8/26/
2015
20213815.253517.00298.25
8/27/
2015
20214983.883913.861070.02
8/28/
2015
20214219.005315.14-1096.14
8/29/
2015
20213282.005555.86-2273.86
8/30/
2015
20213746.133921.57-175.45
8/31/
2015
20214939.504909.2930.21

Sample Chart #4 - Stacked Column/Bar

Info
titleUse Hint

Try to alternate the view of the chart by adding or removing columns with values for this stacked column chart:

  • Q1 2020
  • Q2 2020
  • Q3 2020
  • Q4 2020
  • Q1 2021
  • Q2 2021
  • Q3 2021
  • Q4 2021

Alternate the view of the chart by switching between the following chart types:

  • Stacked Column
  • Stacked Bar

You can use the Cogwheel Image Added 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.

Chart from Table
tfc-width500
hidetrue
tfc-height400
columnAdd-on
datepatternyy-mm-dd
aggregationQ1 2014‚Q2 2014‚Q3 2014‚Q4 2014
id1449569397567_-127502783
typeStacked Column
separatorPoint (.)
version2
Add-onQ1 2020Q2 2020Q3 2020Q4 2020Q1 2021Q2 2021Q3 2021Q4 2021
Table Filter139114145106106103148105
Smart Attachments5479696690965097
Awesome Graphs142128135195198179238192
Quizzes2048364233374629
Customer Case1510132518221719

Sample Chart #5 - Gantt

Info
titleUse Hint

You can build a Gantt chart to visualize project stages during the project planning and resource estimation.

Chart from Table
dataorientationVertical
legendright
columnTask Type‚Task Description‚Milestone‚Event
aggregationStart Date‚End Date‚Completion‚Date
alignCenter
typeGantt
separatorPoint (.)
version2
colors#8eb021,#7b6888,#69a6f9,#d04437,#0c6197,#a3acb2,#3572b0,#cc1010,#31383b,#f6c342,#e98125,#6ada6a,#654982,#e4a14b,#8cc3e9,#d8d23a,#65a620,#d8d23a,#f691b2,#2484c1
hidetrue
datepatternm/d/yy
pieKeysAnalysis‚Analysis - Done‚Analysis - Todo‚Design‚Design - Done‚Design - Todo‚Development‚Development - Done‚Development - Todo‚Testing‚Testing - Done‚Testing - Todo‚Deployment‚Deployment - Done‚Deployment - Todo‚RC1‚RC2‚Today‚Meeting with Stakeholders‚Payment
id1513330486549_-1286331324
worklog7|10|h
Task TypeTask DescriptionStart DateEnd DateCompletion
AnalysisOnsite Meetings8/1/20208/7/2020100%
AnalysisDiscussions with Stakeholders8/8/20208/20/2020100%
Analysis

Documenting Requirements

8/15/20208/25/202095%
AnalysisCreation of Mockups8/21/20209/7/202095%
AnalysisVerification of Requirements9/5/20209/15/202050%
DesignDesign Database9/15/20209/25/20200%
DesignSoftware Design9/26/202010/1/20200%
DesignInterface Design10/5/202010/15/20200%
DesignCreate Design Specifications10/17/202010/25/20200%
DesignVerification of Design Specifications10/28/202011/7/20200%
DevelopmentDevelopment of System Modules10/16/202012/31/20200%
Development

Integration of System Modules

1/1/20211/15/20210%
DevelopmentInitial Testing of System Modules1/17/20211/31/20210%
DevelopmentDeployment to Test Environment2/1/20212/5/20210%
TestingSystem Testing1/20/20212/8/20210%
TestingPenetration Testing2/10/20212/15/20210%
TestingPerformance Testing2/17/20212/20/20210%
TestingTracking Found Issues2/18/20212/25/20210%
TestingFixing Found Issues2/21/20212/28/20210%
DeploymentData Migration3/1/20213/4/20210%
DeploymentSystem Integration3/5/20213/9/20210%
DeploymentSystem Monitoring3/10/20213/31/20210%
Task TypeMilestoneDate
DevelopmentRC1

1/25/2021

DevelopmentRC22/3/2021

Event

Date

Todaytoday
Meeting with Stakeholders10/5/2020
Payment3/15/2021