Katerina Kovriga {Stiltsoft} Expert

Hi @Subrata Mukherjee , I've tried to complete the similar task - aggregate the number of created issues by month and by quarter. Here are my settings: Jira Issues&Pivot Table macros Count issue keys by the date of creation Aggregation by month Aggregation by quarter As you can see, I didn't change the automatically picked…

Hi @Stella Wong , You may try the Table Filter and Charts for Confluence app. Wrap your Jira Charts macro in the Table Filter macro and hide the columns that your don't want to see. Here is an example of our Jira Chart: I use statuses instead of labels, but it is just an example - we simply don't use enough labels to…

Hi @Kajsa , We can suggest a workaround with the help of the Table Filter and Charts for Confluence app. Wrap your Task Report in the Table Toolbox macro and create the following nesting: Task Report <- Table Transformer <- Table Filter macro. Go to the Table Transformer macro and create a custom SQL query: SELECT *, CASE…

Hi @Martin Rodriguez , You may try to use the Table Filter and Charts for Confluence app. Wrap your Attachments macro in the Table Filter macro and choose the most suitable option: Option 1 - Limit the number of displayed rows Option 2 - Use pagination Hope it will help your case.

Hi @llatore , You may try the Table Filter and Charts for Confluence app and its Table Transformer macro with the wiki markup feature. Wrap your table in the Table Transformer macro and use a custom SQL query to color your cells and/or text: SELECT FORMATWIKI("{cell:bgColor=yellow}" + T1.'Rep' + "{cell}") AS 'Rep',…

Hi @Greg , As I can see, the standard Chart macro can be only saved as a png file attached to this or that page. If you want to create a graph based on the CSV attachment, use the Table Filter and Charts for Confluence app. The first step is to use the Table from CSV macro to show your CSV-attachment on the Confluence page…

Hi @Vigfus Andersson , You can use the Table from CSV macro provided by the Table Filter and Charts for Confluence app. Specify the URL of your CSV file within the macro body, and your result table in Confluence will be updated automatically.

As far as we know, there are no any filters in Confluence out-of-the-box. So the only workaround would be different JQLs for your Jira Issues macro.

Hi @Suryaprakash Thonupunuri , Try to use custom colors in the HEX format for the standard Chart macro: If you don't want to browse for the HEX formats, you can use the Chart from Table macro that is provided by the Table Filter and Charts for Confluence app. This advanced macro will help you to create a wide range of…

Hi @Mouslim MITALI , Do you use Confluence or work strictly in Jira? The case is we have the Table Filter and Charts for Confluence app that works with the Jira Issues macro perfectly well and helps to calculate, aggregate and visualize data. Here we have an example how to get the sum of story points for every sprint…

Hi @Constantine Samaklis , We have an app that works with the Jira Issues macro and helps to aggregate&visualize your Jira data (calculate story points, create Burndown charts, etc.) - Table Filter and Charts for Confluence. Here is an example how to calculate velocity right in Confluence with the macros provided by the…

You can use the Table Filter and Charts for Confluence app to sort your Confluence tables. Just wrap your table in the Table Filter macro and apply the default sorting order:

Hi @tqtam , You may try the Table Filter and Charts for Confluence app. Wrap your Jira Issues macro in the Table Filter macro and set a freetext filter for the summary column: Your colleagues will be able to type in any phrases they want (in the View page mode!) and retrieve relevant issues.

Hi @Garret Moreno , Try the Table Filter and Charts for Confluence app. Wrap your Attachments macro and an additional table with the required columns in the Table Transformer macro: Then use the following SQL query and look up the two tables by the "File" column: SELECT T1.'File', T1.'Modified', T2.'Status', T2.'Comments'…

Hi @Aditya Aryasomayajula , Do you use Confluence in your company and want to create Jira charts on Confluence pages? If that is the case, we can recommend the Table Filter and Charts for Confluence app. This app may help you to create visualized dashboards using the standard Jira Issues macro.

Hi @Lara Kim Gresak , Try the Table Filter and Charts for Confluence app. This add-on includes the Table Excerpt/Table Excerpt Include macros that will fully cover your case. Here is one of our latest blog posts describing how to reuse tables and aggregate data if required. Hope you'll find it useful.

