Katerina Kovriga {Stiltsoft} Expert

Test

Hi @Charles Middlebrooks , You may use the following SQL structure for the case: SELECT 'Project', 'Column 1' + 'Column 2' AS 'New Column' FROM (SELECT *, CASE WHEN 'Column 2' IS NULL THEN 0 ELSE 'Column 2' END AS 'Column 2' FROM T1) In the internal SELECT we put 0 in the empty cells of our table and in the external SELECT…

Hi @Lisa.Kohlstrung , Your idea seems to be right, Confluence Cloud doesn't support macro nesting and you need to wrap your Page Properties Report macro in the Table Toolbox macro - the latter is a shell for macro wrapping. Inside its settings you will be able to create different sequences of other macros. If you are stuck…

It seems that you are using an old legacy editor. Please give us a screenshot of your source table in the page edit mode with the headers visible. We'll try to advise.

Hi @CatherineP , If you can't find the Chart from Table macro in your macrobrowser, it means that the Table Filter and Charts for Confluence app is not installed for your instance. This app is developed by our company and it is a paid one unless your Cloud instance is small (1-10 users).

Hi @Ignacio Cabau , Please clarify the case a little bit for us to help. What apps do you use to calculate dates? What serves as a source table for these calculations? I may assume that you are using the Table Transformer macro provided by the Table Filter and Charts for Confluence app (that is our add-on) for calculations…

Yes, you should turn to your Confluence administrator to update the permission scheme for your group or personal account.

Hi @Rodrigue Perret , By sub-pages do you mean the parent page and its child pages? Maybe this part of documentation will help https://support.atlassian.com/confluence-cloud/docs/export-content-to-word-pdf-html-and-xml/ 

Hi @Laryssa Da Luz Stelin , It is possible if you use additional plugins. Our company develops the Table Filter and Charts for Confluence app, so I can confirm that you'll be able to create a Gantt chart right on your Confluence page using the standard Jira Issues macro. You may check here for the details. 

Hi @FA @Andrew Crile , The fix was released - it may take 1-2 days to the new version of the app to get to all the Cloud instances, but now our macros are expected to be exported into pdf when you export the whole page as well.

Hi @Steven Sgarlata , With the help of the Table Filter and Charts for Confluence app (this add-on is developed by our company) that was kindly mentioned by @Peter DeWitt you'll be able to export your Confluence tables in CSV, Word and pdf formats. Please check here for more details. Hope it helps your case.

Hi @Rob Horan , I mean hit the plus icon in the page edit mode and choose the "Other macros" option to browse through all the available macros. Maybe smth new will catch your eye. We really had such cases with our customers when they even knew that the new app was installed but used only one macro from its family cause it…

Hi @Jason Waller , Please use the following SQL query for the case: SELECT *, REPLACE ('Summary', "Define", "Add") AS 'Summary' FROM T*

Hi @Hilton Santos , Nice to meet you here! It seems to me that you are using Bitbucket if we are talking about repositories? Unfortunately, I won't be of any help here. But I can suggest using tags for the question (upper right part of the page) and post your questions in the correspondent groups for other people to find…

Hi @Lisa I , Nice to have you here! Don't be afraid to ask questions and post screenshots - we are ready to help, besides every thread may help other people as well. :) 

Hi @Claudia J. Lara , To create a chart from Page Properties Report, we can suggest the Table Filter and Charts for Confluence app and its Chart from Table macro. This add-on is developed by our team. Our macros support dynamic tabular Confluence macros such as Page Properties Report, Jira Issues, Content Report Table, etc.

Hi @adriana vornicu , I can also suggest trying the app developed by our company - Table Filter and Charts for Confluence. Besides filtration, aggregation, calculations and advanced visualization, you'll be able to import/export your tabular data in the CSV format. Maybe you'll be interested in a live demo - please book a…

Hi @中川裕博 , As far as I know, in the Chart macro you'll be able to change the order of the stack bars themselves by changing the Columns order: But I'm not sure if it's possible to change the order of stacked values unless you change it in the source table. If your company uses our Table Filter and Charts for Confluence app…

Hi @Nathan Wilcox , We develop the Table Filter and Charts for Confluence app that contains the Table Excerpt/Table Excerpt Include macros. Here the "table" is just a part of the brand, our excerpts collect both tables and plain page abstracts. But (and this is why my post is related to your case) you will be able to show…

Then I can suggest raising a support request. If you have Server/Data Center, please specify the version of the app (the current one is 9.4.0, if yours is an older one, please update not to lose new features and fixes). For Cloud it is not relevant, your add-on will be always up-to-date. Then attach two page storages: for…

Hi @Stefan Pichler , Our company develops the Table Filter and Charts for Confluence app and if it happens so that you have it installed for your instance, please note that there is a workaround to change (set) column width using the Table Transformer macro. If the anchor of the link is broken (sometimes it happens),…

Hi @Team Awesome BVBA , The ability to perform calculations in Confluence tables directly is not possible at the moment, so you'll need some 3rd party add-ons to fulfil the task. As my company develops the Table Filter and Charts for Confluence app, I can suggest trying its Table Transformer macro (if you prefer to work…

Hi @Michelfrancis Bustillos , I've tried to do smth similar and the macro seems to be working fine for me: To change your X axis from Dep to PC/Notebook, change the "Content Orientation" from horizontal to vertical. Our company also develops the Table Filter and Charts for Confluence app, so if it happens so that you have…

Hi @Elena Kondrashova , Please check how you collect the Excerpt from the page C - I guess by its title? Make sure that your Table Excerpt Include macro points to the right page. And also check the name of the Excerpt on the C page for typos, extra spaces, etc. The names in the Table Excerpt Include and Table Excerpt…

Hi @Elma Lam , If you can't find the Pivot Table, Table Filter, Table Spreadsheet macros in your macrobrowser, it means that the Table Filter and Charts for Confluence app is not installed for your instance. It is a paid add-on that should be installed from the Atlassian Marketplace by your Confluence administrator.

Hi @Shikha Saka , Unfortunately, there is nothing new from our side: as Nikita has mentioned before, you may split labels by spaces and place every separate label in a separate row (it can be later useful for filtering by every particular label and not the whole string) or set the corresponding value delimiter to…

Hi @Marvin Kloth , Please use commas instead of pluses - check this example (navigate to the "Preserving initial cell formatting" section if the anchor of my link doesn't work - sometimes it happens).

Hi @Gian Franco Morassutti , I can suggest trying the Chart from Table macro provided by the app that our company develops - Table Filter and Charts for Confluence. It's Gantt chart allows you to show both stars and lines, besides you will be able to create a chart based not only on manually created table but on the…

Hi @Tim Schrader , We can suggest trying the Chart from Table macro provided by the app that we develop - Table Filter and Charts for Confluence. It's Gantt chart allows you to show both stars and lines, besides you will be able to create a chart based not only on manually created table but on the dynamic Jira Issues macro…

Hi Lorena, I suggest applying to our support team - please use this link to create a ticket. At first, as you are on Server/Data Center judging by the tags of the initial question, ask your Confluence administrator what version of the Table Filter and Charts for Confluence app is installed for your instance. The current…