| Agent | Date | Tickets per Hour | Ticket Response (min) | Calls per Hour | Answered TIckets |
|---|---|---|---|---|---|
| Remy Dempo | 25.06.2015 | 7.3 | 3.2 | 3.3 | 89 |
| Rahul Dickstein | 26.06.2015 | 8.5 | 3.1 | 1.8 | 95 |
| Radu Donahue | 27.06.2015 | 5.0 | 3.7 | 4.5 | 65 |
| Preston Doorey | 28.06.2015 | 2.2 | 5.8 | 2.7 | 28 |
| Phill Doyle | 29.06.2015 | 3.9 | 5.2 | 2.9 | 37 |
Chart from Table is a macro bundled within Table Filter and Charts add-on. It allows you to generate dynamically updated charts with a capability to instantly switch between columns with different data values.
Chart Examples
Try to see Chart from Table macro in action while working with the following chart examples.
Sample Chart #1
Use 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.
Sample Chart #2
Use 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.
| Date | Income | Spendings | Balance |
|---|---|---|---|
| 8/1/2015 | 4366.50 | 4332.43 | 34.07 |
| 8/2/2015 | 3369.00 | 4251.00 | -882.00 |
| 8/3/2015 | 4685.00 | 5212.57 | -527.57 |
| 8/4/2015 | 3284.25 | 2912.14 | 372.11 |
| 8/5/2015 | 2892.75 | 4260.00 | -1367.25 |
| 8/6/2015 | 2833.38 | 3034.29 | -200.91 |
| 8/7/2015 | 3827.63 | 4318.00 | -490.38 |
| 8/8/2015 | 3936.38 | 5706.71 | -1770.34 |
| 8/9/2015 | 4804.38 | 3199.57 | 1604.80 |
| 8/10/2015 | 4325.38 | 4151.86 | 173.52 |
| 8/11/2015 | 4884.13 | 3800.71 | 1083.41 |
| 8/12/2015 | 4265.38 | 3469.86 | 795.52 |
| 8/13/2015 | 4737.25 | 3301.14 | 1436.11 |
| 8/14/2015 | 3201.75 | 4026.86 | -825.11 |
| 8/15/2015 | 4498.88 | 4910.00 | -411.13 |
| 8/16/2015 | 4823.88 | 3562.86 | 1261.02 |
| 8/17/2015 | 3833.63 | 4584.57 | -750.95 |
| 8/18/2015 | 2753.25 | 2933.71 | -180.46 |
| 8/19/2015 | 3685.25 | 4079.57 | -394.32 |
| 8/20/2015 | 4313.50 | 4852.71 | -539.21 |
| 8/21/2015 | 2726.25 | 5172.00 | -2445.75 |
| 8/22/2015 | 4849.25 | 4364.57 | 484.68 |
| 8/23/2015 | 3778.50 | 5115.14 | -1336.64 |
| 8/24/2015 | 3225.50 | 3665.71 | -440.21 |
| 8/25/2015 | 4719.13 | 3601.57 | 1117.55 |
| 8/26/2015 | 3815.25 | 3517.00 | 298.25 |
| 8/27/2015 | 4983.88 | 3913.86 | 1070.02 |
| 8/28/2015 | 4219.00 | 5315.14 | -1096.14 |
| 8/29/2015 | 3282.00 | 5555.86 | -2273.86 |
| 8/30/2015 | 3746.13 | 3921.57 | -175.45 |
| 8/31/2015 | 4939.50 | 4909.29 | 30.21 |
Sample Chart #3
Use 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.
| Date | Income | Spendings | Balance |
|---|---|---|---|
| 8/1/2015 | 4366.50 | 4332.43 | 34.07 |
| 8/2/2015 | 3369.00 | 4251.00 | -882.00 |
| 8/3/2015 | 4685.00 | 5212.57 | -527.57 |
| 8/4/2015 | 3284.25 | 2912.14 | 372.11 |
| 8/5/2015 | 2892.75 | 4260.00 | -1367.25 |
| 8/6/2015 | 2833.38 | 3034.29 | -200.91 |
| 8/7/2015 | 3827.63 | 4318.00 | -490.38 |
| 8/8/2015 | 3936.38 | 5706.71 | -1770.34 |
| 8/9/2015 | 4804.38 | 3199.57 | 1604.80 |
| 8/10/2015 | 4325.38 | 4151.86 | 173.52 |
| 8/11/2015 | 4884.13 | 3800.71 | 1083.41 |
| 8/12/2015 | 4265.38 | 3469.86 | 795.52 |
| 8/13/2015 | 4737.25 | 3301.14 | 1436.11 |
| 8/14/2015 | 3201.75 | 4026.86 | -825.11 |
| 8/15/2015 | 4498.88 | 4910.00 | -411.13 |
| 8/16/2015 | 4823.88 | 3562.86 | 1261.02 |
| 8/17/2015 | 3833.63 | 4584.57 | -750.95 |
| 8/18/2015 | 2753.25 | 2933.71 | -180.46 |
| 8/19/2015 | 3685.25 | 4079.57 | -394.32 |
| 8/20/2015 | 4313.50 | 4852.71 | -539.21 |
| 8/21/2015 | 2726.25 | 5172.00 | -2445.75 |
| 8/22/2015 | 4849.25 | 4364.57 | 484.68 |
| 8/23/2015 | 3778.50 | 5115.14 | -1336.64 |
| 8/24/2015 | 3225.50 | 3665.71 | -440.21 |
| 8/25/2015 | 4719.13 | 3601.57 | 1117.55 |
| 8/26/2015 | 3815.25 | 3517.00 | 298.25 |
| 8/27/2015 | 4983.88 | 3913.86 | 1070.02 |
| 8/28/2015 | 4219.00 | 5315.14 | -1096.14 |
| 8/29/2015 | 3282.00 | 5555.86 | -2273.86 |
| 8/30/2015 | 3746.13 | 3921.57 | -175.45 |
| 8/31/2015 | 4939.50 | 4909.29 | 30.21 |
Sample Chart #4
Use Hint
Try to alternate the view of the chart by adding or removing columns with values for this stacked column chart:
- Q1 2014
- Q2 2014
- Q3 2014
- Q4 2014
- Q1 2015
- Q2 2015
- Q3 2015
- Q4 2015
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.
| Add-on | Q1 2014 | Q2 2014 | Q3 2014 | Q4 2014 | Q1 2015 | Q2 2015 | Q3 2015 | Q4 2015 |
|---|---|---|---|---|---|---|---|---|
| Table Filter | 139 | 114 | 145 | 106 | 106 | 103 | 148 | 105 |
| Smart Attachments | 54 | 79 | 69 | 66 | 90 | 96 | 50 | 97 |
| Awesome Graphs | 142 | 128 | 135 | 195 | 198 | 179 | 238 | 192 |
| Quizzes | 20 | 48 | 36 | 42 | 33 | 37 | 46 | 29 |
| Customer Case | 15 | 10 | 13 | 25 | 18 | 22 | 17 | 19 |
Sample Chart #5
Use Hint
You can build Gantt chart to visualize project stages during the project planning and resource estimation.
| Task Type | Task Description | Start Date | End Date | Completion |
|---|---|---|---|---|
| Analysis | Onsite Meetings | 8/1/2017 | 8/7/2017 | 100% |
| Analysis | Discussions with Stakeholders | 8/8/2017 | 8/20/2017 | 100% |
| Analysis | Documenting Requirements | 8/15/2017 | 8/25/2017 | 95% |
| Analysis | Creation of Mockups | 8/21/2017 | 9/7/2017 | 95% |
| Analysis | Verification of Requirements | 9/5/2017 | 9/15/2017 | 50% |
| Design | Design Database | 9/15/2017 | 9/25/2017 | 0% |
| Design | Software Design | 9/26/2017 | 10/1/2017 | 0% |
| Design | Interface Design | 10/5/2017 | 10/15/2017 | 0% |
| Design | Create Design Specifications | 10/17/2017 | 10/25/2017 | 0% |
| Design | Verification of Design Specifications | 10/28/2017 | 11/7/2017 | 0% |
| Development | Development of System Modules | 10/16/2017 | 12/31/2017 | 0% |
| Development | Integration of System Modules | 1/1/2018 | 1/15/2018 | 0% |
| Development | Initial Testing of System Modules | 1/17/2018 | 1/31/2018 | 0% |
| Development | Deployment to Test Environment | 2/1/2018 | 2/5/2018 | 0% |
| Testing | System Testing | 1/20/2018 | 2/8/2018 | 0% |
| Testing | Penetration Testing | 2/10/2018 | 2/15/2018 | 0% |
| Testing | Performance Testing | 2/17/2018 | 2/20/2018 | 0% |
| Testing | Tracking Found Issues | 2/18/2018 | 2/25/2018 | 0% |
| Testing | Fixing Found Issues | 2/21/2018 | 2/28/2018 | 0% |
| Deployment | Data Migration | 3/1/2018 | 3/4/2018 | 0% |
| Deployment | System Integration | 3/5/2018 | 3/9/2018 | 0% |
| Deployment | System Monitoring | 3/10/2018 | 3/31/2018 | 0% |
| Task Type | Milestone | Date |
|---|---|---|
| Development | RC1 | 1/25/2018 |
| Development | RC2 | 2/3/2018 |
Event | Date |
|---|---|
| Today | today |
| Meeting with Stakeholders | 10/5/2017 |
| Payment | 3/15/2018 |