It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

automatically aggregate the top data row of many tables into a single master table

We have dozens of project pages, with one "weekly status" table per page, where we add a new row each week.

We want to have a master page with a master table that automatically aggregates the top data row from each of those projects.

Can anyone suggest a way to do that?

I can almost do it now, by:

- putting an excerpt macro around each table

- including all the excerpts in a master table

- using the table filter macro to showing only the first 1 row of each included table

BUT when I do that I get one copy of the headers per child table, and it looks like garbage. I either need to figure out how to get the table filter macro to suppress the headers or else I need to figure out a completely different approach.

2 answers

1 accepted

3 votes
Answer accepted

Hi Fritz,

as I get from your question you've got the Table Filter and Charts add-on installed (as have we).

I tried to merged two tables as you described using this add-on and succeeded. I did the following:

  • Table pages
    1. Create two pages (Table 1 and Table 2).
    2. Each page has a label table.
    3. Create a table on each page having the same table columns. I added a column Week to identify the week of the status report.
    4. Put each table in a Table Excerpt Macro having the same name (table).
  • Master page
    1. Add the Table Excerpt include Macro to collect the tables. Use the following options:
      • Excerpt name = table (see table pages above)
      • Excerpt source = Pages with labels
      • Page labels = table (see table pages above)
      • Search in space = <insert your space here>

        table_excerpt_include.png
    2. Put a Table Filter Macro around the Table Excerpt to filter out the unwanted rows.
      • Tab Filtration: Check Hide filtration pane
      • Tab Table View:
        • Default sorting = Week highest --> lowest
        • Show first N rows = 1 (=> show only the latest week!)
      • table_filter.png
    3. Put a Table Transformer around the Table Filter to merge the tables.
      • table_transformer.png

I hope this is what you wanted to achieve. If not, I had some nice time fiddling around with the Table Filter macros ;)

Cheers,
Kirstin

WOW WOW WOW. That indeed solves my problem. This eliminates the most tedious hour of my week every week. THANK YOU!

0 votes

Take a look at the Page Properties Report macro:

https://confluence.atlassian.com/doc/page-properties-report-macro-186089616.html

This in conjunction with the Page Properties macro:

https://confluence.atlassian.com/doc/page-properties-macro-184550024.html

can be used to define a table on a set of pages and have the content roll-up to a master page.

Cool! Thanks! I'll dig into this as well!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What project did you transition or start on Confluence with the shift to remote work?

It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...

109 views 3 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you