Katerina Kovriga {Stiltsoft} Expert

Hi @Michael Gracias , We can suggest trying our app - Table Filter and Charts for Confluence. It's Table Filter macro will help you to filter your report by Page Titles and by the pages that contain any specific text in the related decisions: Hope this may help your case.

Hi @David O_Connor , There is no filtering options out-of-the-box, so you'll need 3rd party apps to implement your case. We can suggest trying our add-on - Table Filter and Charts for Confluence. Its Table Filter macro allows you to filter your tables easily from the page view mode. Besides filtering, you'll be able to…

Hi @Lukas MIglbauer , we can also suggest trying our app - Table Filter and Charts for Confluence. The add-on provides the Table Excerpt/Table Excerpt Include macros that allow you to collect/reuse data from * Current page * Specific page * Page and childpages * Page and all descendants * Pages with labels You'll be able…

Hi @Emily Berg , We can suggest adding an extra step to the case - the Pivot Table macro. Via the Table Transformer macro you simply merge the two tables as @Grigory Salnikov has suggested. And via the Pivot Table you group the result table by the SR Key. Here we use the bullet point for items - so it is easy to see how…

Hi @Cameron Davis , We can suggest trying our app - Table Filter and Charts for Confluence. The add-on provides the Table Filter macro - wrap your Task Report into its body, choose to show any columns you need via the Task Report macro settings and filter them easily from the page view mode: Hope this may help your case.

Hi @Abhisek Dey , Here is an example of our complex live dashboard: Edit mode View mode As you can see, we have plenty of macros inside the Column macro and everything looks correctly. Your screenshot shows that even standard Confluence macros (Excerpt Include) don't work properly - maybe something is wrong with the page…

