Table Filter and Charts add-on , Charts & Spreadsheets for Confluence app allows you to combine all its macros for flexible data filtration and generation of dynamically updated charts on the basis of pivot tables.
...
Chart from Table |
---|
tfc-width | 700 |
---|
tfc-height | 400 |
---|
column | Agent |
---|
datepattern | yy-mm-dd |
---|
aggregation | Agent |
---|
id | 1440588375684_-72463276 |
---|
type | Pie |
---|
separator | Point (.) |
---|
|
Pivot Table |
---|
decimals | 2 |
---|
column | Agent |
---|
decimalseparator | Point (.) |
---|
aggregation | Money ($) |
---|
id | 1440588356002_-1651497200 |
---|
type | Sum |
---|
separator | Space ( ) |
---|
| Table Filter |
---|
default | ,-> |
---|
cell-width | 150 |
---|
column | Agent |
---|
datepattern | yy-mm-dd |
---|
numberfilter | Money ($) |
---|
id | 1440588335802_-551007789 |
---|
separator | Point (.) |
---|
| Agent | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour | Average Time per Call (min) | Money ($) |
---|
Remy Deomampo | 6.9 | 3.0 | 2.2 | 6.1 | 2 875.00 | Rahul Dickstein | 8.0 | 1.6 | 4.4 | 4.8 | 5 270.00 | Radu Donahue | 3.6 | 7.0 | 3.7 | 5.2 | 4 886.00 | Preston Doorey | 2.2 | 6.9 | 4.8 | 7.5 | 5 237.00 | Remy Deomampo | 4.4 | 5.7 | 2.4 | 4.6 | 3 140.00 | Rahul Dickstein | 4.5 | 2.3 | 2.6 | 4.3 | 5 249.00 | Radu Donahue | 7.5 | 3.2 | 1.1 | 5.3 | 2 572.00 | Preston Doorey | 6.7 | 6.1 | 4.7 | 6 | 2 944.00 | Phill Doyle | 8.1 | 5.9 | 2.1 | 6.3 | 3 767.00 | Remy Deomampo | 2.7 | 5.3 | 4.6 | 6.2 | 3 206.00 | Rahul Dickstein | 4.3 | 3.2 | 4.0 | 7.2 | 3 625.00 | Radu Donahue | 5.6 | 1.7 | 4.9 | 7.6 | 1 399.00 | Preston Doorey | 5.8 | 3.5 | 3.8 | 4.3 | 5 121.00 | Remy Deomampo | 8.7 | 4.9 | 2.0 | 7.3 | 4 170.00 | Rahul Dickstein | 8.8 | 1.4 | 2.9 | 4.2 | 2 032.00 | Radu Donahue | 2.9 | 4.4 | 3.6 | 5 | 3 418.00 | Preston Doorey | 2.6 | 5.0 | 1.3 | 4.9 | 1 364.00 | Phill Doyle | 6.3 | 3.3 | 2.0 | 6.8 | 3 554.00 | Remy Deomampo | 5.7 | 2.4 | 4.8 | 3.9 | 4 005.00 | Remy Deomampo | 3.6 | 3.1 | 3.4 | 3.3 | 4 672.00 | Rahul Dickstein | 4.9 | 1.1 | 1.8 | 7.1 | 4 711.00 | Radu Donahue | 2.9 | 5.8 | 1.6 | 5.4 | 4 908.00 | Preston Doorey | 5.7 | 1.2 | 4.6 | 5.5 | 5 162.00 | Phill Doyle | 2.7 | 4.1 | 3.0 | 5.4 | 4 227.00 | Philip Druckman | 5.8 | 2.6 | 4.2 | 4.3 | 2 701.00 |
|
|
|
You can view the source data table that was used.
Expand |
---|
title | Click to view the source data table... |
---|
|
Agent | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour | Average Time per Call (min) | Money ($) |
---|
Remy Deomampo | 6.9 | 3.0 | 2.2 | 6.1 | 2 875.00 | Rahul Dickstein | 8.0 | 1.6 | 4.4 | 4.8 | 5 270.00 | Radu Donahue | 3.6 | 7.0 | 3.7 | 5.2 | 4 886.00 | Preston Doorey | 2.2 | 6.9 | 4.8 | 7.5 | 5 237.00 | Remy Deomampo | 4.4 | 5.7 | 2.4 | 4.6 | 3 140.00 | Rahul Dickstein | 4.5 | 2.3 | 2.6 | 4.3 | 5 249.00 | Radu Donahue | 7.5 | 3.2 | 1.1 | 5.3 | 2 572.00 | Preston Doorey | 6.7 | 6.1 | 4.7 | 6 | 2 944.00 | Phill Doyle | 8.1 | 5.9 | 2.1 | 6.3 | 3 767.00 | Remy Deomampo | 2.7 | 5.3 | 4.6 | 6.2 | 3 206.00 | Rahul Dickstein | 4.3 | 3.2 | 4.0 | 7.2 | 3 625.00 | Radu Donahue | 5.6 | 1.7 | 4.9 | 7.6 | 1 399.00 | Preston Doorey | 5.8 | 3.5 | 3.8 | 4.3 | 5 121.00 | Remy Deomampo | 8.7 | 4.9 | 2.0 | 7.3 | 4 170.00 | Rahul Dickstein | 8.8 | 1.4 | 2.9 | 4.2 | 2 032.00 | Radu Donahue | 2.9 | 4.4 | 3.6 | 5 | 3 418.00 | Preston Doorey | 2.6 | 5.0 | 1.3 | 4.9 | 1 364.00 | Phill Doyle | 6.3 | 3.3 | 2.0 | 6.8 | 3 554.00 | Remy Deomampo | 5.7 | 2.4 | 4.8 | 3.9 | 4 005.00 | Remy Deomampo | 3.6 | 3.1 | 3.4 | 3.3 | 4 672.00 | Rahul Dickstein | 4.9 | 1.1 | 1.8 | 7.1 | 4 711.00 | Radu Donahue | 2.9 | 5.8 | 1.6 | 5.4 | 4 908.00 | Preston Doorey | 5.7 | 1.2 | 4.6 | 5.5 | 5 162.00 | Phill Doyle | 2.7 | 4.1 | 3.0 | 5.4 | 4 227.00 | Philip Druckman | 5.8 | 2.6 | 4.2 | 4.3 | 2 701.00 |
|