Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hello @Dailin Young , With the help of Table Filter you can both count total for columns and add Total column with the needed operation type. Is it what you need? Best regards, Katerina

 @fbunting, I think I've got what you need, please try our Table Transformer macro in your case. Wrap you rable with it and use the SQL query like this: SELECT * FROM T1 WHERE T1.'COLUMN 1' <> T1.'COLUMN 2' Best regards, Katerina

Hi @Dailin Young . Could you send us screenshots for better understanding? Thanks! Best regards, Katerina

Hi @fbunting You can filter rows not equal to selected values with the help of the Table Filter macro of the Table Filter and Charts for Confluence app. Wrap your table with Table Filter, switch to the Filters tab, select the dropdown filter column and add values (text1, text2) to it, then switch to the Filtration tab,…

Hi @Albert Gil , To remove "issues" from JIRA Issue/Filter macro, you can use the Table Transformer macro of the Table Filter and Charts for Confluence app. Please wrap your table with it and use REPLACE() function in your SQL query: By the way, our app also includes Chart from Table macro which allows you to create Radar…

Hi Felipe, You use Table Transformer in this case, right? If so, unfortunately, it's not possible to keep the same view of Page Properties Report using our macro. We have this improvement in our backlog. I can add your vote for it. We are waiting for your feedback. Best regards, Katerina Stiltsoft

Hello, We can recommend you to try our app - Table Filter and Charts for Confluence: Please wrap your Task Report macro into the Table Filter macro and apply different kinds of sorting. Best regards, Katerina Stiltsoft

Hi @Edgar BM , I would advise you to try using standard Page Properties Report macro and Table Filter of Table Filter and Charts for Confluence app in this case. Please note that the Page Properties macro detects only the first row of the table. 1.Wrap tables where dates are in the first row with Page Properties .…

Hi @[deleted] , You may use your Page Properties Report with Table Transformer of the Table Filter and Charts for Confluence app. It leads to this view like you have now. Best regards, Katerina Stiltsoft

Hello, We can recommend you our Table Filter and Charts for Confluence app to work with Jira Issues macro in your cases. You'll be able make pivots to count, for eхample, the numbers of issue types and display issues per assignee (or user stories per epics), also sort your issues on the fly like in Excel, save the required…

Hello, I think I have a solution for your use case if you use Confluence Server or Data Center. The Table Excerpt Include macro of the Table Filter and Charts app supports multi-export from pages by labels . The app also includes the Table Transformer macro that provides merging tables and any other kinds of table…

Hello @Mark Schlaudraff, You can try the Pivot Table Macro of our app - Table Filter and Charts for Confluence in this case. You just need to wrap the PPR macro with Pivot Table and configure it as you need. Please note that you can try one month of a free trial : install the app with an evaluation license and "play" with…

Hi Shunta, You can try the Table Filter macro of the Table Filter and Charts for Confluence app in this case. But you need to rename column 'Type' of the manually created table to 'T' (as in Jira Issue) and use visual icons of Jira Issue types (copy them from the Jira Issue table) instead of text in this column. Then wrap…

Hi Natalia, I would recommend you to try the Table Filter and Charts for Confluence app to visualize your table data. Just wrap your source table (e.g Jira issue) with the Chart from Table macro and configure it. In your use case, it's better to choose the Column type then Pie. Thus, the values of both Time Spent and…

Hi Kedar, You can do it with the help of Table Excerpt (Include) and Chart from Table macros of the Table Filter and Charts for Confluence app. 1.Wrap your source table (in a common location) with Table Excerpt. 2.Insert Table Excerpt Include on the page for reporting. 3.Wrap it with Chart from Table and configure its…

Hi Irina, If you need to keep your data safe and secure, you can try the following way using Table Transformer, Table Excerpt (Include) macros of Table Filter and Charts for Confluence: Please divide you data into two pages. The first one should contain data which are available for public view. And the secound one should…

Hello, You can do it with the help of the Table Transformer macro of Table Filter and Charts for Confluence and standart Excerpt (Include). You need to divide you data into two pages. The first one should contain data which are available for public editing. And the secound one should include only those data which other…

Hi David, There's a way which you can do with the help of the Table Transformer macro of Table Filter and Charts for Confluence and standart Excerpt (Include). You need to divide you data into two pages. The first one should contain data which are available for public editing. And the secound one should include only those…

Hi Nishant, You can do it with the help of Table Filter and Charts for Confluence. The Table Excerpt (Include), Table Transformer macros are appropriate for your use case. Here's an example on how to use them: First, you need to wrap all required teams' tables with the Table Excerpt macro. Then add the Table Excerpt…

Hi Nishant, You can do it with the help of Table Filter and Charts for Confluence. The Table Excerpt (Include), Table Transformer macros are appropriate for your use case. Here's an example on how to use them: First, you need to wrap all required teams' tables with the Table Excerpt macro. Then add the Table Excerpt…

Hello Randall, There are Table Excerpt and Table Excerpt Include macros in the Table Filter and Charts for Confluence app which could help you in this case. Here's an example on how to use them: 1. Wrap your source table with Table Excerpt. 2. Insert the Table Excerpt Include macro on another page and configure it. Result:…

Hello Sandeep, If your Confluence site is connected to a Jira application, you can create and display Jira issues on Confluence pages and then try to resolve this use case with the help of the Table Filter and Charts for Confluence app. 1. Choose Sprints you need with the help of JQL in Jira or add the Table Filter macro…

You're welcome, Matthias :) Thanks, you too! Katerina StiltSoft

Hello Matthias, Let's try to replace that SQL query for the following: SELECT *, ROUND(DATEDIFF(day,'Begin date','End date'))+ " days" as 'Duration' from T1 Regarding the second question, you need to wrap the Page Properties Report macro with Table Transformer at first and then add Table Filter. Best regards, Katerina…

Hello Matthias, This use case can be resolved with the help of the Table Filter and Charts for Confluence app. You can wrap your Pape Properties Report with the Table Transformer macro and enter the following SQL query: SELECT *, DATEDIFF(day,'Begin date','End date')+ " days" as 'Duration' from T1 Please find our…