Katerina Kovriga {Stiltsoft} Expert

Let me two minutes to recreate your table and advise.

Thanks, I see now - the error is in the date format. Go to the macro settings -> Adjustments tab and set the correct format. From your error I see that you have dd M yy that corresponds, for example, 21 Feb 2022. As you use Feb-2022, then your format is M-yy.

Still can't see the attachment - save your screenshots and upload them to the thread. Copy/pasting doesn't work here.

Hi @Brett Bullman , Can't see your source table and an Excel chart. What macro do you use? Is it the standard Chart macro or the Chart from Table macro provided by our Table Filter and Charts for Confluence app?

Hi @Ariadna Mateo , Does this happen on one specific page? Have you tried creating tables on a new Confluence page? Can you edit other content besides tables? Are we talking about a plain manually created table?

Hi @Dastagiri , You can browse the Atlassian Marketplace and search for apps that recreate tables from CSV attachments (it seems to me that there may be free add-ons). Our own Table Filter and Charts for Confluence app is a paid one because its main functions are filtration, aggregation, calculations in tables, etc. But it…

Есть доступ на просмотр спейса или на редактирование тоже? Другие страницы в этом же спейсе редактировать можете? Проверьте, нет ли ограничений на просмотр страницы выше по дереву страниц - могли стоять ограничения на родительских страницах. Тогда эту страницу вы видеть не будете. Ограничения на просмотр наследуются. Если…

@Феодора , Перепроверьте права этого пользователя на спейс, в котором находится данная страница.

If we are talking about the Table Filter and Charts for Confluence app, you can book a live demo session here. Note in the description that you are interested in our Table Excerpts macros and filtering of the combined report.

Hi @Ashmeer Mahabeer , The Table Excerpt/Table Excerpt Include macros come with the Table Filter and Charts for Confluence app. If you can't find our macros, it means that the add-on is not installed for your Confluence instance. Try to look into the standard Excerpt/Excerpt Include macros then.

Hi @William Comstock Walker III , We can also suggest using our Table Filter and Charts for Confluence app and its Table Transformer macro to sort dates correctly. For example, you may check this Community thread. But again every table should be wrapped into the Table Transformer macro body.

Hi @Sandra Lawrence , If your company uses our Table Filter and Charts for Confluence app, you may use its Table Transformer macro to set specific column width. Please check this part of our documentation.

Hi @Drew T , If you use our Table Filter and Charts for Confluence app in your company, its Table Filter macro should be compatible with the ConfiForms TableView macro and you may try its rows/columns freezing option.

I understand that the problem is to make a rather big table more neat - among the standard macros nothing comes to my mind besides the variant with a bunch of mini tables hidden under the Expand macros. The closest things that we have to the case I've also mentioned. If you have a better solution, please let us know. I've…

I mean that the macro catches all the information from the Jira Issues macro - if something is updated in Jira, the changes will be immediately reflected on the dashboard.

Hi @蒋文华 , From our side we can suggest trying our Table Filter and Charts for Confluence app (it supports ConfiForms as well). The Table Filter macro allows you to hide/show unwanted columns and use pagination to make your big tables smaller and easy-to-read. Maybe this could help your case.

Hi @Thomas M , We can also suggest trying our app - Table Filter and Charts for Confluence. Its Chart from Table macro supports the Jira Issues macro and you'll be able to create live Jira dashboards right in Confluence.

Hi @Eric Lee , The standard Page Properties/Page Properties Report macros collect one-row tables. To collect multiple-row tables, use our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. The summary report (combined with the help of standard Confluence macros or our advanced…

Hi @Kelsey Lubbe , I've recreated your case and the sorting works for me just fine: SELECT T1.'date' FROM T* ORDER BY 'date' DESC Here I already sort my column: And here I use the Table Filter macro on top to sort it backwards: The date format that you use is correct. From the first screenshot I see that your macros have…

Hi @Martin , If you use our Table Filter and Charts for Confluence app, you may hide the unwanted columns of the Page Properties Report macro via the Table Filter macro' settings. I assume that you have all the columns if you leave the "Columns to show" field blank but can't retrieve the specific heading.

Hi @CYH , Please check this thread for an answer. And you may also use an additional table and the following SQL query in the Table Transformer macro: SELECT * FROM T2 WHERE(SELECT * FROM T1) IS NULL UNION CORRESPONDING SELECT * FROM T1

Hi @ju , We can also suggest our Table Filter and Charts for Confluence app that supports the Jira Issues macro and allows you to create Jira dashboards right in Confluence. Maybe you'll be interested in a live demo from our team - we'll be happy to organize it and show some use cases. Please book a suitable time slot here.

Hi @Tonja Davis , Our Table Filter and Charts for Confluence app supports the Jira Issues macro and allows you to group issues by statuses (use the Pivot Table macro) and visualize the result (the Chart from Table macro). To count percent as a number, you may use the Table Transformer macro. Here are several examples of…

Hi @Aparna , Maybe our Table Filter and Charts for Confluence app will help your case? It provides the Table from CSV macro that allows you to output a table from CSV or TSV data source (URL or an attached file). The recreated table can be further filtered, aggregated and visualized as well.

Hi @Alexis Marticorena , I've tried to paste an Excerpt Include macro to a newly created custom template on our test Cloud instance, made a page using this template and everything works just fine for me. Maybe you use our Table Filter and Charts for Confluence app? Try to do the same with its Table Excerpt Include macro…

Hi @[deleted] , If we talk about standard Confluence tools to collect tables with statuses and descriptions, you may try Page Properties/Page Properties Report macros. The only disadvantage is that they collect one-row tables. To collect multiple-row tables, you may try our Table Filter and Charts for Confluence app and…

Hi @Emily Berg , Please try this SQL query for your Table Transformer macro: SELECT * FROM T1 WHERE T1.'Fix Version/s' LIKE (SELECT T2.'Variable' FROM T2 WHERE T2.'Index' = 1) + "%" And don't forget to cut your variable in the table and leave it, for example, as "721018502".

Hi @Sagar Nivgune , Maybe the Table Excerpt/Table Excerpt Include macros will help? You'll be able to collect your tables from different pages on the master page with the help of the Table Excerpt Include macro, wrap this macro into the Table Filter macro and export all the tables at once.

Hi @Ben Posnasky , The thread given by @Pramodh M concerns our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. These macros allow you to search for excerpts within multiple spaces as well.

Hi @Suneendra Kumar Reddy , As the result of your script is a CSV file, I can suggest browsing the Marketplace and find some apps that can recreate Confluence tables from CSV files and attachments (there may be even free apps). What concerns our own app that is Table Filter and Charts for Confluence it's a rather advanced…