Hi @Abhisek Dey , As @Fabienne Gerhard has mentioned, you should use Columns inside of your Section macros. As official documentation says, "You should always have at least one column macro within a section macro". We often use 2 or 3 Columns within the Section macro ourselves when we create different dashboards (we reuse…

Hi @Yongjie Chen , If to consider standard Confluence macros, then you can use Page Properties/Page Properties Report macros. You will be able to collect one-row tables into one big summary report - when the data into your source mini-tables changes, the report is automatically updated as well. If you need to collect…

It seems that the macro doesn't like the '{' and '}' symbols - try to replace them as %7B и %7D respectively. Besides, the Sharepoint accounts may still prevent the macro from getting your data (even with the correct link format). Unfortunately, nothing can be done at the moment. We suggest using the Google Spreadsheets…

I assume that '&' is used in every table you merge, not only in the third one that causes trouble. If I try to merge tables with '&', '*' and other specific symbols in the headers, everything goes fine for me. Please raise a support ticket and attach the page storage format (I've described it in the first answer) of the…

Hi @Guy Toyber , Here is the Stiltsoft team again - we've remembered your issue from our support. Now we are watching this question as well - if there are any hints from the other app's team, we'll definitely try to cooperate.

Hi @emagnun , We may suggest using our app - Table Filter and Charts for Confluence. The add-on provides the Table from CSV macro that allows you to output a table from CSV or TSV data source. The macro supports outputting data from a URL/Google Spreadsheets or an attached file. Then you may work with the data as with…

Hi @Sopaboba , I've got that you want to use only ConfiForms app for the issue and we'll wait for the representatives of their team to post an answer, but in case other Community members will come across this question - it's a common situation that they have two apps: ConfiForms and our Table Filter and Charts for…

You need to be an administrator of your Confluence instance - you'll got a 1 month of free trial of the app, so you may install it and decide if it really suits your needs.

Do you mean the standard Confluence Chart macro? It really doesn't support Page Properties Report macros or dynamically changing CSV files via a URL. If this is the case, then you also need to check third party apps - again your may check out Table Filter add-on and its Chart from Table macro that is more flexible,…

@Robert Mang , I've consulted with our developers and they have a more beautiful solution: SELECT SUM(DISTINCT T1.'email' + ";")->slice(0, -1) as 'Email List' FROM T1 WHERE T1.'ART_Role*' LIKE "SM" Hope this helps your case.

Hi @Robert Mang , I can suggest the following workaround: wrap your table subsequently into the Table Transformer and then into the Pivot Table macro. Go to the Table Transformer settings: SELECT DISTINCT T1.'email' as 'Email List', T1.'ART_Role*' FROM T1 WHERE T1.'ART_Role*' LIKE "SM" Here we use the DISTINCT command and…

Paste the Table Toolbox macro on the page and save it. Then paste your tables or Excerpts inside the Table Toolbox macro body - you don't need to paste Table Filter or Table Transformer anywhere. Then go to the Table Toolbox macro settings and make the required macro combination there, inside this macro and not directly on…

Hi @Manali Butey , Unfortunately you won't be able to implement the case - the behavior of the Table Transformer macro is correct for this situation. As a macro developed for tabular data and Ala SQL queries, it specifically gets rid of the merged cells to work with them later. We understand the visual appeal of the merged…

Hi @Alex Warner , The new Cloud editor doesn't support direct macro nesting - please use the Table Toolbox macro. The macro was developed for Cloud specifically and allows you to nest the macros provided by the Table Filter and Charts for Confluence app in all possible combinations.

Our macros support the dynamic Confluence macros, but they should be in a tabular form (for example, Jira Issues, Page Properties Report, Content Report Table). The Agile Wallboard gadget looks like a Kanban board or smth - it's not a table. The Table Transformer macro will mess up all the formatting. If you have our app,…

Hi @Michael Woeckener , To create a table in Confluence that dynamically outputs data from your Jira instance, you may use the standard Jira Issues macro. If you need to add additional manually created notes to this automatically generated table, you may use our app - Table Filter and Charts for Confluence. This community…

Hi @kkarthiii29 , Maybe you need to show Jira custom charts in Confluence? I've found two separate apps: one is for Jira and the second one is for Confluence. Or do you want to create beautiful charts based on the dynamic Confluence macros such as Page Properties Report? Can't really get what custom chart/gadget you need.…

Hi @Grace Dowling , We can suggest the following workaround using our app - Table Filter and Charts for Confluence. The add-on provides the Table Transformer macro that is often used for table calculations, conditional formatting and cells' adjustment. The latter could be a workaround for your case: wrap the Jira Issues…

Hi @Kusai Mansawala , You may use the standard Excerpt/Excerpt Include macros to collect information from different pages on the one specific page. And you may also use the Table Excerpt/Table Excerpt Include macros that are provided by our app - Table Filter and Charts for Confluence. These macros are more flexible and…

I've checked our test instance, unfortunately we don't have any suitable environment (issues with story points) to make a quick demo video. But the last link contains a bunch of screenshots for you to follow - if you get stuck, you may raise a support request, attach the screenshots, we'll recreate them and guide you…

Try to merge your tables via the Table Excerpt Include - maybe it could help the case. And what do you see if you exclude the third table from the merging process? This transposed table breaks the tables' pattern and prevents other tables from merging correctly. Maybe something is wrong with this specific table? Its…

Hi @Priyanka khare , If you use the Table Filter and Charts for Confluence app (that is our add-on) for table filtration and data aggregation, you may as well use it to create Jira reports right in Confluence. The app supports the standard Jira Issues macro, so you'll be able to calculate and visualize any data you need -…

Hi @Donna Macauley , We can also suggest trying our app - Table Filter and Charts for Confluence. The add-on supports the standard Jira Issues macro and allow you to create various Jira reports right in Confluence. Here is a step-by-step guide related to the velocity calculation.

Hi @Hannah Sullivan , Please check what version of the Table Filter and Charts for Confluence app is installed for your instance - the current one is 7.9.21. If you use an older one, please update the add-on. Then you may try to exclude the Table Transformer macro from the case and merge the tables directly via the Table…