Katerina Kovriga {Stiltsoft} Expert

Hi @davin , the Table Filter and Charts for Confluence app is our add-on, and we always recommend it for freezing rows/columns of the ConfiForms macros (as you are doing now as a workaround). The Table Filter macro also provides sorting - you may also try to apply it to your Table View macro.

Hi @[deleted] , We can suggest trying our app - Table Filter and Charts for Confluence. With this add-on you'll be able to filter your tables, aggregate your data and create pivots, perform various calculations and visualize your information, build complex reports collecting data across your Confluence instance. Here are…

The Table Transformer macro is based on the AlaSQL library, its functions may differ a little bit. Glad that everything works!)

@Paul Gwin Try this variant: SELECT FORMATWIKI("{cell:bgColor=" + 'color' + "}" + FORMATDATE(T1.'Date') + "{cell}") AS 'Date', FORMATWIKI("{cell:bgColor=" + 'color' + "|textColor=" + CASE WHEN T1.'AM-1' NOT LIKE "*%" THEN "BLACK" ELSE "RED" END + "}" + T1.'AM-1' + "{cell}") AS 'AM-1', FORMATWIKI("{cell:bgColor=" + 'color'…

It seems that your condition "(week,"today",'Date') == 0" colors only today's date - enter the 01 Jun 2021 into your table and the line will turn yellow.

The original query works just fine - I recommend to use it: SELECT FORMATWIKI("{cell:bgColor=" + 'color' + "}" + FORMATDATE(T1.'Date') + "{cell}") AS 'Date', FORMATWIKI("{cell:bgColor=" + 'color' + "|textColor=" + CASE WHEN T1.'AM-1' NOT LIKE "*%" THEN "BLACK" ELSE "RED" END + "}" + T1.'AM-1' + "{cell}") AS 'AM-1',…

@[deleted] And here is another more precise SQL query for your case: SELECT "Yes" AS 'Count', SUM(IF(T1.'Column A' = "Yes", 1, 0)) AS 'Column A', SUM(IF(T1.'Column B' = "Yes", 1, 0)) AS 'Column B', SUM(IF(T1.'Column C' = "Yes", 1, 0)) AS 'Column C' FROM T1 UNION ALL CORRESPONDING SELECT "No" AS 'Count', SUM(IF(T1.'Column…

Hi @[deleted] , There are no such macros out-of-the-box, you'll need some additional apps to complete your case. In this thread I suggested using our app - Table Filter and Charts for Confluence (it seems that it was also your question judging by the username). And here is another bunch of screenshots for you: wrap your…

Hi @[deleted] , We suggest trying our app - Table Filter and Charts for Confluence. The first step is to wrap your table into the Table Toolbox macro: The second step is to create the following nesting: your table <- Pivot macro <- Chart from Table macro. Then we need to count the number of your text values for the Column…

Hi @Paul Gwin , I've turned to our developers about your combined case related to the formatting both by background and text color and here is the result SQL query for your second Transformer: SELECT FORMATWIKI("{cell:bgColor=" + 'color' + "}" + FORMATDATE(T1.'Date') + "{cell}") AS 'Date', FORMATWIKI("{cell:bgColor=" +…

Hi @Ranjini K A We can suggest using our app - Table Filter and Charts for Confluence app (maybe it's already installed for your instance - try to find the Table Filter macro in the macrobrowser). You'll be able to create your table based on the attachment or URL with the help of the Table from JSON macro. The next step is…

It is also possible to change the text color with a rather similar SQL, here is an example from our documentation. I'll get back to my test instance tomorrow and provide you with a new query.

Hi @Paul Gwin , Wrap your table into the two Table Transformer macros subsequently (if your hosting is Cloud, then use the Table Toolbox to nest several macros): Use the following SQL for the first (internal) Transformer: SELECT *, CASE WHEN T1.'AM-1' IS NULL THEN "-" ELSE T1.'AM-1' END AS 'AM-1', CASE WHEN T1.'AM-2' IS…

Yeah, you are right, the Table Filter and Charts for Confluence app was created by the Stiltsoft team - the name of the team is included into my username. But I know that other apps support CSV import as well, so you may find smth else to avoid manual routine with links.

Thank you and we'll be happy to show everything during a real-time call. I'll warn the team about this thread and your use case.

Yeah, you've got the concept quite right - if you organize your data into similar tables with the headings BRule (this column will be for the number of your rule), Paragraph (here will go your text) and Tag (here you can use the Status macro and define the required field), you'll be able to collect your tables into the one…

Hi @[deleted] , If you have your data organized in a tabular form (multiple row tables), you may use the Table Filter and Charts for Confluence app to collect information throughout your Confluence instance. Here is a step-by-step example of a similar use case, please take a look. Maybe you'll be interested in a live demo…

Hi @stephen.harland , If you have any additional apps installed for your Confluence, you may try to use their features to work with links. For example, if you use our app - Table Filter and Charts for Confluence for filtering your tables and aggregating data, you may use its Table from CSV macro to upload your excel file…

Hi @emagnun , Please try the following: SELECT T1.'Product Type', T1.'Count FY2019', T1.'Count FY2020', CASE WHEN ROUND((T1.'Count FY2020'*100/T1.'Count FY2019' - 100), 2) LIKE "Infinity" THEN "100" ELSE ROUND((T1.'Count FY2020'*100/T1.'Count FY2019' - 100), 2) END AS 'Growth, %' FROM T*

I'm afraid that such custom graph where you show both absolute numbers and percent of growth in comparison with the previous period is not possible within our macro.

Hi @emagnun , You may try the following: create a sequence "your table <- Pivot Table <- Table Transformer <- Chart from Table". And set your macros as it is shown on the screenshots: Pivot Table macro Table Transformer macro SELECT T1.'Product Type', T1.'Count FY2019', T1.'Count FY2020', ROUND((T1.'Count…

Hi @Eric Vaughn Heisler , We can suggest using our app to filter your Jira Issues macro - Table Filter and Charts for Confluence app. Its Table Filter macro works with the Jira Issues macro perfectly well - you'll be able to show as many issues as you have by the Jira Issues macro and filter them by any column (and several…

Yes, it is possible to use the Jira Issues macro with the Table Transformer macro and here is one of the examples from the Community. What concerns your case, I've recreated the two tables manually but it doesn't matter if the second table is generated by the Jira Issues macro or manually created. The main thing is that…

I can come up only with the following workaround - you may use the cumulative running totals. Wrap your Jira Issues macro into the Table Toolbox macro and create a sequence Jira Issues <- Pivot Table <- Table Transformer macro. The Pivot Table is the same table from the previous answer. Then go to the Table Transformer…

If you have any specific questions, I can suggest raising a support ticket, where you'll be able to attach screenshots. 

The Table Excerpt/Table Excerpt Include macros are pretty similar to the Page Properties/Page Properties Report macros but allow you to collect multiple-row tables. Wrap your Pivot Table macro into the Table Excerpt macro: And give it a unique name: Then collect your Excerpts with the help of the Table Excerpt Include…

No, you'll need your Confluence administrator to install the app (both free apps and paid ones).

Hi @Patrick Mayrhofer , As I understand, you are trying to wrap your pivot tables into the Page Properties macro and collect a report with the help of the Page Properties Report macro. And the problem is that Page Properties doesn't recognize the Pivot Table macro. We suggest using our native macros - Table Excerpt and…

Hi @Damla Naz Yilmaz , You may use additional apps to work with CSV files in Confluence, for example, the Table Filter and Charts for Confluence app and its Table from CSV macro. The macro allows you to output a table from CSV or TSV data source (URL/Google Sheets&Google Drive or an attached file). And you'll be also able…

Hi @Juan Gomez , You may also browse Atlassian Marketplace for similar features. For example, the Handy Macros for Confluence app provides a Handy Tip macro for Server/DC hostings. The Handy Tip macro is a simple tool for adding pop-up tooltips to text, images or emoticons. It helps to shorten the length of texts and at…