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
- Create or import a table with data values.
- Insert the Table filter macro and place the table within the macro.
- Configure the filtration parameters. For example, add filters by number range for the corresponding columns.
- Insert the Table chart macro.
- Place the Table filter macro with the table inside the Table chart macro.
- Configure parameters of the chart. For example, select the chart type as 'Column' and select the columns with row labels and data columns.
- Save the page.
- Enter the appropriate number range in the filter. Filtration will be automatically applied to the data table and the chart will be automatically updated.
- Change the Values column for another one, if needed.
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 Doyle | 4.4 | 5.7 | 2.4 | 4.6 | 3 140.00 | Philip Druckman | 4.5 | 2.3 | 2.6 | 4.3 | 5 249.00 | Philip Duncan | 7.5 | 3.2 | 1.1 | 5.3 | 2 572.00 | Peter Elia | 6.7 | 6.1 | 4.7 | 6 | 2 944.00 | Peter Erickson | 8.1 | 5.9 | 2.1 | 6.3 | 3 767.00 | Peter Espinosa | 2.7 | 5.3 | 4.6 | 6.2 | 3 206.00 | Peter Ferrero | 4.3 | 3.2 | 4.0 | 7.2 | 3 625.00 | Perez Figueiredo | 5.6 | 1.7 | 4.9 | 7.6 | 1 399.00 | Patrick Fixler | 5.8 | 3.5 | 3.8 | 4.3 | 5 121.00 | Patrick Flegal | 8.7 | 4.9 | 2.0 | 7.3 | 4 170.00 | Patino Forsyth | 8.8 | 1.4 | 2.9 | 4.2 | 2 032.00 | Pallavi Fox | 2.9 | 4.4 | 3.6 | 5 | 3 418.00 | Owen Franzoni | 2.6 | 5.0 | 1.3 | 4.9 | 1 364.00 | Ophir Friedman | 6.3 | 3.3 | 2.0 | 6.8 | 3 554.00 | Obaid Friis | 5.7 | 2.4 | 4.8 | 3.9 | 4 005.00 | Noelle Fu | 3.6 | 3.1 | 3.4 | 3.3 | 4 672.00 | Noel Gambino | 4.9 | 1.1 | 1.8 | 7.1 | 4 711.00 | Nicole Gao | 2.9 | 5.8 | 1.6 | 5.4 | 4 908.00 | Nishant Gao | 5.7 | 1.2 | 4.6 | 5.5 | 5 162.00 | Nicole Garcia | 2.7 | 4.1 | 3.0 | 5.4 | 4 227.00 | Negrin Gee | 5.8 | 2.6 | 4.2 | 4.3 | 2 701.00 |
|
|
|
Working with Table filter and Pivot table macro
- Create or import a table with data values.
- Insert the Table filter macro and place the table within the macro.
- Configure the filtration parameters. For example, add the filter by agent.
- Insert the Pivot table macro.
- Place the Table filter macro with the table inside the Pivot table macro.
- Configure parameters of the pivot table. For example, select the Agent column as row labels and the Earned Money for Support as the calculated column.
- Save the page.
- Select the appropriate agents in the filter. Filtration will be automatically applied to the data table and the pivot table will be automatically updated.
- Change the calculated column for another one, if needed.
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 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 |
|
|
|