Table filter add-on allows you to combine the following macros for your better performance with data tables:
Working with Table filter and Table chart macro
...
| Expand |
|---|
| title | Click to open the sample table... |
|---|
|
| pivottable-tablechart |
|---|
| tfc-width | |
|---|
| tfc-height | decimals | 2 | |
|---|
| column | Agent |
|---|
| datepattern | yy-mm-dd | decimalseparator | Point (.) |
|---|
| aggregation | Earned Money for Support ($Average Time per Call (min) |
|---|
| id | 14358094219821435769205495_6091240990 |
|---|
| type | AverageColumn |
|---|
| separator | Space Point (.) |
|---|
| | Table Filter |
|---|
| hideColumns | true | column |
|---|
| numberfilter | Average Time per Call (min),Average Time per Ticket (min),Calls per HourAgent |
|---|
| datepattern | yy-mm-dd |
|---|
| id | 14358092367261435769251693_19304630191810815350 |
|---|
| separator | Point (.) |
|---|
| | Agent | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour | Average Time per Call (min) | Earned Money for Support ($) |
|---|
| 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 DeomampoPhill Doyle | 4.4 | 5.7 | 2.4 | 4.6 | 3 140.00 | | Rahul DicksteinPhilip Druckman | 4.5 | 2.3 | 2.6 | 4.3 | 5 249.00 | | Radu DonahuePhilip Duncan | 7.5 | 3.2 | 1.1 | 5.3 | 2 572.00 | | Preston DooreyPeter Elia | 6.7 | 6.1 | 4.7 | 6 | 2 944.00 | | Phill DoylePeter Erickson | 8.1 | 5.9 | 2.1 | 6.3 | 3 767.00 | | Remy DeomampoPeter Espinosa | 2.7 | 5.3 | 4.6 | 6.2 | 3 206.00 | | Rahul DicksteinPeter Ferrero | 4.3 | 3.2 | 4.0 | 7.2 | 3 625.00 | | Radu DonahuePerez Figueiredo | 5.6 | 1.7 | 4.9 | 7.6 | 1 399.00 | | Preston DooreyPatrick Fixler | 5.8 | 3.5 | 3.8 | 4.3 | 5 121.00 | | Remy DeomampoPatrick Flegal | 8.7 | 4.9 | 2.0 | 7.3 | 4 170.00 | | Rahul DicksteinPatino Forsyth | 8.8 | 1.4 | 2.9 | 4.2 | 2 032.00 | | Radu DonahuePallavi Fox | 2.9 | 4.4 | 3.6 | 5 | 3 418.00 | | Preston DooreyOwen Franzoni | 2.6 | 5.0 | 1.3 | 4.9 | 1 364.00 | | Phill DoyleOphir Friedman | 6.3 | 3.3 | 2.0 | 6.8 | 3 554.00 | | Remy DeomampoObaid Friis | 5.7 | 2.4 | 4.8 | 3.9 | 4 005.00 | | Remy DeomampoNoelle Fu | 3.6 | 3.1 | 3.4 | 3.3 | 4 672.00 | | Rahul DicksteinNoel Gambino | 4.9 | 1.1 | 1.8 | 7.1 | 4 711.00 | | Radu DonahueNicole Gao | 2.9 | 5.8 | 1.6 | 5.4 | 4 908.00 | | Preston DooreyNishant Gao | 5.7 | 1.2 | 4.6 | 5.5 | 5 162.00 | | Phill DoyleNicole Garcia | 2.7 | 4.1 | 3.0 | 5.4 | 4 227.00 | | Philip DruckmanNegrin Gee | 5.8 | 2.6 | 4.2 | 4.3 | 2 701.00 |
|
|
|
Working with Table filter and Pivot table macro
...
| Expand |
|---|
| title | Click to open the sample table... |
|---|
|
| pivot-table-chart |
|---|
| decimals | 2 | tfc-width | tfc-height |
|---|
| column | Agent |
|---|
| decimalseparator | Point (.) | datepattern | yy-mm-dd |
|---|
| aggregation | Average Time per Call (minEarned Money for Support ($) |
|---|
| id | 14357692054951435809421982_0609124099 |
|---|
| type | ColumnAverage |
|---|
| separator | Point Space ( . ) |
|---|
| | Table Filter |
|---|
| hideColumns | true |
|---|
| column | Agent | numberfilter | Average Time per Call (min),Average Time per Ticket (min),Calls per Hour |
|---|
| datepattern | yy-mm-dd |
|---|
| id | 14357692516931435809236726_18108153501930463019 |
|---|
| separator | Point (.) |
|---|
| | Agent | Tickets per Hour | Average Time per Ticket (min) | Calls per Hour | Average Time per Call (min) | Earned Money for Support ($) |
|---|
| 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 | | Phill DoyleRemy Deomampo | 4.4 | 5.7 | 2.4 | 4.6 | 3 140.00 | | Philip DruckmanRahul Dickstein | 4.5 | 2.3 | 2.6 | 4.3 | 5 249.00 | | Philip DuncanRadu Donahue | 7.5 | 3.2 | 1.1 | 5.3 | 2 572.00 | | Peter EliaPreston Doorey | 6.7 | 6.1 | 4.7 | 6 | 2 944.00 | | Peter EricksonPhill Doyle | 8.1 | 5.9 | 2.1 | 6.3 | 3 767.00 | | Peter EspinosaRemy Deomampo | 2.7 | 5.3 | 4.6 | 6.2 | 3 206.00 | | Peter FerreroRahul Dickstein | 4.3 | 3.2 | 4.0 | 7.2 | 3 625.00 | | Perez FigueiredoRadu Donahue | 5.6 | 1.7 | 4.9 | 7.6 | 1 399.00 | | Patrick FixlerPreston Doorey | 5.8 | 3.5 | 3.8 | 4.3 | 5 121.00 | | Patrick FlegalRemy Deomampo | 8.7 | 4.9 | 2.0 | 7.3 | 4 170.00 | | Patino ForsythRahul Dickstein | 8.8 | 1.4 | 2.9 | 4.2 | 2 032.00 | | Pallavi FoxRadu Donahue | 2.9 | 4.4 | 3.6 | 5 | 3 418.00 | | Owen FranzoniPreston Doorey | 2.6 | 5.0 | 1.3 | 4.9 | 1 364.00 | | Ophir FriedmanPhill Doyle | 6.3 | 3.3 | 2.0 | 6.8 | 3 554.00 | | Obaid FriisRemy Deomampo | 5.7 | 2.4 | 4.8 | 3.9 | 4 005.00 | | Noelle FuRemy Deomampo | 3.6 | 3.1 | 3.4 | 3.3 | 4 672.00 | | Noel GambinoRahul Dickstein | 4.9 | 1.1 | 1.8 | 7.1 | 4 711.00 | | Nicole GaoRadu Donahue | 2.9 | 5.8 | 1.6 | 5.4 | 4 908.00 | | Nishant GaoPreston Doorey | 5.7 | 1.2 | 4.6 | 5.5 | 5 162.00 | | Nicole GarciaPhill Doyle | 2.7 | 4.1 | 3.0 | 5.4 | 4 227.00 | | Negrin GeePhilip Druckman | 5.8 | 2.6 | 4.2 | 4.3 | 2 701.00 |
|
|
|