Natalie Paramonova _Stiltsoft_ Expert

Hi Fred, You can have a look at the Chart From Table macro that supports dynamic tables for building charts (the chart is automatically updated after updating a source table). The macro is included in the Table Filter and Charts for Confluence app, you can also find other macros (Table Filter, Table Transformer) useful for…

Hi @tbellmr , T1, T2, T3, etc. means the ordinal number of the table inside the Table Transformer macro. The macro provides the ability to merge multiple tables that's why there may be multiple tables within the macro body and we name them by their ordinal number.

Hi @tbellmr , I think our Table Filter and Charts for Confluence app can help you resolve your use case. The first option is to filter table data. Place the Page Properties Report macro (or a manually created table or other macros generating tables) in the Table Filter macro body. Filter all the not empty values in the…

You are welcome!

Hi @Fei Min Lorente , I think our Handy Macros app can help you resolve your use case. The app includes 12 difference macros and enhancements for Confluence. One of the features is the ability to set any number of tasks to display in the Task Report macro (the limitation is simply removed when the app is installed). So you…

Hi @alex b , You can calculate the standard deviation with the help of the Table Transformer macro bundled in the Table Filter and Charts for Confluence app. The app is compatible with ConfiForms. 1. Place the macro outputting tables within the Table Transformer macro body: 2. Use the following SQL query (select the…

Hi @Ramesh PS , In SQL syntax the double quotes character means a value while the single quote character means a column label. So please try the following query: SELECT 'RAG Status' AS 'RAG', 'JIRA Phase' AS 'Phase', 'Count Business Solutions' AS 'BS FROM T1 One more hint is when you type T1. you can see all the columns…

In case you hide the source table in the Chart from Table macro, you won't see both pivot and the source table. As a workaround, you can use the Table Excerpt and Table Excerpt Include macros. Wrap your source table in the Table Excerpt macro and place the Table Excerpt Include macro in the Pivot Table macro body. The…

Hi @Jordan Govreau , Please wrap your source table in the Pivot Table macro (Table Filter and Charts for Confluence app) to count the number of rows in each category because the Chart from Table macro requires numeric values when building a chart. After that wrap the Pivot Table macro in the Chart from Table macro to build…

You're welcome :)

Hi @Jasmine.Hatherly As far as I know, there is no such feature in Confluence by default. We develop Handy Macros for Confluence. Handy Tip is one of the macros bundled in the app. With its help, you can add pop-up tooltips to text, images, emoticons, etc. You need to highlight the element you'd like to add a tooltip to:…

@Ramesh PS , I'm happy it works for you :)

Hi @Chris Mitchell , As far as I know, the Task Report macro can't be configured in such a way. You can do this with the help of apps. We develop Table Filter and Charts for Confluence. You can wrap the Task Report macro in the Table Filter macro and apply the filtration parameter: Due Date is not empty. The Task Report…

Greig, thank you! Feel free to contact us to find solutions to your use cases. :)

Hi @Sigurd Schacht , As far as I know, there are no built-in macros that can help you. You can use the macros bundled in the Table Filter and Charts for Confluence app. The Table Excerpt and Table Excerpt Include macros will help you to display your table at the top of the page (you don't need to maintain two tables,…

Hi @Pankaj Sharma , There is no option to display the total row at the top of a table. I've added your vote for this feature in our backlog. Regarding adding total rows for the main tasks, you can try the Pivot Table or Table Transformer macros. You can submit a request at our Support Portal and give us an example of your…

The Table Transformer macro is included in the Table Filter and Charts app as well as the Pivot Table and Chart from table macros. This macro is available starting from version 5.0 of the app. Unfortunately, there are no options to rename table columns except this macro.

Hi @Ramesh PS , You can use the Table Transformer macro for this purpose. Wrap the Pivot Table macro in the Table Transformer macro, rename columns and build a chart based on the transformed table: Use the the similar SQL query: SELECT 'Column 1', 'Sum of Column 2' AS 'Column 2', 'Sum of Column 3' AS 'Column 3' FROM T* The…

Hi @chinmay shah , In case you have the Table Filter and Charts app installed, but can't find the Table Transformer macro or the Excerpt source option, you may ask your Confluence Administrator to update the app to the latest version because these features are available from version 5.0.0 of the Table Filter and Charts…

Hello, @chinmay shah, you are on the right track. However, the Excerpt source option is available starting from version 5.0.0 of the Table Filter and Charts app. Please, check the version installed in your Confluence instance. Also, please make sure you use the Table Excerpt and Table Excerpt Include macros instead of…

Unfortunately, there is no option to preserve filtration parameters without saving the macro for now. I'll notify you when we implement this feature.

In the app, if you want to preserve configured filtration parameters, you need to click the cogwheel icon on the filtration panel and then click Save changes: In case you face different behavior, please contact our support.

Hello, Tell me please if you use the Table Filter and Charts for Confluence app to filter your table? Thank you!

Hi Feliks, As @Jack Nolddor [Sweet Bananas] said Page Properties and Page Properties Report macros are a great solution for pulling data from separated pages and creating a master table. But they do only half the job. For example, you create a page for each client and insert the Page Properties macros: Then you create a…

Hello Robin, I'm with StiltSoft. We develop Table Filter and Charts for Confluence. You can consider the following macros included in the app: * Table Excerpt and Table Excerpt Include macros. You can use them to excerpt tables from any source (current page, specific page, child pages, pages by labels) and include them on…

Hello, @Diego, thank you! You're right, our Table Filter And Charts For Confluence app should meet the requirements. Moreover, in order not to create separated charts for each week and open them in the Expand macro, @cmurphy can configure filters for only one source table, copy filter URLs and paste them on the page as…

Hi Adam, The Page Properties Report Macro is great solution when you need to pull page properties containing only one row (column) with data on each page. If you'd like to pull more that one row (column) from each page, you can try our Table Filter and Charts for Confluence app (in case you use Confluence Server). With the…

Hi Karen, If you use the Table Filter and Charts app for building a chart and a pivot table, you need to filter not empty rows with the help of the Table Filter macro and then count the number of rows with the help of the Pivot Table macro.

Hi Catherine, Could you please submit a ticket in our support portal and attach the browser console log file? Thank you!

Hi Pam, You can do this with the help of the Table Transformer macro (one of the macros bundled in the Table Filter and Charts app). The macro allows performing complex calculations using SQL queries. Here is an example. Place two tables in the macro body. The first table is your source table with dates columns. The second…