Katerina Kovriga {Stiltsoft} Expert

Hi @Ashley Renlund , You can also try to use the Table Filter and Charts for Confluence app. It works with the Jira Issues macro just fine and allows you to create visualized dashboards right in Confluence. At first, you'll be able to filter the issues of the particular epic using JQL. Then you can use the Pivot Table…

Hi @Alex Hadden-Boyd , As I can see, you were recommended to use the Table Filter and Charts for Confluence app to work with the Jira Issues macro in Confluence. Our add-on really works with the Jira Issues macro just fine and allows you not only to perform calculations and create pivots, but make visualized dashboards…

Hi @Luca Ramassa , We can also recommend you to use our app - Table Filter and Charts for Confluence. Besides different filters, pivots and calculations for your Confluence tables, it contains the CSV macro. This macro allows you to output a table from CSV or TSV data source (from a URL or an attached file).

Hi @vinay singh , Unfortunately, the Table Transformer macro doesn't support "\n" as an empty line. You can read more about different use cases with the Transformer macro here. If you need any further assistance, feel free to raise a support ticket, describe your use case and attach screenshots of your tables.

Hi @Murali , You were suggested to use the Table Filter and Charts for Confluence app in your previous question about the Page Properties Report macro and filtration. The same add-on will help you to solve your current case. Step 1 is to use the Table Excerpt/Table Excerpt Include macros to collect your multiple division…

Hi @himashuk , In our Table Filter and Charts for Confluence app we provide the Table from CSV macro that allows you to output a table from CSV or TSV data source (URL or an attached file). Or maybe you should browse marketplace and look for some free database connectors. Unfortunately, we don't have any solution that is…

Hi @Swarna Chilakala , We can recommend you to try our app - Table Filter and Charts for Confluence. Wrap your Page Properties Report or Jira Issues macro in the Pivot Table macro to count the number of different statuses and then add the Chart from Table macro to show the required percentage. If you want to calculate…

Hi @Prateek Jain , You can use our app - Table Filter and Charts for Confluence. Wrap your Jira Issues macro in the Table Filter macro and show only the required issues. Here is an example for you to watch (a two-minute YouTube video from our official channel). Our app works with the Jira Issues macro perfectly well and…

Hi @Laith Abu Rakty , You can try our app - Table Filter and Charts for Confluence. If you need to sort your table, you can use the Table Filter macro to apply the default sorting to one or multiple table columns in the ascending or descending order. You'll be also able to apply different kinds of filters (dropdown,…

Hi @Paul Wijnen , The Description field is an unsortable one in Confluence, so it will be a little tricky to sort it. At first, wrap the Task Report macro in the Table Transformer macro (no changes in the settings required). Now all the fields are sortable. Then wrap both macros in the Table Filter macro where your filters…

Hi @Andrew Karyakin You can try our app - Table Filter and Charts for Confluence. Its Chart from Table macro contains the Gantt chart as well as many more other handy types of graphs. Besides our app works with the Jira Issues macro perfectly well, and you'll be able to create visualized Jira dashboards right in Confluence…

Hi @sanjyot bhosale Yes, you are right - the Table Filter macro is a part of the paid Table Filter and Charts for Confluence app. But note that you have one month of a free trial. You'll be able to install the app with an evaluation license and "play" with all the macros.

Not sure if this is what you exactly mean, but check our app - Table Filter and Charts for Confluence. It contains the Table from CSV macro that will output a table from CSV or TSV data source (attachment or URL). Besides our app allows you to set filters, make pivots and perform calculations - it will help you to…

For the Cloud Confluence instances use the Table Toolbox macro to nest several macros. You won't be able to do it manually because of the Cloud editor limitations. Insert the Table Toolbox macro on your page and then insert the Jira Issues macro right into its body. You'll got smth like this: Now go to the Table Toolbox…

We can recommend to use our app - Table Filter and Charts for Confluence. Wrap your Task Report macro into the Table Filter macro and use the free text filter to filter your tasks by descriptions. Note that our filter works with statuses and recognizes their text successfully. Standard Task Report: Task Report&Table…

