Katerina Kovriga {Stiltsoft} Expert

Check if the Table Filter and Charts for Confluence app is installed on your instance - it is a separate plugin. If yes, then make sure that it is up-to-date (the Table Transformer macro is a rather old feature, but nevertheless it's always better to check). What concerns standard tools, you can try to copy/paste Excel…

Hi @Praneeth Kumar We can recommend you to try the Table Filter and Charts for Confluence app. To import your Excel files to Confluence, use the CSV macro. To merge the tables, use the Table Transformer macro. The default Merge preset will help you to combine tables with the same column names.

Try the Content by Label macro: here you can use OR (multiple values in the same filter) and AND (multiple Label filters) operators in the Label field.

Make sure that you use the Chart from Table macro and not the standard Chart macro. Feel free to raise a support ticket, we'll try to troubleshoot the issue.

Hi @Manik Singh, The Table Excerpt and Table Excerpt Include macros are not available for Cloud due to the limitations of its editor. But you should be able to reuse your table with the help of the standard Excerpt and Excerpt Include macros (just don't forget to wrap only the required table and not the whole page!). I've…

Hi @Ashley Rhodes , Use the standard Content by Label macro: you can set a filter in the macro body and choose (or set a custom) date range to show pages that were created (or modified - you choose the parameter) within this period.

The simplest workaround is described in the second part of the answer: "And if you need to hide several rows on your own page just for presentation, i.e. temporarily just to share your screen, go to your Table Filter macro where you hide columns and set the dropdown filter for your status column. Then go to the Filtration…

Hi @Kathryn Smith As I've understood, you need to count and show the number of different statuses of the IT area. For this purpose the standard Chart macro is not enough. We recommend you to try the Table Filter and Charts for Confluence app. Then you case becomes very simple. Here is your table: Let's wrap it in the Pivot…

Hi @Tom Williams , The Chart macro doesn't work with dynamic macros. When you are in the macro preview, your data uploads in a static way and you see the result. But on the published page it renders dynamically and the Chart macro can't "catch" the result. For example, if you create similar table manually, everything will…

Hi @Kent Thayer , To hide several rows from other users, you need to create two pages: * Public with no restrictions * Private with the required view restrictions Now divide your tables into two parts - with public rows and with private rows. Paste these tables to the corresponding pages. Then use the Table Excerpt/Table…

It seems that you are right and there are no any standard solutions to generate a built-in chart with a table outside its body. Besides the standard Chart macro works only with plain and simple tables. I see that you asked not to recommend any marketplace solutions but I have to explain one difficulty that you may have…

As far as we know, there is still no such feature out-of-the-box. If your Excel tables are not too big, you can just copy/paste them to the Confluence page.

@Laurice Strickland, if you've installed the Table Filter and Charts for Confluence app, you may read this documentation about freezing and try it on your own instance - it is really very simple. All you need to do is to specify the required number of rows and columns to freeze. If you still have any problems, you can…

Hi @Max Foerster - K15t , Thanks for the tip - got my profile name updated.

Hi @S H As I understand, the first step of your case is to collect data from mini-tables on different pages to one big master table. For this purpose use the standard Confluence macros - Page Properties and Page Properties Report. Note that your mini-table should contain only one row. The result big table will contain all…

Hi @Erik Ekengren, You can use the Table Filter and Charts for Confluence app, the Table Transformer macro in particular (it works with the Jira Issues macro perfectly well). The SQL query to change your headers is the simplest one - see the example below:

Hi @Andrews , I guess that the Table Filter and Charts for Confluence app may help you. The first case is solved with help of the Pivot Table macro. Just wrap your table into its body and choose the corresponding settings: The second case may be solved by using the Table Excerpt and Table Excerpt Include macros if we talk…

Hi @Julio Helden , You can't perform any data aggregation and calculations via standard Confluence tools. But you can try to use additional apps to enhance your Confluence instance - install the Table Filter and Charts for Confluence app. The app works perfectly well with the Jira Issues macro and all you need to do is to…

You can also use the Table Filter and Charts for Confluence app: it contains the CSV macro and you will be able to import tables easily from CSV or TSV data sources (URL or attached files).

Hi @[deleted] , As far as I can see, you can't nest standard Confluence macros in the new Cloud editor. https://jira.atlassian.com/browse/CONFCLOUD-68323

Hi @Francis Kinsler , There is a workaround to show velocity chart in Confluence: use the Table Filter and Charts for Confluence app and follow this instruction. Note that your Confluence and Jira instances should be connected (you can ask your Confluence administrator for the details) because you'll need to use the Jira…

Hi @Roy lobo , Try the Table Filter and Charts for Confluence app: * Use the Table from CSV macro to get your data from the attached file * Use the Chart from Table macro to build the required charts Besides these actions the app will help you to filter and aggregate your data (make pivots) to achieve even more goals.

Hi @Alain Beaulieu , Try the Table Filter and Charts for Confluence app. Here is an example of your wide table: And here is the standard Confluence behaviour: Let's wrap the table in the Filter from Table macro and freeze the first 2 columns (you can freeze rows as well): And here is the result: As you can see, we've…

You can also try the Table Filter and Charts for Confluence app (it's available for Cloud, Server and Data Center instances). At first you need to reuse your mini tables and "collect" them on the required page with the help of the Table Excerpt and Table Excerpt Include macros. The second step is to merge your tables and…

@Justin_Artis , we assume that you have smth like that: When you use the Pivot from Table macro with standard settings you count the number of variants (combinations): But if you go to the Options tab and set the Cell value delimiter, you will count letters: Now you can build your chart - it will look as the Chart 2 from…

Hi @Justin_Artis , Can you please give us an example of your table after ConfiForms macro? What columns and rows do you have? As usual, the Table Filter and Charts for Confluence app works well with ConfiForms, we'll try to reproduce your case and give you some tips.

Hi @Steve Gibbons , It seems to me that the Content Table Report macro is the most suitable one for your purpose. To change its headers to the more understandable ones you can use the Table Filter and Charts for Confluence app. Wrap your Content Table Report macro into the Table Transformer macro and insert simple SQL…

If you need "filtration on the fly" (different combinations of filters and columns) for regular users, you can just leave access to the filtration panel and you don't need to set any predefined filters. Here is an example of your page in the View mode: Your users will be also able to export the filtered table in CSV, PDF…

Try to publish your page and then create a new table - sometimes there can be kind of "bugs". To adjust the table width use the arrows near the table:

The Table Filter and Charts for Confluence app allows you to perform plenty of different tasks for various use cases. So, I suggest you to try out a demo lesson to learn about its main features by practice. And I was also a little bit confused that you have some issues with the Page Properties report macro: 100 companies…