How to create a summary page containing data from other pages?

[Eric Lee]

Hi Atlassian Community,

I have multiple pages, each contains a populated table with each table having the same  standard format.

I'd like to create a summary page that pulls the tables from each page into a single table on the summary page.

Is this possible?  If so, any pointers would be much appreciated!

Thanks in advance

Eric

[Katerina Kovriga _Stiltsoft_]

Hi @Eric Lee ,

The standard Page Properties/Page Properties Report macros collect one-row tables.

To collect multiple-row tables, use our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros.

The summary report (combined with the help of standard Confluence macros or our advanced macros) can be further filtered, aggregated and visualized with the help of our app.

Maybe you are interested in a live demo from our team - we'll be happy to organize it.

[Pramodh M]

Hi @Eric Lee 

Welcome to the community 🙂

You could use the page properties macro to include the tables from multiple pages into a single one

Here's a guide on how to do that

https://support.atlassian.com/confluence-cloud/docs/insert-the-page-properties-macro

Place  the tables inside the page properties macro

Create a page properties report macro where you need the consolidated table report

If you need more customisation on filtering data, you could use add-on here listed below

https://marketplace.atlassian.com/apps/27447/table-filter-and-charts-for-confluence?tab=overview&hosting=cloud

Let me know if you have any queries

Thanks

[Eric Lee]

Thanks Pramodh, 

My tables from each source page has multiple data rows.  To confirm, this approach with page properties only works if you have 1 data row?

Thanks

[Stefan Kleineikenscheidt (K15t)]

Hey@@Eric Lee

if you need standardized tables you may also want to have a look at Orderly Databases (read the announcement), which allows you to define tables/databases with typed columns. The tables can be aggregated with macros.

Cheers,
-Stefan

[Bibek Behera]

@Eric Lee you can go through the video below.

https://youtu.be/gXKeoIV3EzQ skip to 3:22 :) 

Regards,

Bibek