Katerina Kovriga {Stiltsoft} Expert

Hi @vpriya , Check if the Table Filter and Charts for Confluence app is installed for your instance. Wrap your Jira Chart in the Table Filter macro and choose to sum up your rows:

And here you'll find more examples of calculations and visualisations using the Jira Issues macro https://docs.stiltsoft.com/display/public/TFAC/Using+Table+Filter+and+Charts+in+Combination+with+the+Jira+Issues+Macro You may just follow these examples step by step, the only difference will be in nesting of the macros…

I've just noticed that the number of the fixed issues for the Resolved for the past 7 days issues is fewer than for the created - don't pay attention on this. It's our test demo project, so I've used other JQLs for my Jira macros (not the 7 days ago, but weeks for the created issues) to get more or less corresponding…

Hi @Lisa Tritt , You need to use additional apps to use math formulas in Confluence. For example, the Table Filter and Charts for Confluence app. The first step is to insert the Table Toolbox macro on the page and paste the two Jira Issues macro inside its body ("wrap" your Jira Issues macros in the Table Toolbox macro).…

If you have the Table Filter and Charts for Confluence app installed for your instance, you may try the Table Transformer macro and its changing column width feature. Here is an example with screenshots - just wrap your Page Properties Report macro in the Table Transformer macro and type in a custom SQL query.

Hi @Stuart McMullin , If you have the Table Filter and Charts for Confluence app installed for your instance, you may try the Table Transformer macro and its changing column width feature. Here is an example with screenshots.

Yes, it is known behavior of the Jira Issues macro - not every column header is influenced by language settings. The Table Transformer macro is a workaround for companies with multiple languages.

You need to list all the columns you want to display in the SQL query. You'll need to create the following nesting: Jira Issues macro (here you choose what columns you want to show) <- Table Transformer macro (here you list all the columns from the Jira Issues macro and translate them into English with the help of the…

The source code editor will be a perfect solution for your case as your table structure is a complex one. I've also recommended the Table Transformer macro for your previous question about the table width, and this macro provides a text formatting feature as well. Here is an example with screenshots. You may also try this…

Hi @Karel Wagner , If you have the Table Filter and Charts for Confluence app installed for your instance, you may try the Table Transformer macro and its changing column width feature. Here is an example with screenshots.

@Shyam Ganesh kandasamy , I've also got an idea that your problem may be in different languages for your users. Jira Issues macro can translate several columns from English to something else. The workaround may be to wrap your Jira Issues macro in the Table Transformer macro and use the following custom SQL query for your…

So you are using the Table Filter and Charts for Confluence app - the Table Filter, Pivot Table and Chart from Table are its macros. I suggest creating a support request so that we can investigate your issue safely and not in public. Attach the screenshots and the Page Storage Format to the ticket: Upper right corner of…

But there is no native built-in filtering in Confluence, and your Table Filter macro is not on the standard macro list. As I've mentioned before, the Table Filter macro is a part of the Table Filter and Charts for Confluence app. Maybe there is any mistake in the macro name? Or maybe you use JQL filters inside your Jira…

Hi @Shyam Ganesh kandasamy , Do you use the Table Filter macro provided by the Table Filter and Charts for Confluence app to filter your tables? If that is the case, please make sure that you've successfully saved the changes after the creation of all the filters. When you don't save the changes, the filters are not shown…

Please note that the Table Filter macro is provided by the Table Filter and Charts for Confluence app.

The Table Filter, Pivot Table, Chart from Table and Table Transformer macros are provided by the Table Filter and Charts for Confluence app. Please check if the app is installed for your instance.

Hi @preeti arun , You may type the following query into your Confluence search: macroName:table-excerpt-include AND text~"Master page name" AND text~"Excerpt name" Here the Master page name is the name of the page where your master table is located, the Excerpt name is the name of your Table Excerpt macro. As a result,…

Hi @Phil Bowker , Check if the Table Filter and Charts for Confluence app is installed for your instance - its Table Filter macro allows you to count totals for columns.

Hi @BT HGS , You may check if the Table Filter and Charts for Confluence app is installed for your Confluence instance (it supports both Server/DC and Cloud). Wrap your Page Properties Report macro in the Table Transformer macro and use its advanced cells formatting feature, for example, adding cells' background and…

Hi @Shyam Ganesh kandasamy , As @Vinod Ramadoss has recommended, you can solve your case with the help of the Table Filter and Charts for Confluence app. As your hosting type is Cloud, I decided to take screenshots for the new Confluence editor. At first, wrap you Jira Issues macro in the Table Toolbox macro. Here I wrap…

Hi @Stephanie Hinnerichs , Check if the Table Filter and Charts for Confluence app is installed for your instance - you may use its Table Transformer macro. Wrap your Page Properties Report into the Table Transformer macro and check the following community questions: * Here I answer how to change the order of your columns.…

Hi @Dave Lines , Our Table Filter and Charts for Confluence app and its Table Transformer macro from the version 6.3.0 provide a wiki markdown feature that covers your case. Here we have a list of use cases collected from our customers (conditional formatting, changing alignment, adding statuses, etc.) and the last one is…

Hi @Tanmay Gadkari , You may try the Table Filter and Charts for Confluence app and its Table Transformer macro. Wrap your Jira Charts macro in the Table Transformer macro: And list the columns as you need with the help of a custom SQL query. For example, I've used the following query: SELECT T1.'Assignee', T1.'Status To…

It seems to me that the standard Excel macro doesn't allow any formatting. If your table is not very big, it will be easy just to copy/paste it into Confluence and format it there. Maybe somebody else will come up with a better idea.

Hi @PaulinaPilch , If you have the Table Filter and Charts for Confluence app installed for your instance, we can suggest the following workaround: * convert your spreadsheet to a native-looking Confluence table with help of the Table from CSV macro (the macro recognizes both attachments and URLs); * wrap your CSV macro…

Hi @[deleted] , We can also suggest a workaround: your may check if you have the Table Filter and Charts for Confluence app installed for your instance and use its Table Excerpt/Table Excerpt Include macros. As I understood from your case, you use several Page Properties macros on the one Confluence page because you need…

@[deleted] , just insert the Table Transformer macro first. Then put the coursor inside the macro, type in "/" and insert the Jira Issues macro. Drag'n'dropping is really very tricky, especially in the new Cloud editor.

Hi @Anu Babu , We also have some short YouTube video tutorials how to work with reports in Confluence Cloud: * Page Properties Report macro; * Jira Issues macro; * Content Report Table macro. You may also check them out.

Hi @Ashish , You may use the Table Filter and Charts for Confluence app and its Table Transformer macro for this purpose. At first, insert the standard Jira Issues macro on to your page and choose what issue fields you want to show. The next step is to convert your Jira table from a table with a header row to a table with…

Hi @Leejunghyun , Check if the Table Filter and Charts for Confluence app is installed for your instance. Then you'll be able to reuse your source table with the help of the Table Excerpt/Table Excerpt Include macros as many times as you want. The main advantage of this method is that you don't need to make changes to all…