In order to use the plugins please login as a Guest
Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Table Filter add-on allows you to combine all its macros for flexible data filtration and generation of dynamically updated charts on the basis of pivot tables.

The current page provides an example of the table which is placed within Table Filter macro. The filtered table results are further used for generation of a pivot table and dynamic charts on the basis of the pivot table data.

Use Hint

  1. Try to select several agents through the filtration pane. The pivot table and chart will be automatically updated depending on the selected values.
  2. Try to specify the number range (for example, 2000-4000) for the Money column on the filtration pane. The pivot table and chart will be automatically updated depending on the selected values.
  3. Try to change the operation type of the Pivot Table macro.
  4. Try to change the Calculated Column for the Pivot Table macro.
  5. Try to change the chart type.
 Click to view the source data table...
AgentTickets per HourAverage Time per Ticket (min)Calls per HourAverage Time per Call (min)Money ($)
Remy Deomampo6.93.02.26.12 875.00
Rahul Dickstein8.01.64.44.85 270.00
Radu Donahue3.67.03.75.24 886.00
Preston Doorey2.26.94.87.55 237.00
Remy Deomampo4.45.72.44.63 140.00
Rahul Dickstein4.52.32.64.35 249.00
Radu Donahue7.53.21.15.32 572.00
Preston Doorey6.76.14.762 944.00
Phill Doyle8.15.92.16.33 767.00
Remy Deomampo2.75.34.66.23 206.00
Rahul Dickstein4.33.24.07.23 625.00
Radu Donahue5.61.74.97.61 399.00
Preston Doorey5.83.53.84.35 121.00
Remy Deomampo8.74.92.07.34 170.00
Rahul Dickstein8.81.42.94.22 032.00
Radu Donahue2.94.43.653 418.00
Preston Doorey2.65.01.34.91 364.00
Phill Doyle6.33.32.06.83 554.00
Remy Deomampo5.72.44.83.94 005.00
Remy Deomampo3.63.13.43.34 672.00
Rahul Dickstein4.91.11.87.14 711.00
Radu Donahue2.95.81.65.44 908.00
Preston Doorey5.71.24.65.55 162.00
Phill Doyle2.74.13.05.44 227.00
Philip Druckman5.82.64.24.32 701.00

 

 

Oops, it seems that you need to place a table or a macro generating a table within the Pivot Table macro.

The table is being loaded. Please wait for a bit ...

fromto

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

AgentTickets per HourAverage Time per Ticket (min)Calls per HourAverage Time per Call (min)Money ($)
Remy Deomampo6.93.02.26.12 875.00
Rahul Dickstein8.01.64.44.85 270.00
Radu Donahue3.67.03.75.24 886.00
Preston Doorey2.26.94.87.55 237.00
Remy Deomampo4.45.72.44.63 140.00
Rahul Dickstein4.52.32.64.35 249.00
Radu Donahue7.53.21.15.32 572.00
Preston Doorey6.76.14.762 944.00
Phill Doyle8.15.92.16.33 767.00
Remy Deomampo2.75.34.66.23 206.00
Rahul Dickstein4.33.24.07.23 625.00
Radu Donahue5.61.74.97.61 399.00
Preston Doorey5.83.53.84.35 121.00
Remy Deomampo8.74.92.07.34 170.00
Rahul Dickstein8.81.42.94.22 032.00
Radu Donahue2.94.43.653 418.00
Preston Doorey2.65.01.34.91 364.00
Phill Doyle6.33.32.06.83 554.00
Remy Deomampo5.72.44.83.94 005.00
Remy Deomampo3.63.13.43.34 672.00
Rahul Dickstein4.91.11.87.14 711.00
Radu Donahue2.95.81.65.44 908.00
Preston Doorey5.71.24.65.55 162.00
Phill Doyle2.74.13.05.44 227.00
Philip Druckman5.82.64.24.32 701.00
  • No labels