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

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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>

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


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

Take a look at the Page Properties Report macro:

This in conjunction with the Page Properties macro:

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
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

415 views 23 8
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