Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hi guys, If it happens so that you use our Table Filter and Charts for Confluence app, you may use its Table Transformer macro to set width of the Page Properties Report macro. Please, check this part of our documentation (navigate to the “Changing column width” section).

Hi @Juan Carlos Toro, If your company uses our Table Filter and Charts for Confluence app, you may use its Table Transformer macro to set width of the Page Properties Report macro columns. Please, check this part of our documentation (navigate to the “Changing column width” section).

Hi @Chasovskikh Kirill, As @Juliette Lallement _Elements Apps_ has mentioned, the Excel-like cell data verification (a dropdown list made of the second table and used in the first table) may indeed be a good solution to your case. If it happens so that you use our Table Filter and Charts for Confluence app, you may do it…

Hi @Stephan Schmitz, I can suggest the following workaround using the Line chart: Неre you use full months’ names as X-axis values and set numeric values from 1 to 12 that correspond to the months’ numbers for Y-values. Also you may check our Gantt chart that is rather advanced and may be more suitable for the project…

Hi @Abbie Alcock, We can suggest trying our Table Filter and Charts for Confluence app (it’s free for Cloud 1-10 users). Seems that the Table Spreadsheet macro will suit your case: it supports import of csv/xlsx files and then you may continue working on your data in Confluence but using all the basic Excel functions (cell…

Please see the example on how you can reach the requested result in Confluence. It's created in its Server version, but you can do the same in Confluence Cloud using Jira Issue and the Table Toolbox macro of Table Filter and Charts for Confluence. The SQL query from the example: SELECT T1.'Key',T1.'Summary', T2.'Key' AS…

You can get Remaining Estimate, Time Spent columns to display in Jira Issue if Time Tracking is set in your Jira. Along with Jira Issue you can use our Table Toobox then to create pivot tables, charts or transform data somehow etc. 

Hi @Claudia Alioto, There are no any native Confluence macros to sort tables, you may only click the arrows in the table header to perform sorting in the page view mode on the fly. What concerns the apps from the Atlassian Marketplace that will enhance your experience with tables, our company develops the Table Filter and…

Hi @Mario Burrola Jr., Confluence itself was oriented more on Wiki, so, you may browse the Atlassian Marketplace for apps that will enhance your experience with tables. For example, our company develops the Table Filter and Charts for Confluence app that allows you to filter, aggregate and perform calculations in the…

Hi @Domantas Povilaitis, The structure of your query seems to be correct. So, you may check the source tables’ headers for typos and type in the query using the Table Transformer macro’s hints (type in, for example, “T1.” and choose the required column from the menu). I can also suggest another query for your case: SELECT…

@Munir Patel, please give me more details on how your Jira Issue looks like (namely Epic, Subtasks, Due date of subtask columns) so I could provide you with a solution in your specific case.

To build the pivot table based on Jira Issue, please wrap the source table with Table Toolbox in Confluence Cloud and configure Pivot Table as you need.

Hi @Bart Hoegaerts, Please note some differences between your query and the query from our documentation: SET @cnt = 0; SET @date = (SELECT T1.'Start' FROM T1); WHILE @cnt < 15 BEGIN SET @cnt = @cnt + 1; SET @date = FORMATDATE(DATEADD(YEAR,1,@date)); INSERT INTO T1 (T1.'End') VALUES (@date) END; SELECT * FROM T1 Here we…

The Table Filter and Charts for Confluence app is our add-on and it works with Confluence, not Jira. Our macros support the Jira Issues macro, so you’ll be able to aggregate, calculate and visualize Jira data right on Confluence pages. But again, we work only with the data provided by the Jira Issues macro.

Hi @tim.wheeler, If your company uses our Table Filter and Charts for Confluence app, you may use its Table Transformer macro to merge the table coming from the Jira Issues macro and the manually created Confluence table with additional comments and notes. Please check the second part of this Community thread for a…

Hi @Richard Broadhurst, If your company uses our Table Filter and Charts for Confluence app, please note that besides filtration, its Table Filter macro allows you to set pagination and freeze first N rows/columns. These features will make your experience with big native Confluence tables more user-friendly. And you may…

Hi @Kannan Uthandan, We can suggest trying our app that is Table Filter and Charts for Confluence and its advanced Chart from Table macro. You’ll be able to create various types of graphs based on native manually created Confluence tables and dynamic tabular macros (Page Properties Report, Jira Issues, Content Report…

Hi @Uweschaefer21, We can suggest using our Table Filter and Charts for Confluence app to filter, aggregate and visualize data coming from the Jira Issues macro. Here is an example of the Velocity chart. Please note that the screenshots were taken for Server/Data Center, so all the macros are wrapped directly on the page.…

Hi @Lina Sabestinaite, If we talk about standard Confluence macros, I can suggest trying the Jira Chart macro to aggregate and visualize your Jira issues. To aggregate/visualize the Jira Issues macro in a more customized way, you may try our app that is Table Filter and Charts for Confluence (it is free for Cloud 1-10…

Hi @Bryn Koning, We can suggest trying our Table Filter and Charts for Confluence app and its Table Spreadsheet macro. You’ll be able to import your data in xlsx or csv formats and use Excel-like functionality right in Confluence. And if you prefer to work with native manually created Confluence tables, you may reuse your…

Hi @Ariel Xu, We can also suggest trying our app – Table Filter and Charts for Confluence. You’ll be able to combine your project tables into one big report on the master page with the help of the Table Excerpt/Table Excerpt Include macros. Then with the help of the Table Filter macro you’ll be able to filter your combined…

Hi @abhilocalcircles, Please check the second answer to this question: the workaround is to create an extra two-cell table with a header and your variable, then you may use it in the query. For example, for our first case with one table and this SQL query (please refer to the second part of my answer on Jan 11, 2023):…

Hi @Praveen, You may read about Confluence tables in the Atlassian documentation. If you need more advanced options, you may browse the Marketplace and choose some apps to enhance your tables. For example, our company develops the Table Filter and Charts for Confluence add-on that is free for Cloud 1-10 users. You may try…

Hi @Misha Reece, We can also suggest trying our app that is Table Filter and Charts for Confluence. You can use its Table from CSV macro and connect Google Spreadsheets to your Confluence pages. Once the data in your spreadsheet is updated, the changes will be automatically transferred to Confluence. Furthermore, these…

Hi @Keith Lanier, Unfortunately, it is not possible as for now. But we do have such task on the roadmap – I’ve attached the link to this thread to the ticket. Once the feature is implemented, I’ll return here to notify you.

Hi @Emily Berg, Glad that you’ve found an answer yourself. Let me also suggest an option if not for this case, then for the future ones – how to avoid using filters (here I mean “BPFAAA”, “BPFBBB”, etc.) in the query. It may come in handy if there are many different variants and if they are changing dynamically (for…

Hi @Trish Hindmarsh, The Table Transformer macro works strictly with the data that it gets in Confluence through other macros, for example, the Jira Issues macro. It doesn’t “grab” anything directly from the Jira itself. So, please unwrap the Table Transformer macro from your source table and publish the page: check how…

Hi @candace xien, I can suggest using the standard Confluence macros – Page Properties/Page Properties Report. You’ll be able to create one-row tables with the same headers on your “slave” pages and collect these tables automatically on your “master” page. When you change data in your source mini-tables, the information in…

Yes, your case seems to be similar to the one I provided a link to.After splitting your links using the similar beginning or a character between them, you may use another Table Transformer macro with the FORMATWIKI function to recreate clickable links from each entry.You may share a screenshot of your source table here or…

Hi, you may use standard Confluence layouts to organize your excerpts (I mean, to place them one near another to keep your page not so long and easier to read). Please check this part of the documentation (navigate to the "Layouts" section).