Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Jan Rautmann January 24, 2019

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

2 answers

0 votes
Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 29, 2019

Hi Jan, 

Maybe Pivot Table macro will help in this case.

First example:

2019-01-29_19h27_24.png

Second example2019-01-29_19h28_04.png

Jan Rautmann January 29, 2019

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 ;-)

0 votes
Stephen Sifers
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 29, 2019

Hello Jan and welcome to the Community!

To summarize what you’re requesting, you’re wanting a report for all projects with each resource assigned by role. Two examples of this would look as follows:

image.png

With this said, to help you find a solution but avoid creating duplicate data we need some additional clarification.

  • Where are you storing your project data (Jira, excel, etc)?
  • How are you project pages within Confluence structured?
    • Does each project have its own space?
  • What is your goal once you have this report?

This clarification will help to ensure we provide a solution which will best suit your requirements without having to create additional work and management of your project data.

Regards,
Stephen Sifers

Jan Rautmann January 29, 2019

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events