Versions Compared

Key

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


Warningmybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:

work with multiple macros at once



Panel
bgColorwhite
titleBGColor#f5f5f5
titleCombining 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:

Info

Combining the macros is not allowed in the new Confluence Cloud editor.


Widget Connector
width432
urlhttps://www.youtube.com/watch?v=8nxGN3ETbv8
height243



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.
Expand
titleClick to open the sample table...


Chart from Table
tfc-width800
tfc-height300
columnAgent
datepatternyy-mm-dd
aggregationAverage Time per Call (min)
id1435769205495_0
typeColumn
separatorPoint (.)


Table Filter
hideColumnstrue
datepatternyy-mm-dd
numberfilterAverage Time per Call (min),Average Time per Ticket (min),Calls per Hour
id1435769251693_1810815350
separatorPoint (.)


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.
Expand
titleClick to open the sample table...


Pivot Table
decimals2
columnAgent
decimalseparatorPoint (.)
aggregationEarned Money for Support ($)
id1474440979405_205582813
typeAverage
separatorSpace ( )


Table Filter
hideColumnstrue
columnAgent
datepatternyy-mm-dd
id1474440979407_205582813
separatorPoint (.)


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