Need help with Atlassian products? Order the professional consulting services from us. Get a free consultation right now!
Skip to end of metadata
Go to start of metadata
Combining Table Filter, Pivot Table and Table Chart macros

Table Filter for Confluence add-on allows you to transform you table data in the convenient view with the combination of Table Filter, Pivot Table and Table Chart. The combination of all these macros allows you to generate the pivot table with aggregated data that can be further used for visualization and chart generation. Filtration of your table data will also lead to automatic update of the pivot table and the chart.

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

  1. Create or import a table with data values.
  2. Insert the Table filter macro and place the table within the macro.
  3. Configure the filtration parameters. For example, add filters by number range for the corresponding columns.
  4. Insert the Table chart macro.
  5. Place the Table filter macro with the table inside the Table chart macro.
  6. Configure parameters of the chart. For example, select the chart type as 'Column' and select the columns with row labels and data columns.
  7. Save the page.
  8. Enter the appropriate number range in the filter. Filtration will be automatically applied to the data table and the chart will be automatically updated.
  9. Change the Values column for another one, if needed.
 Click to open the sample table...
fromto
fromto
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)Earned Money for Support ($)
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
Phill Doyle4.45.72.44.63 140.00
Philip Druckman4.52.32.64.35 249.00
Philip Duncan7.53.21.15.32 572.00
Peter Elia6.76.14.762 944.00
Peter Erickson8.15.92.16.33 767.00
Peter Espinosa2.75.34.66.23 206.00
Peter Ferrero4.33.24.07.23 625.00
Perez Figueiredo5.61.74.97.61 399.00
Patrick Fixler5.83.53.84.35 121.00
Patrick Flegal8.74.92.07.34 170.00
Patino Forsyth8.81.42.94.22 032.00
Pallavi Fox2.94.43.653 418.00
Owen Franzoni2.65.01.34.91 364.00
Ophir Friedman6.33.32.06.83 554.00
Obaid Friis5.72.44.83.94 005.00
Noelle Fu3.63.13.43.34 672.00
Noel Gambino4.91.11.87.14 711.00
Nicole Gao2.95.81.65.44 908.00
Nishant Gao5.71.24.65.55 162.00
Nicole Garcia2.74.13.05.44 227.00
Negrin Gee5.82.64.24.32 701.00

 

 

Working with Table filter and Pivot table macro

  1. Create or import a table with data values.
  2. Insert the Table filter macro and place the table within the macro.
  3. Configure the filtration parameters. For example, add the filter by agent.
  4. Insert the Pivot table macro.
  5. Place the Table filter macro with the table inside the Pivot table macro.
  6. 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.
  7. Save the page.
  8. Select the appropriate agents in the filter. Filtration will be automatically applied to the data table and the pivot table will be automatically updated.
  9. Change the calculated column for another one, if needed.
 Click to open the sample table...

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

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)Earned Money for Support ($)
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