Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hi @Jeffrey King, If your company uses our Table Filter and Charts for Confluence app, you may build combined reports with the help of the Table Excerpt/Table Excerpt Include macros. The result table may be filtered with the help of the Table Filter macro, so you will be able to show only specific rows. And you may also…

Hi @codadevbu, Not sure what your current SQL query looks like but here are some hints for you: as your Task Reports have the same headers, you may merge them using the standard “Merge” preset via the Table Transformer macro. The SQL query that stands behind this preset is “SELECT * FROM T*”, so we don’t call any specific…

Hi @joerg taub, We can suggest trying the app that we develop – Table Filter and Charts for Confluence. You may use your existing Excel file, import it to the Table Spreadsheet macro and continue to work with it right in Confluence (with all the Excel-like features: cell formulas, pivot tables, filtering, sorting,…

Yes, the "Powered by Atlassian Confluence 7.19.6" suggests that you are on Server/Data Center. But it's the version of your Confluence and not the Table Filter and Charts for Confluence app. Your Confluence administrator should be able to check the version of the add-on for you and update if required. Meanwhile, try to…

Hi @Scott Gillespie, Seems that the Table Excerpt Include macros don’t return the tables properly (red errors). And the Table Transformer #1, Pivot Table and Table Transformer #2 just “complain” that there are no tables for them to work with (blue information blocks). I can suggest that it may be so if smth was changed in…

Hi @Stephan Bauer, Unfortunately, you can't use js functions that have arguments as functions either. This comes from the security side of the app.

Hi @Bindiya Chacko, If you mean that you want to transform the IDs coming from your Jira Issues macro into usernames automatically, then it can’t be done via the Table Transformer macro. The macro works with the data coming from the Jira Issues macro. So, if your Jira Issues macro returns IDs (and not “pretty” usernames),…

Hi @Stephan Bauer, Please modify your SQL query as following: SELECT *, MATCH_REGEXP(T1.'Sprint',"[0-9][0-9].[1-5].([1-6]|IP)", "g")->sort()->pop() As 'Latest Sprint' FROM T1 This query should be working fine. You may also read more about the MATCH_REGEXP function here (the second table, row #145).

Hi @Stephan Bauer, I see that you have a similar question here, so please let’s move to that thread.

Hi @Alison Milne, You may try our Table Filter and Charts for Confluence app and its Table Spreadsheet macro. You’ll be able to import your Excel file into Confluence and then continue working with it right there using all the basic Excel functions.

Hi @Sarah Killeen, The issue is not only in the date format but you have the values columns messed up as well. Please go to the page edit mode and enter the Chart from Table macrobrowser: Check the Adjustments tab and make sure that you have the appropriate date format “dd-mm-y” and that your table data orientation is set…

Hi @Scott Gillespie, We can suggest wrapping your original tables into the Table Excerpt macros before the Table Filter macro. Then you will collect them without “Totals” and your master report combined via the Table Excerpt Include macro (here you need to check the “Show as a report table” option) will look as following:…

Hi @Bindiya Chacko, Are we talking about the Table Filter and Charts for Confluence app and its Table Transformer macro? If this is the case, then here are the screenshots from our test Confluence instance: SELECT T1.'Key', T1.'Created', DATEDIFF(WEEKDAY,T1.'Created',GETDATE()) AS 'Aging' FROM T* So, everything works fine.…

Hi @Ananth Subramanian, We can suggest trying the Table Filter and Charts for Confluence app (it is the add-on that we develop). The app is free for Confluence Cloud 1-10 users, otherwise it’s a paid one but you’ll get 1 month of free trial. You’ll be able to create advanced Gantt charts based both on manually created…

Hi @Elena Kondrashova, Based on the part of your screenshot, I assumed that we are talking about the Table Filter and Charts for Confluence app and its macros. If it is so, please somehow mention the name of the app and macro names for us not to miss your questions. Besides, you may refer to our support – the portal is…

Hi @Kevin Lin, You may look into the following standard Confluence macros to show info from Jira on Confluence pages: Jira Chart – Two Dimensional Chart (creates an aggregated tabular view of your Jira issues, not very flexible). Jira Issues (creates a non-aggregated tabular view of your Jira Issues: each row relates to a…

Hi Will O, Your query seems to be correct: SELECT 'Key', FORMATWIKI("{cell:width=100px}" + 'Description'+ "{cell}") AS 'Description' FROM T* You may also find an example in the documentation (please navigate to the “Changing column width” section). If the function is not recognized by your Table Transformer macro (you get…

Hi @Karen Phillips, If you have the Table Filter and Charts for Confluence app installed (this add-on is developed by our company), you may use the following workaround: wrap the Decision Report macro in the Table Filter macro and use the latter to export your decisions in csv format. Hope it helps.

Hi @Antara Kumar, It is not possible to achieve the case in Confluence natively. So, you need to look into some apps from the Atlassian Marketplace. As we develop the Table Filter and Charts for Confluence app, we can suggest using its Table Transformer macro if you prefer to work with original Confluence tables (this…

Hi @Karen Phillips, If your company uses the Table Filter and Charts for Confluence app (that is our add-on), you may use the following workaround: wrap the Decision Report macro in the Table Filter macro and use the latter to export your decisions in csv format. Hope it helps.

Hi @Ganesh Muthusamy, By “without using spreadsheet macro” do you mean that you want to do it natively without any additional apps? I’m afraid there is no any workaround besides manual copy/pasting your values into the corresponding cells. But if you are open to 3rd party add-ons, we can suggest trying our Table Filter and…

Hi @Cecilia Briozzo, Indeed, the Page Properties/Page Properties Report macros collect only the first data row of your tables – it’s a limitation for these macros. If your company uses our Table Filter and Charts for Confluence app, you may use its Table Excerpt/Table Excerpt Include macros to combine big reports from…

Hi @Konrad Gora, Please check if your company uses our Table Filter and Charts for Confluence app – the case can be accomplished via its Table Transformer macro. Tell us if you see the Table Transformer macro among the available macros – we’ll be able to help you with the SQL query.

Hi @kash259, You can watch the following videos: How to Use Spreadsheets in Confluence, How to use spreadsheets in Confluence and read this documentation page to learn more on how to use the Table Spreadsheet macro. Also, please feel free to book a live demo and ask any questions via our support portal.

Hi @Rob Hearne, Table Filter and Charts for Confluence is an app for Confluence from the Atlassian Marketplace. It exists both in Server and Data Center Confluence versions. You can try using it for a month for free and book a suitable time slot here to get a live demo and ask any questions. 

Hi @[deleted], Our app that is Table Filter and Charts for Confluence will definitely meet your needs (available for Cloud/Server/DC). You may check our Table Filter and Table Spreadsheet macros for filtering options. We’ll be also happy to organize a live demo for you – please book an available time slot here.

Hi @Noori Fathima, Seems that your case may be a little bit harder than it looks. As I understand, you need to match not only projects but locations as well. For example, you may have such custom table: Project Name | Squad Name | Product Owner | Market Owner A | Browse [US] | John | Dan B | Browse [US] | John | Dan A |…

Hi @Rob Hearne, Seems like our Table Filter and Charts for Confluence app will fulfill your needs. The Table Excerpt/Table Excerpt Include macros will help you to collect tables and combine your big master report. The Pivot Table, Table Filter and Chart from Table macros will enhance your master table with Excel-like…

Hi @Ivan Andrieiev, If your question concerns the Excel-like functionality in Confluence, you may try our Table Filter and Charts for Confluence app and its Table Spreadsheet macro. You’ll be able to import your existing file in xlsx and csv formats and continue to work with it right in Confluence (use cell formulas,…

Hi @kash259, If your company uses our Table Filter and Charts for Confluence app, we can suggest trying its Table Spreadsheet macro. You’ll be able to import your existing Excel file in xlsx and csv formats and continue to work with it right in Confluence (use cell formulas, conditional formatting, pivot tables, etc.).