Hi @Paul Wijnen We can recommend to try our app - Table Filter and Charts for Confluence. Wrap your Task Report macro into the Table Filter macro and use different types of filters for every required column. For example, you'll be able to filter by assignee (dropdown filter), due dates (date range filter) and description…

Hi @Mukund Iyer Rajamony The standard Chart macro is not capable of recognizing CSV attachments. We can recommend our app - Table Filter and Charts for Confluence. At first, you can use the Table from CSV macro to build your table from the CSV (TSV) data source. Optionally, you can use our filters and pivots to structure…

Hi @Mani Sundaram It is not possible to perform calculations and create pivots in Confluence out-of-the-box. We can recommend you to check our app - Table Filter and Charts for Confluence. It works with the Jira Issues macro perfectly well, and you'll be able to filter your issues, make pivots and even visualized…

Hi @Casey Wassom, We can recommend you to use our app - Table Filter and Charts for Confluence. The Table from CSV macro will help your users to create Confluence tables from .csv and .tsv Jira files. You'll be also able to filter your Confluence tables, make pivots and create charts.

I've seen the file - it's a .xlsx file with several pivots, graphs and pages as well. Our app allows you to upload raw information from the external database directly to Confluence - you'll get one big table from the source CSV file. All the filters and pivots are set in Confluence, you are not working with Excel at all.…

Yeah, we often come across such use cases - that is the reason of the Table from CSV macro implementation. It's a relatively new feature added to help our customers to transfer data from external databases to Confluence.

The Table from CSV macro works with the input that you've created. If you upload only prefiltered data and not the big source table, than you'll got the prefiltered result table in Confluence and you'll continue to work with it (create charts, set additional filters, etc.). But the app was developed for users not to switch…

Hi @Fred Erick, The Chart macro is not very flexible, so you'll need to rearrange your table in a horizontal way. And for the second question - there are no any native filtering tools in Confluence. So we recommend to use our app - Table Filter and Charts for Confluence. You'll be able to create tables from spreadsheets…

Hi @Tom Williams , We recommend our Table Filter and Charts for Confluence app to work with Jira Issues macros. You'll be able to sort your issues on the fly like in Excel and save the required filters for other users, make pivots to count, for eхample, the numbers of issue types and issues per assignee, etc. Here are some…

Hi @Sussanne Maybe anchors will help you to get from one important cell to another. You can read this Atlassian document about links and anchors.

Do you mean the Excellentable Spreadsheet for Confluence by AddTeq? Cause I couldn't get any results for the AppTeq on the Marketplace. If it is, then you can read their docs https://www.addteq.com/exc/user-guide/faqs-how-to-use-excellentable/how-to-freeze-rows (they have section related to freezing). And originally I…

Hi @Felix Occhionero I'm not sure if you mean the Office Excel macro or the Excel for Confluence app by Bob Swift by saying about the excel plugin. But in both cases you can try to use our app - Table Filter and Charts for Confluence. Its Table Filter macro has the option to freeze rows and columns both for original…

Hi @Aitor Matilla It seems that you mean Product Requirements blueprint in Confluence and you need to sort the result table based on the Page Properties Report macro. We can suggest you use our app - Table Filter and Charts for Confluence. Its Table Filter macro works with the Page Properties Report macro just fine. You'll…

Hi @Ramkumar Subramanian There are no any out-of-the-box tools to make calculations in Confluence tables. We can recommend to use our app - Table Filter and Charts for Confluence. It includes the Table Transformer macro: you wrap your table (or Jira macro) into its body and type in a simple SQL query to convert seconds…

Hi @Priya Ramakrishnan , You've answered the question yourself - wrap the CSV macro in the Table Excerpt macro and reuse the table with the help of the Table Excerpt Include macro. Thereby you'll need to attach your CSV file only once, but will be able to make as many charts and pivots as you want.