How to list information from a parent and its children page within the same row in a table report?

Onja

Hi everyone,

we are using Confluence for project reporting (with scaffolding).
We created two templates which we use for each project. The first one is used as parent page of a project, containing general informtaion about the project. The second one is used as its child page, where the actual reporting is done, meaning the changes within the project are reported and changed on the children page on a monthly basis.
For an overview of the progress of all projects, we created a dashboard with a table report showing the most importent information.

Our problem is, that we have information from the parent and its children page which shall be displayed together in the same row in the table report on the dashboard-page.
Currently for each project one row is displayed with the information of the parent page and one underneath is displayed with the information of the children page. (second picture below)
Is there a possibility of combining it?
I hope, and assume, yes, but if a gentle soul could advice how to do it, that would be great.

I thought about using the expanding reporter macro to fix the problem, but it wouldn't work. Though I also have the feeling, that I was unfortunately not using it in the correct way... ^^;

To make it more visible:
First picture shows a small version of how we created the dashboard so far.
The information regarding the project name is from the parent page, the status of its children page.

Second picture shows a small part of the table report on the dashboard-page.

Thank you a lot in advance!

Katerina Kovriga {Stiltsoft}

Hi @Onja ,

Saw the Table Filter macro on the page - it belongs to our Table Filter and Charts for Confluence app.

The add-on also provides the Table Transformer macro that contains a Look up preset. Here is its documentation with a use case for you to check.

If the two tables have a common column, they can be combined into one report.

For example, from the parent page you get the following table:

|ProjectName|SomeInfo|

|Name1         |Info1       |

And from the child page:

|ProjectName|Status   |

|Name1         |Status 1|

The result table will look as:

|ProjectName|SomeInfo|Status   |

|Name1         |Info1        |Status 1|

Maybe this may get you any idea how to implement your case. Or maybe you'll be able to provide us with the full result tables coming from your parent and child pages (here or via the support portal that is confidential) and we'll try to help.