Versions Compared

Old Version 29

changes.mady.by.user StiltSoft

Saved on

compared with

New Version 30

changes.mady.by.user StiltSoft

Saved on

Key

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

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

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 play with the sample table below.

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


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

Chart Examples

Try to see Chart from Table 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 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
columnAgent
aggregationAnswered TIckets
is3d
typePie
separatorPoint (.)
version2
colors#8eb021,#d04437,#3572b0,#f6c342,#654982
hidetrue
tfc-height350
datepatterndd.mm.yy
pieKeysRemy Dempo‚Rahul Dickstein‚Radu Donahue‚Preston Doorey‚Phill Doyle
id1438704803153_646027804
AgentDateTickets per HourTicket Response (min)Calls per HourAnswered TIckets
Remy Dempo25.06.201520207.33.23.389
Rahul Dickstein26.06.201520208.53.11.895
Radu Donahue27.06.201520205.03.74.565
Preston Doorey28.06.201520202.25.82.728
Phill Doyle29.06.201520203.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 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
columnSpendings
datepatternm/d/yy
aggregationIncome‚Balance
id1441007490232_-1416480034
typeLine
separatorPoint (.)
version2
DateIncomeSpendingsBalance
8/1/201520214366.504332.4334.07
8/2/201520213369.004251.00-882.00
8/3/201520214685.005212.57-527.57
8/4/201520213284.252912.14372.11
8/5/201520212892.754260.00-1367.25
8/6/201520212833.383034.29-200.91
8/7/201520213827.634318.00-490.38
8/8/201520213936.385706.71-1770.34
8/9/201520214804.383199.571604.80
8/10/201520214325.384151.86173.52
8/11/201520214884.133800.711083.41
8/12/201520214265.383469.86795.52
8/13/201520214737.253301.141436.11
8/14/201520213201.754026.86-825.11
8/15/201520214498.884910.00-411.13
8/16/201520214823.883562.861261.02
8/17/201520213833.634584.57-750.95
8/18/201520212753.252933.71-180.46
8/19/201520213685.254079.57-394.32
8/20/201520214313.504852.71-539.21
8/21/201520212726.255172.00-2445.75
8/22/201520214849.254364.57484.68
8/23/201520213778.505115.14-1336.64
8/24/201520213225.503665.71-440.21
8/25/201520214719.133601.571117.55
8/26/201520213815.253517.00298.25
8/27/201520214983.883913.861070.02
8/28/201520214219.005315.14-1096.14
8/29/201520213282.005555.86-2273.86
8/30/201520213746.133921.57-175.45
8/31/201520214939.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 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
dataorientationVertical
legendright
columnDate
aggregationIncome‚Balance‚Spendings
alignCenter
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/201520214366.504332.4334.07
8/2/201520213369.004251.00-882.00
8/3/201520214685.005212.57-527.57
8/4/201520213284.252912.14372.11
8/5/201520212892.754260.00-1367.25
8/6/201520212833.383034.29-200.91
8/7/201520213827.634318.00-490.38
8/8/201520213936.385706.71-1770.34
8/9/201520214804.383199.571604.80
8/10/201520214325.384151.86173.52
8/11/201520214884.133800.711083.41
8/12/201520214265.383469.86795.52
8/13/201520214737.253301.141436.11
8/14/201520213201.754026.86-825.11
8/15/201520214498.884910.00-411.13
8/16/201520214823.883562.861261.02
8/17/201520213833.634584.57-750.95
8/18/201520212753.252933.71-180.46
8/19/201520213685.254079.57-394.32
8/20/201520214313.504852.71-539.21
8/21/201520212726.255172.00-2445.75
8/22/201520214849.254364.57484.68
8/23/201520213778.505115.14-1336.64
8/24/201520213225.503665.71-440.21
8/25/201520214719.133601.571117.55
8/26/201520213815.253517.00298.25
8/27/201520214983.883913.861070.02
8/28/201520214219.005315.14-1096.14
8/29/201520213282.005555.86-2273.86
8/30/201520213746.133921.57-175.45
8/31/201520214939.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 20142020
  • Q2 20142020
  • Q3 20142020
  • Q4 20142020
  • Q1 20152021
  • Q2 20152021
  • Q3 20152021
  • Q4 20152021

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

  • Stacked Column
  • Stacked Bar

You can use the Cogwheel 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 20142020Q2 20142020Q3 20142020Q4 20142020Q1 20152021Q2 20152021Q3 20152021Q4 20152021
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/201720208/7/20172020100%
AnalysisDiscussions with Stakeholders8/8/201720208/20/20172020100%
Analysis

Documenting Requirements

8/15/201720208/25/2017202095%
AnalysisCreation of Mockups8/21/201720209/7/2017202095%
AnalysisVerification of Requirements9/5/201720209/15/2017202050%
DesignDesign Database9/15/201720209/25/201720200%
DesignSoftware Design9/26/2017202010/1/201720200%
DesignInterface Design10/5/2017202010/15/201720200%
DesignCreate Design Specifications10/17/2017202010/25/201720200%
DesignVerification of Design Specifications10/28/2017202011/7/201720200%
DevelopmentDevelopment of System Modules10/16/2017202012/31/201720200%
Development

Integration of System Modules

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

1/25/20182021

DevelopmentRC22/3/20182021

Event

Date

Todaytoday
Meeting with Stakeholders10/5/20172020
Payment3/15/20182021