Hi @Shathya Bhama V R , Sorry that we've missed your question about our Table Transformer macro. Glad that you've find the solution yourself: here is our answer for your second question about the WHEN condition in the Table Transformer SQL query. And for the customers that may come across this question: the task was…

Hi @Ali Tooq , We can recommend our app - Table Filter and Charts for Confluence. It works with the Page Properties Report and Jira Issues macros pretty well and allows you to filter/aggregate your data and create visualized dashboards right in Confluence. Besides you can amplify your Page Properties Report macro with the…

Hi @Shathya Bhama V R , You may try the following SQL queries: Option 1 SELECT *, CASE WHEN T1.'Status' LIKE "Closed" THEN ROUND(DATEDIFF(day,'Open Date','Closed Date'))+ " day(s)" ELSE ROUND(DATEDIFF(day,'Open Date',CURRENT_TIMESTAMP))+ " day(s)" END as 'Aging' from T1 Option 2 SELECT *, CASE WHEN T1.'Status' LIKE "Open"…

Hi @Selma Cuellar , Last year we posted two Confluence video courses on YouTube: * Quick Start for Confluence: basic things for novice Confluence users, 8 videos, 15-20 min each; * Advanced Permission and Security Management in Confluence: for power-users, space administrators and novice Confluence administrators, 6…

Hi @Никита Иванков , We suggest using the Table Filter and Charts for Confluence app. No matter what table you use as a dynamic combined report for your projects (Jira Issues macro, Page Properties Report or just a plain manually updated table - couldn't get it from the question), the second step is to aggregate your data.…

Hi @Shubham Kumar , Check if the Table Filter and Charts for Confluence app is installed for your Confluence instance. The Table Transformer macro can do the trick: just wrap your Page Properties Report macro into its body and don't apply any settings. Plain PPR: PPR with Table Transformer:

You may try to create your original table using the following structure: You split your tables into the two separate ones and further reuse them on different pages with the help of the Table Excerpt/Table Excerpt Include macros. As your Table Excerpt macros are wrapped in the Table Transformer macro body, your original…

Hi @Miguel Fontes and @ivan.sandrini , We can suggest using our app - Table Filter and Charts for Confluence. Wrap your Page Properties Report macro in the Table Filter macro, and your Jira Issues column becomes sortable: Note that you'll also be able to use various types of filters to search across you PPR-report. And you…

Hi @Jean Morawyecki Do you mean the case when you generate a lot of pages with similar multiple-row tables that you need to combine into one big report? We have such case described in our recent blog post. You'll need the Table Filter and Charts for Confluence app for this case. As you'll see from the post, our Table…

Hi @James Sedman , Recently we've posted a blog post that covers your use case - How to Create Reports with Multiple Confluence Tables. With the help of the Table Filter and Charts for Confluence app, you'll be able to collect tables with multiple rows across you Confluence instance, space, or page tree branch. There are…

Hi @Marina Culeasca , I've answered your previous question here and given an example how to reuse and merge two Confluence tables with the help of the Table Filter and Charts for Confluence app. One of these tables can be easily made with the help of the Jira Issues macro (our macros work with this macro as with standard…

Hi @Marina Culeasca , We can suggest trying our app - Table Filter and Charts for Confluence. Wrap your Table 1 in the Table Excerpt macro: Then reuse your Table 1 with the help of the Table Excerpt Include macro and wrap it and your Table 2 first in the Table Transformer and then in the Table Filter macro. Use the Table…

Hi @Juned Shaikh , We can suggest using our app - Table Filter and Charts for Confluence. You'll be able to insert the Table from CSV macro and recreate a Confluence table from the CSV page attachment or Google Sheets/Google Drive document via a URL.

Hi @Matt Wilson , You may check the Table Filter and Charts for Confluence app. You'll need to wrap your Jira Issues macros and an additional mini-table first into the Table Transformer macro and then into the Chart from Table macro. The first step is to sum your story points and count the number of your bugs. If I've got…