Katerina Kovriga {Stiltsoft} Expert

Hi @Ashok Madireddy , You may also watch our one-minute video tutorial about the Table of Contents macro. Hope it will come in handy.

Hi @Steve Hodson , If you have the possibility to somehow pull your data out of the AWS in CSV or JSON format, then you can browse the Atlassian Marketplace for the apps that allow you to create tables based on such files (I think there even will be free add-ons). Our app - Table Filter and Charts for Confluence - is…

Hi @Chelsey Hartman We can suggest using our app - Table Filter and Charts for Confluence (available for Cloud/Server/Data Center). Besides its main features such as filtration, data aggregation and table calculations, the app provides the Table Excerpt/Table Excerpt Include macros. The macros collect both tabular and…

Hi @Carina Elles , The first part of your case is not possible - the Table Filter macro allows you to set static/dynamic automatic row numbering (it will be updated automatically after you insert/delete the table rows). You may read about the available options here. If you want to manually delete the numbers, change them,…

Hi, The Table Filter and Charts for Confluence is our app, and the freezing row option works fine for me on our test Cloud instance. Edit mode: The Table Filter macro settings (the "Table height" field is an optional one): View mode: If the issue persists for you, please raise a support ticket here.

And here is the second option from our team based on the one source table: SELECT FIRST(T1.'Literal of Key') AS 'Key', FIRST(T1.'Linked Issues'->split("-")->0) AS 'Type', FORMATWIKI(SUM("[" + T1.'Linked Issues' + "|https://jsd.stiltsoft.com/browse/" + T1.'Linked Issues' + "]\\ ")) AS 'Issues' FROM T1 GROUP BY T1.'Literal…

Hi @Katie L , Here is the first option from our team: SELECT T1.'Key' as 'Epic keys', T2.'Key' FROM T1 LEFT JOIN T2 ON T1.'Linked Issues'->split(", ")->indexOf(T2.'Key'::string) > -1 SELECT T1.'Epic keys', T1.'Literal of Key' as 'Duplicates' FROM T*

Hi @Katie L , I've checked the SQL query some more and noticed its unstable behavior: if the issues have different count of numbers (ex. P1-23 and P1-234) then they could be matched incorrectly (the P1-23 issue from the second table will match both P1-23 and P1-234 entries from the first table). We'll try to come up with a…

The Stiltsoft team will participate with the Table Filter and Charts for Confluence app (the "Analytics and Reporting" category) and a very funny demo.))))) Let's celebrate the #Apptoberfest together! 🍻

And you may also use an additional Table Transformer macro to rename the second column. Here I've chosen a line break as a literal value delimiter inside the Pivot Table macro settings and used the following SQL query for the second Table Transformer: SELECT T1.'Epic keys', T1.'Literal of Key' as 'Duplicates' FROM T*

As the case seems to be a tricky one, I've returned with a workaround that uses two Jira Issues tables instead of the one original table - please, take a look at the screenshot below: The first tables remains the same: your Epics and their linked issues. The second table should contain only all of your issues with the…

Hi @Katie L , Please attach a screenshot of your Jura Issues table with the marked duplicate issues - maybe the Table Filter macro will do the trick? It is better for us to see the table before suggesting some tips.

It means that the Table Filter and Charts for Confluence app is not installed for your instance - it's a paid addon. To make sure, you may try to browse for the Table Filter or Pivot Table macros - they are also provided by the app. Then you may consult your Confluence administrator and ask if it's possible to evaluate the…

Hi @Gabriele Ientile , We can suggest trying our app - Table Filter and Charts for Confluence. It provides the Table Excerpt/Table Excerpt Include macros that allow you to reuse tabular and non-tabular data. These macros are an advanced version of the standard Excerpt/Excerpt Include macros: for example, you can give…

Hi @[deleted] , We can suggest trying our app - Table Filter and Charts for Confluence. Its Table Filter macro works with the Page Properties Report macro perfectly well, and you'll be able to filter your report from the page view mode and hide any unwanted columns you need. Besides using our other macros such as the Pivot…

