Page properties report with pivot table

Question

Each person in my group has an individual training tracker page where they have a table of trainings and they can check off trainings in that table when they are completed. Each person's page has a pivot table showing the percentage of trainings that are complete, in progress, and not started. My task right now is to have a parent page where I use the page properties report to link to each of these individual pages and display the data from those pivot tables (percentages of: complete, in progress, and not started). However, the page properties do not work with the pivot table, but if I create a regular table with values, that works. Is there any way to do this differently?

Stiltsoft support · Answer

Hi @Jessica Luo ,

The loading time depends on your data. As usual, such thing may happen if you collect really big tables (hundreds of rows). Besides, it always works slower on Confluence Cloud.

Please try to check the "Output cached results" checkbox for each Table Excerpt Include macro that you use.

If nothing changes (as usual, this setting helps), please refer to our support. The portal is confidential, so we'll move there to investigate the issue.

Jessica Luo · Answer

Hi @Stiltsoft support thanks for the answer. I successfully created my training pages with the table excerpt macros. however, my pages take over 5 minutes to load after adding 10 training trackers for individuals, do you have any idea how to resolve this?

Stiltsoft support · Answer

Hi @Jessica Luo ,

As you've mentioned the Pivot Table macro, I assume you have the Table Filter and Charts for Confluence app.

If this is the case, then use the Table Excerpt/Table Excerpt Include macros to collect pivots instead of the Page Properties/Page Properties Report macros.

As you are on Cloud, you should insert the Table Toolbox macro to nest macros.

So, on the individual pages you may have the following structure: table <- Table Toolbox. Inside the Table Toolbox create the following macro sequence: table <- Pivot Table <- Table Excerpt.

On the dashboard you may collect your excerpts using the Table Excerpt Include macro. Note that you may choose what meta data (page title and so on) you want to show along with the collected tables.

Hope this helps your case.