...
Expand | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
Chart from Table | ||||||||||||||||
| ||||||||||||||||
Table Filter | ||||||||||||||||
| ||||||||||||||||
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 .
- 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.