Katerina Kovriga {Stiltsoft} Expert

Hi @Lauren Bertsch , It is a strange behavior indeed - it's understandable why the macro can't be inserted inside the Excerpt macro: Confluence Cloud doesn't allow macro nesting. But it's not clear why the macro is always wants to be placed inside the Excerpt. Maybe the page is rather overloaded for Cloud - sometimes we…

Hi @RIchard Gwatkin , We can suggest trying our Table Filter and Charts for Confluence app (available for Cloud and Server/Data Center). The add-on supports the Jira Issues macro and you'll be able to filter and aggregate data from the page view mode using the Table Filter and Pivot Table macros. If you need to go further,…

Hi @neetubhatt , We can also suggest our Table Filter and Charts for Confluence app and its Chart from Table macro. The macro supports various kinds of graphs and dynamic tabular Confluence macros such as Content Report Table. If you need to calculate totals and show percentage, the Chart from Table macro can be amplified…

Hi @Michael Hamilton , You've also mentioned that you "tried to add through filter table data" - do you mean that you tried to add sorting using our Table Filter and Charts for Confluence app and its Table Filter macro? Do you have a header row for your table as @Fabio Racobaldo _Catworkx_ has mentioned before? The sorting…

Hi @Adam Hardesty , As @Ste Wright has kindly mentioned, the Table Toolbox, Table Filter and Chart from Table macros are provided by our app - Table Filter and Charts for Confluence. If you can't find these macros in the macrobrowser, you may ask your Confluence administrator if the app is installed for your instance. If…

Unfortunately, I don't have any ideas. The Table Transformer macro won't be of any help because we can't put any splitting logic inside its query. Maybe you should try to post another question with a different topic (smth regarding "Custom Jira field is poorly displayed in Confluence") and add Jira Issues macro to the…

Hi @Laurie Huth , If I got the case right, in the original table coming from the Jira Issues macro you have a plain row of words without any separations: |Client Outreach Client Training Tech Letter VBN| Then you just add the "External:" expression to the beginning with the Table Transformer macro. The problem is that we…

Hi @Lauren Bertsch , It's a strange behavior indeed, please check if other macros provided by the Table Filter and Charts for Confluence app have the same behavior. Try to insert, for example, the Pivot Table or Chart from Table macros. Yesterday we released a new version of the app - maybe the add-on was updating for your…

Hi @Dave Collins , We are glad that our Table Filter and Charts for Confluence app helps you with everyday routine work and reports. Thanks for sharing the case!

Hi @Lauren Bertsch , We don't encounter similar issues with the app. Do all the tables wrapped in the Table Filter macro have similar behavior? Do you see any errors when the page is published? Something similar to "Can't get the macro details" or smth? It means that your table exceeds the 2 Mb that is a limitation for the…

Hi @PA BRISON , As for now your case is not possible, but we've added your idea to the backlog. You may still try the following workaround: Check both transpose options in the Table Transformer macro: Use the following SQL query: SELECT *, FORMATWIKI("[" + T1.'Key' + "|" + "https://mycompany.com/" + "]") AS 'Key' FROM T*…

Change the highlighted line to FORMATWIKI(SUM(FORMATDATE('Due'))) AS 'Expected Impact Date', It should work this way.

Hi @Laurie Huth , Please try the following settings for the Table Transformer macro: Set the required Date Format that you want to see in the result table: And use the following SQL query: SELECT T1.'Key', FORMATDATE(T1.'Due') AS 'Expected Impact Date' FROM T1 Hope this helps.

Due to the time zones difference I've seen the answer with the update. ) Glad that the case has worked for you. It's really a bit complicated especially for Cloud.)

Hi @Fred Fredson , Maybe it happens so that you use our Table Filter and Charts for Confluence app? You may browse, for example, for the Table Filter macro in the macrobrowser. Then you may use the Chart from Table macro instead of the standard Chart macro - our macro is more flexible and customizable (regarding colors as…

Hi @Garry Marron , We also have several YouTube videos regarding tables in Confluence Cloud, for example, this and this one. The first part of the video is related to standard Confluence tables (how to insert them, add/delete rows/columns, etc.) - this may come in handy for the case. The second part shows how to amplify…

Your bottleneck comes from Confluence Cloud - you can't nest macros in Cloud (I mean wrap them inside each other). So, because of this our Table Toolbox macro was developed (for Server/Data Center you may wrap macros directly). It comes so that if your first table is wrapped into the Page Properties macro, you won't be…

Hi @Sandeep_Sharma , We can suggest using our app - Table Filter and Charts for Confluence. It's available for Cloud/Server/Data Center. This case is a common one for the app: you reuse your source table as many times as you need with the help of the Table Excerpt/Table Excerpt Include macros (on the same page or other…

Hi @Craig Jack , We can suggest trying our Table Filter and Charts for Confluence app. You may recreate each table for the child pages using the Table from CSV macro (restore the tables connecting your Google Spreadsheets to Confluence via url). Then you may collect all the child tables into one big master table using the…

You may also check this Community thread regarding the Table Transformer macro https://community.atlassian.com/t5/Confluence-questions/Table-Filter-Macro-using-Variable-as-Input/qaq-p/1733811 

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.

Hi @Donna Dowie , As a workaround we can suggest trying our Table Filter and Charts for Confluence app (its Pivot Table macro in particular) in combination with the standard Content Report Table macro. You'll be able to count how many pages were created by this or that author but, unfortunately, without the given time…

We also develop the app that adds a lot of Excel functions to Confluence - you may check the Table Filter and Charts for Confluence add-on. You'll be able to filter, aggregate, visualize and perform calculations with manually created tables and tabular Confluence macros (Page Properties Report, Jira Issues, Content Report…

Hi @Abbie.Alcock , Are we talking about a 3rd party app? Have you tried to reach to their support?

Hi @Daphne Goh , The app kindly mentioned by @Benjamin is ours - the Table Filter and Charts for Confluence add-on. As you can see from the the Community thread, it seems that our Table Transformer macro can fulfil your case. Maybe you'll be interested in a live demo from our team - we'll be glad to assist, please book a…

Hi @[deleted] , With the standard Excerpt/Excerpt Include macros you won't achieve the case - Cloud tables don't support nesting, you won't be able to put any macro inside the cell. But you'll be able to reuse the whole table.

Hi @Jason Boyle , The Table Toolbox macro comes with the Table Filter and Charts for Confluence app (along with the Table Filter, Pivot Table, Table Transformer, Table Excerpt Include macros, etc.). You may check if these macros are available in the macro browser or ask your Confluence administrator if the app is still…

The changes are pushed only through Excepts to Excerpt Include macros. I mean that you have one real source table wrapped in the Excerpt macro and all the changes are made to this table. The Excerpt Include macros allow you to reuse this table as many times as you need. But they are not real physical tables, they are not…

Hi @ray scott , Didn't mean the exact screenshots - just images of manually created tables with dummy data before and after the required transformation. If I got the case right, you want to transpose the table. Here are two options: the Table Transformer macro to transpose the whole table and the Table Transformer macro on…

You may look into the standard Excerpt/Excerpt Include macros. There won't be such flexibility as 3rd party apps provide, but you'll be able to reuse your source table on other pages.