How to generate a dynamic participant list out of a page property report macro?

Question

Hi,

within a page property report (program overview with several projects and subprojects and assigned ressources) I have 3 different columns which contain names of assigned ressources (each column for a certain skill set [Product Owner(s), Data Scientist(s), Data Engineer(s))

I would like to generate a dynamic list, which ressources are assigned to which project (in total without any duplicates) across all three columns of the page property report.

My idea would be to parse through all the relevant columns per project (project names are used as labels), writing it to an array  and printing it afterwards without any duplicates to a 1 column table. Unfortunately I have no clue how to do it within Confluence.

Thanks in advance,

Jan

Jan Rautmann · Answer

Hi Andrey, thank you very much for your answer.

Looks interesting, but as far as I know the marketplace is not yet an option. That's making it a little bit tricky at the moment ;-)

Jan Rautmann · Answer

Hi Stephen, thank you for your questions.

The separation between functions is not 100% sharp. This means that John Doe might be used in the project Harvest not as product manager but for example as Data Scientist. The setup at the moment is more general. But the report result looks like the first table. I have the project name and the assigned ressources by name in one row.

There is one space used for the program, which means that the projects are identified by using labels in Confluence. The project details (epics, stories, tasks, etc.) are stored in Jira. But the relevant information, who is participating in the project is a simple table on a Confluence page for each project. The structure of this confluence page is for each project the same (template).

As the ressources may vary over time per project, I thought to provide these report results to the PMO, to facilitate the organisation of meetings, distribution of information, etc. to the relevant project members. As long as the confluence page of each project is kept up to date, no one will be forgotten. That was the idea behind.

I hope it is getting now a little bit clearer.

Best,

Jan

Andrey Khaneev _StiltSoft_ · Answer

Hi Jan,

Maybe Pivot Table macro will help in this case.

First example:

Second example