Hi @German Patino , We can can suggest trying our Table Filter and Charts for Confluence app. Its Table Filter macro allows you to freeze columns/rows and for the Server/Data Center the freezing remains active for the page edit mode as well. Hope this may help your case.

I think it is not possible out of the box. I've already mentioned our app - Table Filter and Charts for Confluence. Seems like it could cover the case: * use the Jira Issues macro instead of the Jira Chart macro, enter the JQL query, for example, "project = ABC" * reuse this macro as many times as you need with the help of…

Hi @Sunil Kirangi , I'm Katerina from the Stiltsoft team - Table Filter and Charts for Confluence is our app. The addon indeed works with the Jira Issues macro perfectly well and allows you to aggregate and visualize your Jira projects - you'll be able to create dynamic Jira dashboards right in Confluence. Maybe you'll be…

Hi @Sunil Kirangi , Maybe you use the Jira Issues macro instead of the Jira Chart macro? The first macro lists all the issues returned by your JQL query in a tabular form. The second macro aggregates data and presents it as a pivot table/graph (for example, check the Two Dimensional Chart option - it looks similar to your…

Hi @David Matzner , Maybe our app that is Table Filter and Charts for Confluence will come in handy for your case? The app is available for Confluence Cloud and allows you to work with manually created tables and dynamically changing macros such as Jira Issues, Jira Charts, Page Properties Report, etc. You'll be able to…

Hi @emagnun , You've found the right solution with the Table Filter macro and its reversed filters. Hope that it didn't take long and you weren't stuck with the case. What concerns the Table Transformer macro, it comes in handy when you need to display only several columns (not rows!) from a big table. So, you list the…

Hi @Jeni Li , Not sure which is your case, but gonna describe two similar tasks regarding our app - Table Filter and Charts for Confluence (maybe you are using it in your company but only for data filtration, aggregation and visualization). So, here are two more options provided by our app: Option 1. If you want to connect…

Hi @Mirian Camarillo , We can suggest browsing the Marketplace - it seems that there should be even free apps that allow you to create good-looking tables from CSV files/URLs/Google Docs. So, you'll be able to update your local table and all the changes will be reflected on the Confluence page. As for our own app (that is…

Hi @Deepthi B , We can suggest trying our app - Table Filter and Charts for Confluence. You'll be able to connect the database with your Confluence instance using our Table from CSV or Table from JSON macros and then work with your tables with the help of the Table Transformer macro that uses AlaSQL queries. And you may…

Hi @mani.s , We can suggest trying our app - Table Filter and Charts for Confluence (available for Cloud/Server/Data Center). Its Pivot Table macro works similar to Excel and will be perfect for your task: Our app supports all the dynamically changing table macros such as Page Properties Report, Jira Issues, Content Report…

Hi @[deleted] , We can suggest trying our Table Filter and Charts for Confluence app and its Table Filter macro. The app works with manually created tables and is compatible with the ConfiForm tables. Wrap your table in the Table Filter macro body and choose the column where your want to search for the maximum value: Hope…

Hi @John Hyde , You may use our Table Filter and Charts for Confluence app and its Table Filter macro - wrap your Task Report macro into the Table Filter macro body and filter your tasks by the "Empty" assignee field: Hope this helps your case.

Oh, I see now, thanks for the clarification.

You won't be able to construct a beautiful table with the page meta data if you need to transpose tables as we performed for your case - you tables will be messed up. Create source tables horizontally A |B |C x1|y1|z1 Collect them with the Table Excerpt Include macro (check the "Show as a report table" option) and choose…

Hi @Murray Crease , As I understand, you add a manually created column with a page link to every mini-table that you collect. Try to use the automatic meta data option that is provided with the Table Excerpt Include macro: With this option you'll be able to collect plenty of additional information about your source pages…