Katerina Kovriga {Stiltsoft} Expert

Hi @emagnun , For the first case use the following settings for your Pivot Table macro: To change your headers, wrap your Pivot Table macro into the Table Transformer macro and apply your custom SQL query: SELECT T1.'Release' AS 'My Release', T1.'Count' AS 'Count of My Releases' FROM T* Hope this helps.

No, there is no any way to hide the table headers.

Unfortunately, we don't provide such function: the header row is a significant part of tables in Confluence, besides it should be always visible to apply live filtration: And there is always some risk that users won't understand that there is a hidden table that they need to filter using the filtering panel. So our…

Hi @emagnun , Please go to your Table Filter macro where you have your Free Text filter and navigate to the Table View tab: Set the number of rows to show if not filtered to "0": You'll show only your filters and the table header without any rows by default (if the filters are not applied). If you filter (search for) smth,…

Hi @LoRe , You may use the Table Filter and Charts for Confluence app and its Table Filter macro for your case - wrap the Content Report Table macro into the Table Filter macro and set the required default sorting: And if you use the Content Report Table macro frequently, please check this short 2-minute video tutorial how…

Maybe you should browse the Marketplace for some apps - it seems that ConfiForms may come in handy for your case.

Hi @me , Please clarify which addon you use for this purpose. As I understand, it is not an out-of-the-box Confluence feature. We can suggest using the Table Filter and Charts for Confluence app - create a table with classes (plain text or statuses created with the help of the Status macro) and students, wrap it into the…

Hi @Alexi Vanderstraeten , You may use the Table Filter and Charts for Confluence app to filter you Content Report Table macro - just wrap the macro into the Table Filter macro and filter the Creator column by the @currentUser: If you want to filter the Task Report macro (you've mentioned tasks in the second part of your…

As I understand, you want to see the historical changes of your issues. Like, for example, two days ago you had 5 issues to do/0 done, yesterday 3/2, today 2/3. If to talk about Confluence, the Jira Issues macro and the Jira Chart macro reflect the current state of your issues without any historical memory.

Hi @phil_brown , Please define the "date function". If the problem is that you need to work with different kinds of dates (created, updated, etc.) but you are tired of going to the page edit mode and changing the JQL inside your Jira Issues macro, we can suggest using additional apps from the Marketplace. For example, here…

Hi @Anna Dziubańska and @Michelle Rau HP , I'm from the Stiltsoft team and the Table Filter and Charts for Confluence app is one of our add-ons. We confirm that the app works with the Page Properties Report macro perfectly well - you may check here for the use cases. The 300 rows is not a limit for our macros, they support…

The first variant splits and then joins your keys strictly - as you can see, there is the name of your project "TER-" included into the 'split' and 'indexOf' sql functions. If you work with another project, then you'll have other keys (for example, WER-13, WER-15, etc.) and put "WER-" for 'split' and 'indexOf' functions.…

Hi @Emily Berg , We've recreated your case here: If you have the only one type of keys (TER-XX), then we suggest using the following SQL query (it will be a more reliable one): SELECT * FROM T1 LEFT JOIN T2 ON T1.'Tested by'->split("TER-")->indexOf(REPLACE(T2.'TER Key', "TER-", "")) > -1 If you have other types of projects…

Hi @Julien Senecal , Please follow my example. Step 1 will be to wrap every mini table with statuses into the Table Excerpt macro and assign it any name you want (it will be Test for my example): Step 2 will be to nest our macros inside each other directly for Server/DC or with the help of the Table Toolbox for Cloud: Step…

Hi @Giorgio Luna Almeida , There is no such integration out-of-the-box, so you'll need to browse the Atlassian Marketplace and find relevant apps there. For example, we can suggest using the Table Filter and Charts for Confluence app. It supports two options: * Your case as working with your spreadsheet outside of…

Hi @richardofrugeley , Here is a question where I show how the Chart from Table macro works - please, look at the first screenshot. Your table should be inserted inside the macro body (the Chart from Table macro in my example and the standard Chart macro for your case). So, you need to copy/paste your table inside the…

Hi @Clara Matheus , there is a workaround using the Table Filter and Charts for Confluence app. Wrap your Decision Report into the Table Transformer macro and follow this example to set the predefined column width. Hope this may help your case.

Hi @[deleted] , We can suggest using the Table Filter and Charts for Confluence app (maybe it's already installed for your instance). Here is an example how to create a Gantt chart based on your Jira Issues macro. The only difference for Confluence cloud is that you'll need to use the Table Toolbox macro to nest several…

Hi @Hanief Mumtazul Anwar , There is such workaround with the help of the Table Filter and Charts for Confluence app and its Table Transformer macro. Wrap your Jira Issues into the Table Transformer macro body and use a custom SQL preset to create a new column with conditional statuses: SELECT *, CASE WHEN T1.'P' LIKE…

Hi @BB GG , Maybe you use the Table Filter and Charts for Confluence app in your company? Its Table Filter macro may come in handy for your case: create several filter views based on your "selects" (you'll work only with the one table) and save the filter URLs. Then you'll be able to create buttons (links) for every…

Hi @Simone , The Options tab -> Show source content was introduced in the 7.1.12 version of the Table Filter and Charts for Confluence app (released on the 22 Mar 2021). And the current version on the Marketplace in 7.1.13. So, please update the app. 

Hi @Simone . Please check this question - here we answer how to hide the "Issues - Refresh" messages. Go to the Table Transformer macro settings -> Options tab -> Show source content and choose the Hide all content variant. Does it work for you?

Hi @Emily Berg , If you use the Table Filter and Charts for Confluence app in your company, you may use its Table Transformer macro to hide the "No issues found" message. Wrap your Jira Issues macro into the Table Transformer macro body and choose the following tab into its settings: Here is how your full result table will…

Hi @Mark Sennott , I can suggest using the Gantt chart provided by the Table Filter and Charts for Confluence app instead of the Roadmap macro. The chart is based on the manually created or Jira generated tables: Every time the tables are updated, all the changes are immediately reflected on the chart.

Hi @Xenia T. , The Handy Macros for Confluence app really provides the Handy Timestamp macro that fully suits your case, but unfortunately for Server and Data Center hostings. The Cloud version of the app includes other helpful macros but not this one as for now.

Hi @Flávio Silva , It seems that the Table Exporter can provide only manual export. What concerns your case in general, we suggest storing and processing everything in one place - in Confluence. You can use, for example, the Table Filter and Charts for Confluence app to filter your tables, perform calculations, aggregate…

Hi @Guinevere Orvis , You still can implement the same case using the Page Properties Report and Status macros. If you need to filter you final Page Properties Report by statuses, then you'll need additional apps such as Table Filter and Charts for Confluence. Here is a short 2 minute video tutorial how to use the…

Hi @Sereima Kavetani , as it was mentioned before, there is no such feature in Confluence out-of-the box, so you'll need additional apps. For example, you may use the Table Filter and Charts for Confluence app. Its Table Transformer macro allows you to perform a wide range of table calculations as well as conditional…

Hi @Jens Gerlach , The app is meant to replace Excel in Confluence (you'll be able to filter manually created and macro generated tables (and the Page Properties Report macro as well), create pivots, count totals and perform advanced calculations in your tables as well as visualize your aggregated data and use conditional…

Hi @Disha Agarwal , You'll need additional apps to implement your case. For example, you may try the Handy Macros for Confluence app. Its Handy Status macro allows you to set up predefined sets of statuses that you can use inside your table cells and switch in the page view mode as well.