Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,457,745
Community Members
 
Community Events
176
Community Groups

Report table ans sorting

Hi,

I have built a report table that show  status of several KPIs based on inputs provided into a survey (questionnaire). The survey is a template that is used to generate as many survey are there are projects to manage in the Portfolio.

We host also on Confluence a parent page with children pages which are the status report of each project. The report page is also using a template to create dashboards. 

I would like to add on this template the view of the KPIs status from the report table but only the row of the project concerned by the dashboard. So basically I have 50 projects listed into the report table and I want to show only KPIs of the specific project  in each Report Dashboard page.

How can I do that? I have replicated the macro structure to create the report table into the Dashboard template and tried to use the Text Filter macro which is indeed working but it is not dynamic. I want the template to pick the correct row of the report table to display when the Dashboard name is matching the survey name.

I heard about those wiki markup which may be the thing I am looking for to achieve this. 

Any help will be greatly appreciated.

Thanks

Rick

 

1 comment

I'm not sure that it will cover your case with Portfolio and surveys, but still we have something similar in our Table Filter and Charts for Confluence app.

The add-on provides the Table Excerpt/Table Excerpt Include macros that allow you to collect multiple-row tables from pages with specific labels, child pages or all descendants.

The result report can be recreated on different master pages (as many times as you need and wherever you need) and can be filtered by any column you want with the help of the Table Filter macro.

If any changes are made to the source tables, they will be immediately passed to the combined table and the filtered dashboards will be updated as well. 

Here you may find an example.

Hi Katerina,

Thank you I will give it a try. I heard also that now it is possible to inject parameters in a Table Transformer macro? That would also maybe work with an SQL query where I select all columns where first column is equal to the value recorded into a Text Data parameter?

Do you mean using the Table Transformer macro as a replacement to the Table Filter macro? To filter the table using a text variable? It is possible to do or you may use the Table Filter macro with predefined filters as well.

Thanks it worked with Table Transformer!! I created another single column table where I placed a report on on a variable. Then added the SQL query in Table Transformed to lookup both tables and select T1 where T2 variable is equal to T1 column 'Project Title'.

Thanks for having helped me to sort this out! :-)

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events