Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

I usually get the following message: 

Hi @Anish Shah, For this case you need to count the number of unique tasks, so take the Table Transformer macro instead of the Pivot Table macro: SELECT 'Status', COUNT(DISTINCT 'Task') AS 'Number of Unique Tasks' FROM T* GROUP BY 'Status'

Hi, @Kelsey Van Scoy could you please help me to add custom tags like the following so users can find the relevant info easier in the Atlassian Community: table-filter table-filter-and-charts table-spreadsheet table-transformer pivot-table Thanks a lot!

Hi @Maximilian Neufeld, We develop the Table Filter and Charts for Confluence app, and its Chart from Table macro also provides an advanced Gantt Chart. As you’ve mentioned before, the Gantt Chart operates with start and end dates of your projects or their phases. So, if the ServiceDevelopment phase is the first step and…

Hi @Andrey Derenchenko, It is not possible to implement your case natively, so you’ll need to browse the Atlassian Marketplace for some 3rd party apps. For example, our company develops the Table Filter and Charts for Confluence app that will be handy for the case. You’ll be able to count empty and not empty cells using…

Hi @Kasra Ayz, We can suggest trying our app that is Table Filter and Charts for Confluence. Please take a look at the blog post where we describe how to restrict table columns for viewing and editing. You may also book a demo session from our team – we’ll be happy to show everything live.

Hi @Tieria Chen, We can suggest trying the app that we develop – Table Filter and Charts for Confluence. Its Table Spreadsheet macro will do the trick with a multi-level dropdown, please check the screenshots below: To use the file as a template, you may export it in the .tfss format. Later on, you (or your colleagues)…

Thank you to all who supported the Table Filter and Charts for Confluence demo. Your votes mean the world to us 🤗

Hi @Ana Maria Feito Horcajo, You’ll need 3rd party apps to set a default sorting, apply filters and perform calculations in Confluence tables. Our company develops the Table Filter and Charts for Confluence app that fully suits your case: it supports manually created Confluence tables, macro generated tables (for example,…

Hi @renaud staessens, Please use the auto complete hints given by the Table Transformer macro while typing the SQL query. The first thing that I saw were the 'T1.TestStatut' parts. It is not correct in general: T1.’TestStatus’ is a correct variant (the quotes shouldn’t include the T1. part and the column name should be…

Hi @Jaya Sharma, As you’ve mentioned the Table Excerpt Include macro, I assume that you have our app – Table Filter and Charts for Confluence. What concerns the first requirement, we don’t work with the Sharepoint due to the access restrictions. But you may try the following workarounds: Use Google Sheets instead and…

Hi @Mathurashish Kumar, Sant, Please use the Pivot Table macro for the case. As I understand, you have a table (manually created or coming from the Jira Issues macro – it makes no difference) that is similar to my screenshot: Now go to the Pivot Table macro settings and configure the required output using user-friendly…

Hi @Yusuke Maki, As I see the Table Filter macro on your screenshot, I assume that you have our Table Filter and Charts for Confluence app installed for your instance. If you needed to display dates in a consecutive way, the Table Transformer macro might help you. Please check this Community thread for an example. But as…

Hi @Pete Randall, Please check what version of the Table Filter and Charts for Confluence app you use. The current one is 10.0.0 for Server/Data Center, so if yours is an older one, please ask your Confluence administrator to update it. If you are on Cloud and use the old editor (it’s more likely you have Server/Data…

Hi @Vanessa I am Katerina, a Table Filter and Charts app support engineer. Please refer to our support team in this case. Attach the Page Storage Format (upper right corner of the page -> menu … -> View storage format) so we can investigate the issue.

Hi @Melissa Averkamp, We can also suggest trying the app that we develop – Table Filter and Charts for Confluence. If you need to collect not one-row but multiple-row tables from pages with specific labels, you can use our advanced Table Excerpt/Table Excerpt Include macros instead of the standard Page Properties/Page…

Hi @Craig_Harley, You can use the app that we develop – Table Filter and Charts for Confluence. Its Table Filter macro (as well as other macros) is compatible with the Page Properties Report macro, so you’ll be able to use a free text filter that fully suits your case. If you are not familiar with the app, we’ll be happy…

Hi @Katrina Atkinson, Please check the example below: SELECT FORMATWIKI("{cell:width=700px; border-top:1px}", 'Issues', "{cell}") AS 'New Name for Issues', FORMATWIKI("{cell:width=300px; border-top:1px}", 'Summary', "{cell}") AS 'New Name for Summary', FORMATWIKI("{cell:width=200px; border-top:1px}", 'Customer', "{cell}")…

Hi @[deleted], I’ve tried to recreate your case, and everything works fine for me, here is my published page: And here is my macro structure: Here goes the internal Table Transformer macro: SELECT ROWNUM() AS 'Top', * FROM T* And here goes the external Table Transformer macro: SELECT T1.'Top', T1.'Project', T1.'Column 1',…

Hi @Luana da Silva Machado, In this thread we are talking about our Table Filter and Charts for Confluence app. Its macros support the Jira Issues macro as well. So, for the case, you may wrap the Jira Issues macro in the Table Filter macro and set the required filters (free text, date range, dropdown).If you are not…

Hi @Luana da Silva Machado, You may try the app that we develop – Table Filter and Charts for Confluence. Insert the standard Jira Issues macro with the most general JQL (something like project=project_name) and wrap this macro in the Table Filter macro. The latter supports dynamic tabular macros and allows you to use wide…

Hi @Zowi, You may just list your columns in that particular order that you want them to be present in the table: SELECT 'Column_name 1', 'Column_name 2', FORMATWIKI("{cell:width=100px}", 'Some column name', "{cell}") AS 'Column_name 3', 'Column_name 4', 'Column_name 5' FROM T1 Note that you don’t need to list the 'Some…

Hi zona418@163.com, We can also suggest trying the app that we develop – Table Filter and Charts for Confluence. Its Table Excerpt/Table Excerpt Include macros will do the trick. These macros are not only perfect substitutes for the standard Page Properties/Page Properties Report macros if you work with multiple-row…

Hi @Grant Rolls, We can suggest trying the app that we develop – Table Filter and Charts for Confluence. You’ll be able to use several dynamic Jira Issues macros as source tables and combine (merge) them using our macros. For example, here we have a use case related to combining issues with linked issues coming from…

Please try to use only one Table Filter to filter table by ID like 107 and 88. I suppose the issue comes from the macro structure, so please raise a support ticket here and attach the page storage format to help you quickly.

Hi @Prashant Vishnoi, We can suggest trying the app that we develop – Table Filter and Charts for Confluence. You’ll be able to recreate a table in Confluence from your JSON (attachment or url) using our Table from JSON macro. Then you’ll be able to visualize your data with the help of the Chart from Table macro. Besides,…

Hi @Jeremy Yehle, We can suggest trying the app that we develop – Table Filter and Charts for Confluence. Our macros support the Jira Issues macro, so you’ll be able to group and count your issues by dates (aggregate your data by months, for example, like you do it in Excel). The Pivot Table macro may help you with the…

Hi @May Finkelstein Yotvat, We can suggest trying the app that we develop – Table Filter and Charts for Confluence. Our macros support both manually created and macro generated (for example, the Jira Issues macro) tables. So, you can easily create the required chart. Please check here for an example. If you are not…

Hello @Alice Liu, Please try the following macro structure and configuration (add Table Excerpt and Table Excerp Include macros on the page): 

Hi @Ram Chandrasekaran, Please notice that if you update the app, you can use the Messages customization option right in Table Transformer to hide the message: