Katerina Kovriga {Stiltsoft} Expert

I've got your idea but right now it is not possible to accomplish.

Yes, you can fetch tables and text abstracts both by Excerpt/Excerpt Include and Table Excerpt/Table Excerpt Include macros. The difference is that the latter pair allows you to show metadata for the source pages (page title, author, created, etc.) and show as many excerpts from the source page as you need (this feature…

Hi @Balaji Madhavan , Have you tried using the standard Jira Issues macro? It allows you to grab information from your Jira instance with the help of JQL queries and display a dynamic automatically created table right in Confluence. Furthermore, if your company uses our Table Filter and Charts for Confluence app that…

Yes, you are right - if you exclude the Pivot Table macro and create a sequence "table <- Table Filter <- Chart from Table" then without pagination the chart will be based on the filtered table and when you click its pie sections/bars the table under the chart will be filtered once more as well accordingly to the selected…

Yes, you are right - the Table Transformer macro is based on the AlaSQL library.

There are no any limitations in macro usage - what do you mean by "you can't wrap the final Transformer into the Table Filter macro"? Try to paste the new empty Table Filter macro on the page, then copy the whole sequence of the macros and reused tables, place the mouse cursor inside this Table Filter macro and paste the…

Hi @Chris , We can suggest trying our app - Table Filter and Charts for Confluence. The add-on provides the Table from CSV macro that allows you to output data from Google Sheets and Google Drive. The recreated table can be further filtered, aggregated and visualized. And the second option is to use the Table Spreadsheet…

I really don't see how the source page title is supposed to be shown in the result table. The table is grouped so each row with the final status will have up to three page titles. As I understand from the previous posts, you want to visit the source pages if the final status is not green (if the source statuses are yellow…

I mean not for the aggregated table, of course, everything will be mixed up there, but to reuse your source tables once more and to show Page Titles for the quicker navigation to the pages with Excerpts.

We have an opportunity to show the source page metadata (Page Title) in the Table Excerpt Include macro - does this option work for you?

Use the FORMATWIKI option in the external Table Transformer macro to set colorful statuses: SELECT *, CASE WHEN T1.'Status' LIKE "%Red%" THEN FORMATWIKI("{status:colour=Red|title=Red}") WHEN T1.'Status' LIKE "%Yellow%" THEN FORMATWIKI("{status:colour=Yellow|title=Yellow}") ELSE…

To filter tables in Confluence, you need additional apps. Please, specify which add-on you recommend. For example, we suggest using our Table Filter and Charts for Confluence and its Table Filter macro (see the answer above).

To filter tables in Confluence, you need additional apps. Please, specify which add-on you recommend. For example, we suggest using our Table Filter and Charts for Confluence and its Table Filter macro (see the answers below).

Try this modified SQL query for the internal Table Transformer macro: SELECT 'PR#', FORMATWIKI(SUM('Highlights' + " \n")) AS 'Highlights', FORMATWIKI(SUM('Next Steps' + " \n")) AS 'Next Steps', SUM(IFNULL('Status', "") + " ") AS 'Status' FROM ( SELECT * FROM T* WHERE 'PR#' IS NOT NULL ) GROUP BY 'PR#'

Hi @Ronald Kwan , If by filters you mean the Table Filter and Charts for Confluence app and its Table Filter macro, then we talk about our app. As @Pramodh M mentioned before, the New Cloud Editor doesn't support macro nesting (for example, Expand within the Table Filter macro). So to make your big tables more…

Hi @Peter Liu , The Table Filter and Charts for Confluence app is our add-on. The example that you are referring to allows you to count empty/checked checkboxes inside the table cells. And in your example I see that you use some 3rd party app that collects votes (screenshot 1) and gives you a summary report (screenshot 3).…

Hi @Matt Harlow , If your company uses our Table Filter and Charts for Confluence app, then there is a workaround using the Table Transformer macro: SELECT T1.'Project', T1.'Issues'->split(" ")->0 + " Your Ending" AS 'Issues' FROM T* The only tricky moment is that the clickable links to your Jira issues will be lost. But…

And here is a more beautiful solution from our developers: The internal Table Transformer macro SELECT 'PR#', SUM('Highlights' + " ") AS 'Highlights', SUM('Next Steps' + " ") AS 'Next Steps', SUM('Status' + " ") AS 'Status' FROM ( SELECT * FROM T* WHERE 'PR#' IS NOT NULL ) GROUP BY 'PR#' The external Table Transformer…

Thought I'd better take screenshots for the blank PR#, Table Filter and reversed filters. Here are your modified tables with empty PR# cells: Here is how your result table will look after the last Table Transformer macro: Now we need to set a reversed dropdown filter for "Empty" PR# value with the help of the Table Filter…

1. I see from your screenshot that you are trying to group an unmerged table: there are two tables in a kind of a panel macro. In my example I used a separate Table Transformer macro to merge the table into a big combined one and then used another Transformer to group my entries. 2. We group our entries by PR#, if a blank…

Hi @Rafi Ahmad , We can suggest the following steps: Here I merge my manually created tables via the Table Transformer macro but you can use the report function of the Table Excerpt Include macro as you reuse your tables via the Table Excerpt macros. As a result, you'll get the following table: Now we use the Table…

Hi @david cornelius , We can suggest trying our app - Table Filter and Charts for Confluence. There are two options how to achieve your case: Option one. Use your original Excel file, connect it to your Confluence page via our Table from CSV macro, add additional columns with the help of the Table Transformer macro and…

Hi @Jes Holden , What concerns the first question, the Task Report macro works the same for me too - it transforms the dates from the datepicker into the format that you've described. What concerns the second question, the Table Filter and Charts for Confluence app is our app and it's a strange behavior for the macro…

Hi @daryl , Sometimes the Excel macro won't display very complex formulas - don't know if this is your case though, but I came across such thing several times. You may browse the Atlassian Marketplace for the apps that recreate Confluence tables from CSV attachments (I think there are even free apps). Our app that is Table…

Hi @MIchael Maziarz , The standard macros to accomplish your goal are indeed the Page Properties/Page Properties Report macros mentioned by @Pramodh M. If your data (text, dates, statuses, etc.) is updated in the mini-table that you collect with the help of the Page Properties macro, then the same changes are reflected on…

Hi @Sasko Moraliev , Sometimes the Excel macro won't display very complex formulas - don't know if this is your case though, but I came across such thing several times. You may browse the Atlassian Marketplace for the apps that recreate Confluence tables from CSV attachments (I think there are even free apps). Our app that…

Hi @SGANDHAM , We can suggest trying our app - Table Filter and Charts for Confluence. The add-on works for Data Center/Server and Cloud hostings. You'll be able to filter your table on the fly from the page view mode with the help of the Table Filter macro, aggregate data with the help of the Pivot Table macro, visualize…

Hi @Kajal Kuwar , We can suggest trying our app - Table Filter and Charts for Confluence. The add-on works for Data Center/Server and Cloud hostings. You'll be able to filter your table on the fly from the page view mode with the help of the Table Filter macro, aggregate data with the help of the Pivot Table macro (it…

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…

Hi @KathyN , The Table Filter and Charts for Confluence app is our add-on and it's available for Cloud/Server/Data Center. Our macros support dynamic Confluence macros such as Jira Issues, so you'll be able to combine it with manually created table with notes, statuses and comments, perform filtration and aggregation on…