Katerina Kovriga {Stiltsoft} Expert

Hi @jfuentes , You may try the Table Filter and Charts for Confluence app. Wrap your Jira Issues macro in the Table Filter macro and set the required filter: Here I use the Resolution field cause we don't use labels, but you may choose the Labels field or whatever field you need. Then go to the Filtration tab and set the…

Hi @Алена Чернышева , You may try the standard Attachments macro: Additional information (for example, labels) is shown only if you click on the arrow and view the details of the required file.

Hi @Richard Gunther , It is not possible with the standard Page Properties Report macro, the Label field is an obligatory one. We can suggest using our Table Filter and Charts for Confluence app. It's a paid plug-in but you'll have one month of free trial to see if it suits your needs. The app provides the Table…

Then maybe pagination will be helpful - our Table Filter macro (that is a part of the app mentioned before) provides such feature as well.

Hi @Stella Wong , You may try the Table Filter and Charts for Confluence app. Firstly, enable live filtration for your table: Then go to the filtering options and choose the Hide columns feature: Now you can type in the column names that you want to hide and save changes if required: Hope this helps your case.

Ask your colleague to recreate the case under his/her password and on another Confluence page - maybe its a bug or smth. Don't have any other ideas.

Then check if your Jira and Confluence are connected and that your JQL is right (use a simple one): You should be able to preview your issues right in the macro. If you see nothing (your preview is blank but you are sure that the JQL is 100% right), check that you have the permission to view the Jira project you want to…

Hi, @Nasreen Nisar Ahmed Shaikh Do you use the Jira Issues macro to display your issues in Confluence? The Resolution field should be shown if it is chosen in the Columns to display field: And your JQL can be very simple (for example, project = Project Name), all the fields to display (and the custom fields as well) you…

Try to select several cells, click the down arrow and choose to merge cells:

All the changes from Jira will be reflected on your Confluence page immediately, but unfortunately there are no any triggers to remind your colleagues to check the page (like email notifications, for example).

Hi @Arthur Roumimper , You may also try YouTube courses from our company: * Quick Start with Confluence (for novice Confluence users, 8 videos, 15 min avg. each) * Advanced Permission and Security Management in Confluence (for power users, space admins and novice Confluence administrators, 6 videos, 20 min avg. each) Hope…

Hi @Sundar , As usual, it is better to use Page Properties/Page Properties Report macro to manage requirements in Confluence. This macro is set by default in the Product Requirements template (but you can always customize the template to suit your needs). As a result, you get a combined summary report related to all your…

Hi @Gregory Muir , We can suggest using the Table Filter and Charts for Confluence app and its Table Transformer macro. You need to wrap your Page Properties Report macro and an additional table with the Title/Comments columns in the Table Transformer macro and lookup the two tables by the unique Title column. In the view…

Hi @smak , You may try addons from the Atlassian Marketplace that provide sorting in tables (and Page Properties Report macros as well). For example, our Table Filter and Charts for Confluence app and its Table Filter macro allow you to sort your columns intuitively besides other functions such as filtering, calculations,…

Hi @Juan Delport , You may try the Table Filter and Charts for Confluence app. It provides the Table from CSV macro that supports outputting data from a URL (Google Sheets and Google Drive as well), all the changes will be reflected in Confluence automatically.

Try to raise a support ticket for the Atlassian and, as for now, attach your files to the current page only. Seems that smth is wrong with the Excel macro search.

Hi @Leah Bell , You may try the Table Filter and Charts for Confluence app in combination with the Jira Issues macro. Your JSD should be connected to your Confluence instance and the required support project should be chosen in the Jira Issues macro. Then you'll be able to use our filters, pivots and charts to create…

Hi @Francesca Baldwin , It seems that you are doing everything right. I've checked this macro in our test environment and got the following result: Works if you search for an attachment on the current page -> Doesn't work if you try to browse for the Excel file on some other pages -> Couldn't get a preview and save the…

Hi @Alexander Stoyanov , You may try the Table Filter and Charts for Confluence app. Wrap you table in the Table Transformer macro and apply conditional formatting with the help of the Wiki markup: Type in your custom SQL query: SELECT FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Color' LIKE "(122,28,134)" THEN "#7a1c86"…

Hi @Carlos Fry , You may try the Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. These macros allow you to collect multiple-row tables from the current page, specific page, page and childpages, page and all descendants or pages with labels. Please check an example of the use…

Hi @Rune Hellem , Try the Table Filter and Charts for Confluence app and its Table from JSON macro. The macro allows you to output a table from JSON data source (URL or an attached file).

You'll need to use the Table Transformer macro instead of the Table Filter macro. Wrap your Jira Chart into the Table Transformer macro, choose the Custom transformation, go to the SQL query tab and paste the following: SELECT T1.'Assignee', T1.'Status Done' FROM T* This is an example for my table from the previous…

Hi @Lakmal Padmakumara , It seems that there are no line charts with both X and Y date scales. For similar purposes (to track multiple projects and their milestones) try to use a Gantt chart. You'll be able to find its simple version in the standard Chart macro or a more advanced one in the Chart from Table macro provided…

Hi @Sara Phillips , Check the Table Filter and Charts for Confluence app. It provides the Table Excerpt/Table Excerpt Include macros that collect tables (and multi-row tables as well!) within * current page * specific page * page and childpages - that is your case! * page and all descendants * pages with labels Then you…

I see the ticket, thanks, our support will look into it. As for now, try to set the Date format manually as M dd, yy - it will correspond your Due date format of Apr 10, 2020.

Hi @Provangelist , We can suggest using the Table Filter and Charts for Confluence app that works with the Jira Issues macro perfectly well and allows you to create visualized Jira Dashboards right in Confluence (and the Gantt Chart as well). You didn't specify your hosting type, but note that our app supports Cloud,…

Hi @AzZzA , The Table Excerpt/Table Excerpt Include macros are provided with the Table Filter and Charts for Confluence app. Check if the app is installed&enabled for your Confluence instance and its version is the latest one (6.2.0 as for now).

Hi @Joe LaBarre , We can suggest using the Table Filter and Charts for Confluence app to get rid of Excel and track everything in Confluence. Wrap both your Content Report Table macro and your optional Title/Created table in the Table Transformer macro: And use the following SQL query to merge your tables by the unique…

Hi @Rochelle Lim , We can suggest using the Table Filter and Charts for Confluence app. Here is the result that you can achieve with the help of the Pivot Table macro: Insert two Task Report macros (one for complete tasks and one for incomplete ones because you can't get both at the same time) and wrap each macro in the…

Hi @Subrata Mukherjee I've tried to recreate your use case and aggregate the number of created issues by month and quarter. Here is the Jira Issues macro wrapped in the Pivot Table macro: Here are the settings of the Pivot Table macro: As you can see, I didn't change the default Date format that was picked automatically by…