You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I am trying to aggregate rows of data from multiple pages in confluence to a master page in confluence using Page Properties and Page Properties Report, but the master page with the Page Properties Report macro only displays the first row of information form the multiple pages with the Page Properties macro.
Is there a setting I am missing to pull in all of the data from the pages with the Page Properties macro onto the page with the Page Properties Report or a different macro I should be using?
Hi @Caitlin Barahimi ,
The Page Properties/Page Properties Report macros collect one-row tables.
To collect multiple-row tables along with the source pages' metadata, you may need 3rd party apps. For example, we can suggest our Table Filter and Charts for Confluence add-on and its Table Excerpt/Table Excerpt Include macros.
Besides these handy pair of macros, you'll be able to filter, aggregate and visualize your tables as well as performing tabular calculations (including not only manually created Confluence tables but macro generated, for example, Jira Issues, Page Properties Report, Content Report Table, etc.).
Hi there,
As this Community question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.
The macro allows you to work with fully functional Excel spreadsheets right in Confluence.
You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.
The Table Spreadsheet macro is available for Cloud and Server/Data Center.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I feel your pain. I'm trying to do the same thing. I have a number of design pages, each of which have a table that contains a number of line items of technical debt associated with that design.
I want to have a parent page that summarises all this information in a single table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Caitlin Barahimi welcome to the Atlassian community
When you are adding page properties to a page and you add your table you need to make sure you set the tables heading styling is applied to the first column. If you do not do this the it will only get the first roe. You can learn more here: https://support.atlassian.com/confluence-cloud/docs/insert-the-page-properties-macro/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The data over rows in the pages where you have page property macro will be included as column data in the page property report macro
Check for the macro configuration whether you have restricted the columns
Include just the labels if you are restricting the pages from where your page properties report has to pick up those tables
You could change how the columns can be shown in the macro configuration page
Thanks,
Pramodh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.