In order to use the plugins please login as a Guest
Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table Filter and Charts 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.

...

Info
titleUse 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.

 

 

Chart from Table
tfc-width700
tfc-height400
columnAgent
datepatternyy-mm-dd
aggregationAgent
id1440588375684_-72463276
typePie
separatorPoint (.)
Pivot Table
decimals2
columnAgent
decimalseparatorPoint (.)
aggregationMoney ($)
id1440588356002_-1651497200
typeSum
separatorSpace ( )
Table Filter
default,->
cell-width150
columnAgent
numberfilterMoney ($)
datepatternyy-mm-dd
numberfilterMoney ($)
id1440588335802_-551007789
separatorPoint (.)
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

You can view the source data table that was used.

Expand
titleClick 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