Katerina Kovriga {Stiltsoft} Expert

Hi @srilata H , You'll need additional apps to work with JSON files in Confluence, for example, the Table Filter and Charts for Confluence app and its Table from JSON macro. The macro allows you to output a table from JSON data source (URL or an attached file). And you'll be also able to work with your table further:…

Hi @B Neha , To filter your Jira Issues macro right on the Confluence page (not with the JQL inside the macro body) you'll need to use additional apps, for example, Table Filter and Charts for Confluence. Its Table Filter macro works with dynamically changing macros such as Jira Issues, Page Properties Report, etc.…

Hi @Marcel Viehmaier You may use the Table Filter and Charts for Confluence app to filter the Jira Issues macro, create pivots and real-time dashboards right in Confluence. For example, for your case you may wrap you Jira Issues macro into the Pivot Table macro and create the required table (as we don't have different…

Hi @LoupGarou , If you have the Table Filter and Charts for Confluence app installed for your instance, you may use its Table Excerpt/Table Excerpt Include macros that allow you to collect tables within multiple pages and spaces searched by: * page names * page trees * labels If you choose the latter option, then you won't…

Hi @n.derosa , You may try to use the Table Filter and Charts for Confluence app and its Chart from Table macro. Here you may see hints with exact numbers while hovering your mouse above the graph line: The Chart from Table macro also provides a wide range of graph types and supports dynamic Confluence macros (Jira Issues,…

Hi @Vinay Sharma , The Table Filter, Pivot Table, Chart from Table and Table Transformer macros are provided by the Table Filter and Charts for Confluence app. The app works both with Cloud and Server/DC hostings. So, if you can't see the macros, it means that the app is not installed for your Confluence instance.

Hi @Marius Sterling , If you have the Table Filter and Charts for Confluence app installed for you instance, we can suggest using the following workaround: collect your report by labels only and filter it with the help of the Table Filter macro (you may use different kinds of filters for each separate column, for example,…

Let's wait for the @Alex Medved _ConfiForms_, maybe they have any native solutions without additional apps.

Hi @Stefan Vogt , If you have the Table Filter and Charts for Confluence app installed for your instance, you can use its Table Filter macro with the Number range filter applied. The Table Filter and Charts for Confluence app is fully compatible with the ConfiForms app.

Hi @Ashok Ambigapathy , We can suggest using the following workaround: export your table without the Export Clickable Links option enabled. Then your hyperlinks will be exported as a plain text: www.abc.com instead of the =HYPERLINK("http://www.abc.com/";"www.abc.com"). When you import your table, wrap the Table from CSV…

Hi @Ryan McNamara , the macro mentioned above belongs to the Table Filter and Charts for Confluence app that helps you to filter and aggregate data (manually created tables and all the tabular macros such as Page Properties Report, Jira Issues, etc.). Please book a live demo and we'll be happy to show all the main features…

Hi @Emily Berg , Not to mess up the original query, I suggest wrapping your second table with the combined TER Key into a separate Table Transformer: Use the following SQL query to split your strings by the " | " symbols: SELECT T1.'TER Key'->split(" | ")->0 AS 'TER Key', T1.'TER Key'->split(" | ")->1 AS 'Description',…

Hi @Stefan Vogt , You may also check if you have the Table Filter and Charts for Confluence app installed for your instance - the Table Filter macro supports ConfiForms, so you'll be able to filter your table using our macro and export only the filtered results into pdf, CSV and Word formats. 

@Alexander Bondarev , unfortunately we don't have any solution to the no-access to Jira. Our dashboards use the standard Jira Issues macro for the data source - as usual, managers have access to the full package of Atlassian products, but they prefer to use Confluence for their reports and not to switch between Confluence…

Our app is compatible with the Advanced Tables by Bob Swift, but unfortunately I can't check the compatibility of the SQL for Confluence output right now. Please try to insert the Table Transformer macro first, put your mouse cursor inside its body and insert the SQL Query macro. And what is your source for the SQL Query…

Hi bqiao@vmware.com , I guess that you use the Table Filter and Charts for Confluence app and its Table Transformer macro to reorganize your table. Please go to this page and follow the example to make your result links clickable. Let us know if everything works fine for you.

Hi @Marduk Bolanos , We can suggest fulfilling all the standard and custom Jira fields without any enrichment and display the issues via the Jira Issues macro onto your Confluence page. Then you may combine your Jira Issues macro with a manually created table and add whatever information you need right in Confluence.…

Hi @Mark Emerson , To filter tables (aggregate your tabular data and visualize it) you'll need to have additional apps from the Atlassian Marketplace. We can suggest using the Table Filter and Charts for Confluence app. It works both with manually created tables and CSV attachments or Spreadsheets (you'll need the Table…

The Table Filter and Charts for Confluence app allows you to create dashboards based on the Jira Issues macro both for Cloud and Server/DC. The only difference for the Cloud type of hosting is that you'll need to use the Table Toolbox macro to nest several macros, other steps won't differ from the documentation. If you…

Hi @Moria , You'll need additional apps to filter the Jira Issues macro, for example, the Table Filter and Charts for Confluence app. Wrap your Jira Issues macro into the Table Filter macro (or enable the Live Filtration) and you'll be able to filter your issues by keys, dates, priorities, statuses, etc. (similar to…

Hi @Michael Rosenthal , The Table Filter and Charts for Confluence app supports the Jira Issues macro and allows you to create Jira dashboards right in Confluence. For example, at first you make a pivot table for your issues counting how many of them have this or that status. The next step is to visualize this table. When…

Hi @Rasmus Alenkær-Jørgensen , We can suggest using the Table Filter and Charts for Confluence app to partly fulfill your case. You can have multiple customer reports across your Confluence instance that are collected into one big combined report with the help of the Table Excerpt/Table Excerpt Include and Table…

Hi @Wade Henderson , There are no such features out-of-the-box, the closest macro for this case is the Page Properties Report macro that you've mentioned yourself. But you may try additional apps, for example, Table Filter and Charts for Confluence app. Here is a step-by-step guide how to aggregate multiple tables onto one…

Hi @Marcin Woroch , Our team successfully uses the JEditor app - at first they had only canned responses available, but listened to our request about specific signatures and provided a new version of the app. Thanks for the reply!

Hi @Joseph Lee , The standard Chart macro can't work with dynamically updating tables such as Jira Issues macro, Page Properties Report macro, etc. It may even show the corresponding graphs into the preview but they will disappear after publishing the page. To work with such dynamic table-form macros (filter them, create…

Hi @Carole Jones , Do you use the Jira Issues macro to get your report? Try to check the JQL query inside the macro body.

Unfortunately, there is nothing similar that I can come up with with the standard Confluence tools. A kind of a workaround is to create templates with instructional text where you list all the available variants of the cell info for your users to choose from and manually type in.

Hi @Mischa Gulseven , We don't know about any limitations for the size of manually created Confluence tables (they are supposed to be unlimited) but we are aware that sometimes you can experience unstable behavior with really large tables. As a workaround, we suggest using apps that allow you to recreate tables from the…

For such case you should use the Table Transformer macro: SELECT COUNT (DISTINCT (T1.'Release')) AS 'Number of releases' FROM T*

Hi @Mzzhsl , There are no any built-in macros that allow you to create dropdown lists in Confluence. But there are a lot of apps with similar functionality. For example, you may check the Handy Macros for Confluence app and its Handy Status macro. The macro allows you to create a predefined list of statuses, insert them…