Katerina Kovriga {Stiltsoft} Expert

Please, raise a support request then and attach the screenshots of your Google Sheet table and the Table from CSV macro settings. We'll try to give you some hints.

Try the Table from CSV macro - if you use Google Sheets, then you'll be able to connect your sheet to Confluence via its URL. It is rather convenient because you'll be able to update you Google sheet and all the changes will be automatically reflected in Confluence. And then you'll be able to filter/hide columns with the…

Hi @Nitesh S P , Check if your company uses any additional apps for visualizing table data. Standard Chart macro is not very flexible, so maybe you should try smth else. We can suggest using our Table Filter and Charts for Confluence app and its Chart from Table macro that is more advanced and "clever". Here is our demo…

As far as I know, Confluence provides only two macros to get information from Jira: Jira Issues and Jira Charts macros. Maybe it really doesn't suit your case.

Hi @Anders Bruhn Fagerjord , I think you can't achieve this unless you use any additional apps. For example, we can suggest trying our Table Filter and Charts for Confluence app. The first step will be using the Table from CSV macro (supports attachments and URLs) macro to embed your Excel table onto Confluence page. The…

Hi @Julius Agnazata , The standard Chart macro is not very flexible, so we suggest using additional apps for advanced use cases. For example, you may check if the Table Filter and Charts for Confluence app is installed for your instance. Here is an example how its Chart from Table macro recognizes table data: It seems to…

So you use the Jira Charts macro and it doesn't allow you to choose fix versions. Don't you use the Table Filter and Charts for Confluence in your company? Please check if there is the Table Filter macro listed in the macro browser. Then, I suppose, there can be a workaround by using the Jira Issues macro subsequently…

Hi @Maria Ciugurean , Couldn't fully get the question - what macro or app do you use to embed your test results onto your Confluence page? Is it a standard Jira Issues macros with some additional fields or something else? Maybe you could attach any screenshots or smth. As I understand, you need to group your data by…

Hi @Shalini Krishnamoorthy , The standard Chart macro is not very flexible: So if you have more advanced use cases or want to visualize dynamic macros, we suggest using additional apps, for example, the Table Filter and Charts for Confluence and its Chart from Table macro. Here you'll be able to choose the format of bar…

No, the app is a paid one. It is originally meant for filtering tables in Confluence, creating pivots and performing calculations. Wiki Markup support is just a tiny feature of the app that users are not always aware of.

Hi @Spencer Holt , If you have the Table Filter and Charts for Confluence app installed for your Confluence instance, I can suggest using the following workaround: * Use the Content Report Table macro (it shows the same information, but in a tabular form) * Enable live filtration for the macro * Set the reversed filter for…

@Mitchell Cardwell Here is a workaround to make your links clickable with the help of the Table Transformer macro provided by the Table Filter and Charts for Confluence app (check if it's installed for your instance). The Table Transformer macro supports Wiki Markup, so you can create clickable links inside your tables…

Hi @Casey Maynard , You may use two Table Filter macros - just wrap your table subsequently into the two macros. Then you'll be able to hide the required columns with the help of the first Table Filter macro and allow your colleagues to filter the result table with the hidden columns with the help of the second macro (they…

Hi @Lawrence , Here is your page in the edit mode: Don't create the Total row manually, it will be created automatically with the help of the Pivot Table macro. Here is a screenshot of the Jira Issues macro where you count your issues - created within a certain time period and closed (resolved) within a certain time…

Hi @Julian , I can also suggest using one of our apps - Handy Macros for Confluence. The add-on provides the Handy Status macro that accomplishes your case: you create pre-defined sets of statuses and choose any status you want (you can switch statuses in the page view mode as well).

Hi @Lawrence , You should insert the Pivot Table macro first on the page, then put you mouse cursor inside the macro body and insert the Jira Issues macro. So, the Jira Issues macro will be wrapped into the Pivot Table macro. And, of course, you'll be able to enter their settings separately. 

Hi @JK Kim , If you need to count cells with text (not numbers!), it is also possible with the Table Filter macro. Wrap your table in the macro body, go to the macro settings -> Table View -> Count totals for columns and choose to count not empty cells for any columns you want: Hope this helps your case.

Hi @Denis , As it was mentioned by @James Conway , it seems that you need to use the Workflow Report Macro - States report to track the statuses of your pages. If you need to filter the result table by statuses, for example, or filter your Page Properties Report macro, you may use the Table Filter and Charts for Confluence…

Hi @Lawrence , You may try the Table Filter and Charts for Confluence app. Insert the Jira Issues macro and paste the required JQL (for example, issues that were created and issues that were closed during the last 30 days - it seems, that you need to do something similar). To count the issues of both types, wrap the Jira…

Hi @Debra Jones , the link is the same - somehow it doesn't redirect if you click on it, but works perfectly well if to copy it and paste into the browser address page.

@Pansilu Diegayu Wickramasinghe , sorry it's my bad: forgot about the FORMATDATE expression in the SQL query. FORMATWIKI("{cell:bgColor=" + CASE WHEN DATEDIFF(day,"today",'Jack') <= "0" THEN "#FA7E70" WHEN DATEDIFF(day,"today",'Jack') > "0" AND DATEDIFF(day,"today",'Jack') <= "180" THEN "#FFE784" ELSE "#8FCA7D" END + "}" +…

Note that such JQL expressions as "-2d" are also available for the Date filter.

Hi @Daniel Keel , You've already found the solution yourself: use the "today" expression. Here is the whole table and today is 12 Feb 2021: Here I filter dates that are >= today: Here I filter dates that are <= today: And here I filter only today's dates:

Hi @Nicky , I can suggest using one of our apps - Handy Macros for Confluence. The add-on provides the Handy Status macro that fully accomplishes your case: you create pre-defined sets of statuses and switch them in the page view mode. Besides you'll be able to use Handy Dates - clever datepickers that allow you to change…

Hi @mgreco , I'm not sure if this is your case, but if your test reports return in CSV or JSON formats, then the Table Filter and Charts for Confluence app may come in handy. Check if the app has been already installed for your instance - look for the filtering button near the Edit page button or search for the Table…

You may also adjust column width with the help of the Table Filter and Charts for Confluence app and its Table Transformer macro. Please, check this example.

The app works with any tabular Confluence data (not only plain manually created tables, but different dynamic tables such as Jira Issues, Page Properties Report macros, etc.). It also includes the Table from CSV and the Table from JSON macros, so you'll be able to connect your database to Confluence via these macros and…

Hi @Matthew Buchanan , You may try the Table Filter and Charts for Confluence app. It allows you to export both original and filtered/aggregated tables to CSV (this is your case!), PDF and Word. Here is our short two-minute blog post with examples and screenshots.

Hi @Markus Raab , The Table Filter and Charts for Confluence app is one of our apps, so we are happy that you find it useful for your tables. What concerns adding/deleting table rows from the view mode, I'm not really sure if there are any plugins on the Atlassian Marketplace that allow you to perform such operations. If…

Hi @Ashish , Please check the previous answer from @Katerina Rudkovskaya _Stiltsoft_ - it fully suits your case. You may find the list of functions available for the Table Transformer macro here.