Katerina Kovriga {Stiltsoft} Expert

Hi @Eugen Carticioiu , We can also suggest trying the Table Filter and Charts for Confluence app. It is our add-on that provides a more flexible and advanced Chart from Table macro. You'll be able to create various types of graphs and show numeric values or/and percentage onto your charts: If you are interested in the app,…

Hi @Sadeesh Narendran , Please try the following option: wrap your Pivot Table into the Table Filter macro. Here is your two-dimensional pivot: Now you go the the Table Filter macro settings -> Filters tab and check the Hide columns option: And navigate to the Filtration tab -> Set filters' default values and choose the…

Hi @Sadeesh Narendran , We can suggest hiding the whole pivot panel into the view mode: go to the Pivot Table macro settings -> Options tab -> Hide control panel. If you want to organize your result pivot table into a better way, you may rename its Operational type column - wrap your Pivot Table macro into the Table…

Hi @Gavin , I can suggest trying our app - Table Filter and Charts for Confluence. You may wrap your Jira Issues macro into the Table Filter macro and filter your issues by labels, summaries and other fields (by one or several fields simultaneously). If you decide to go further and create Jira dashboards right in…

The Table Excerpt Include macro collect only the contents that is wrapped into the Table Excerpt macro. The search for the Excerpts may be led by labels (similar to the Page Properties Report), on the current page, on the specific page and its children, on the specific page and its descendants. The link for the macro…

Hi @BC Peng , all the plugins should be installed by your Confluence administrator, you won't have access to these settings as a regular user. What concerns pricing, the up-to-date information is in the Pricing tab onto the app's listing. But you may regard further switching from Server to Data Center or Cloud (I suppose…

Hi @BC Peng , We can suggest using our app - Table Filter and Charts for Confluence and its Table Excerpt/Table Excerpt Include macros. Here is your 3rd level page: The "CCC - Excerpt" information will be reused further. Here is your 2nd level page with a table where "CCC - Excerpt" is reused: Here is your 1st level page…

Hi @Andy Keaveney , Try to modify your SQL query in a following way: SELECT FORMATWIKI(SUM(" [" + T1.'Key' + "|http://jira.stiltsoft.by:address/browse/ " + T1.'Key' + "]\n")) AS 'Key' FROM T1 Here T1.'Key' is a column name where you want to create clickable links (T1.'TER Key' for your example).…

Hi @Brendan Schierloh , As for me, I can see only 3 types of Jira Charts into my Jira Issues macro: * Pie chart * Created vs Resolved chart * Two Dimensional Chart The macro fully looks like it's documented here. What concerns Gantt chart based on the Jira Issues macro, we can suggest trying our app - Table Filter and…

Now I see that you want a different case - your master tables should "mirror" each other and every update made from any of the tables should be reflected in every other table. As for now, I can't come up with a suitable solution. Maybe you should try to browse the Marketplace - I've came across different solutions similar…

Hi @[deleted] , You may also try our app - Table Filter and Charts for Confluence. Its Table Filter macro allows you to filter your Confluence tables similar to Excel Spreadsheets. You may look here for an example.

It's a paid addon which main features are filtering, creating pivots and charts, performing calculations in tables, etc. (I mean amplifying Confluence with Excel-like features) And it also provides a lot of tiny but handy formatting features, for example, pagination, rows/columns freezing, width setting, etc. All apps are…

The app is an additional plugin which is installed by your administrator. The app provides one or several macros that allow you to amplify Confluence. As @Karen_Mustain has mentioned, try this free app.

It's a paid add-on but you may also browse Atlassian Marketplace for more simple and free apps that provide only CSV export.

Hi @CHARITHA , We can suggest using our app - Table Filter and Charts for Confluence. With the help of its macros you'll be able to export your data in CSV, pdf and Word formats.

Hi @B-S , you may use our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros that can easily collect several multi-row tables into one big report with further filtering, pagination and other handy options. Please look here for an example of a similar use case.

Hi @ardian.krivca , We can suggest using the following workaround with our app - Table Filter and Charts for Confluence. Maybe you already use the addon in your company but don't know about the additional table formatting features of the Table Transformer macro - you may as well set the column width with it.

Hi @Selvakumar , If you use the Table Filter and Charts for Confluence app in your company (it's our addon), you may set the column width with the help of the Table Transformer macro. And another handy feature to adjust your big tables is to use pagination (this option is included into the Table Filter macro).

Hi @Amna Imtiaz , We can suggest trying our app - Table Filter and Charts for Confluence. It allows you to create dashboards based on the standard Jira Issues macro (filter, create pivots, perform calculations and visualize your data) - please, look here and here for examples. Maybe you'll be interested in a live demo from…

Hi @Martin Röhricht , thanks for the review! Our team was very excited to get it!

Hi @Olga Mihaevich , It seems that the macro allows to display only the following columns (it is written into the macro body): description, duedate, assignee, location, completedate, and labels.

And thank you for reaching out!

You may create several mini-tables with variables and wrap every one into the Table Excerpt with a corresponding name. Then you'll be able to include it into the Table Transformer macro via the Table Excerpt Include macro.

Hi @Emily Berg , The Table Transformer macro can use a page variable in its SQL query: SELECT T1.* FROM T1 WHERE T1.'Name' = (SELECT T2.'Variable' FROM T2) The big source table can be reused and inserted via the Table Excerpt Include macro. But you'll still need to wrap your reused table into the Table Transformer and…

Hi @tmeyer and @Marcel Pfeiffer , please check if you use the Table Filter and Charts for Confluence app for your instance (maybe it's installed but you don't use it - try to find the Table Filter or Chart from Table macros in the macrobrowser). It's our add-on and the mentioned Chart from Table macro provides an advanced…

Hi @Emily Berg , If I got your case right, you reuse the source table and wrap every Table Excerpt Include macro into the Table Filter macro to filter by different columns and values (so you'll get a kind of a dashboard). Unfortunately, we don't have any automatic rules to assign filters/values to the Table Filter macro…

I'm glad that you've solved the case and everything is working fine, thank you for reaching out! Maybe you'll have several minutes to leave us a review about the Table Transformer macro and your cases - our developers will be thrilled to get one. Besides it is always useful for other customers.

Hi @Martin Röhricht Here I am with an update for your case. Please check the version of your app - the current one is 7.6.1 and your own SQL query works just fine with it. We've tested it in our own instance and got the following result: And you may also try the third variant: SELECT T3.'Key' AS 'MCR-Key', T1.'Status' AS…

Hi @Martin Röhricht , I can give you a not elegant but still working decision for you not to get stuck with the case (if our developers provide me with a better solution, I'll get in touch immediately). Use the following combination of the Table Transformer macros and Jira tables: The TT 1 and TT 2 are used to distinct…

Hi @Ramona Mader , I assume that you use our app - Table Filter and Charts for Confluence. To reuse your original tables and combine them into one big report, use the Table Excerpt/Table Excerpt Include macros. By the way, as an active user of our app, maybe you'll be interested in an interview with our team? We'll be…