Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hello, Please note that we've released the 7.9.0 version of Table Filter and Charts for Confluence, added the capability to select custom chart colors from a table. Select the corresponding columns with colors for the Colors in the table columns option. You can use colors from this list or define your own HEX code colors.…

Hello, Please note that we've released the 7.9.0 version of Table Filter and Charts for Confluence, added the capability to select custom chart colors from a table. Select the corresponding columns with colors for the Colors in the table columns option. You can use colors from this list or define your own HEX code colors.…

Hi @Kelsey Lubbe , Note that in your case, you can change the order of columns just choosing them with the help of autocompletion in Table Transformer according to your needs. Please see my exampe below: Use autocompletion: start typing, e.g., T1. and choose the column. Katerina Stiltsoft

Hello @Kelsey Lubbe Please try this SQL query: SELECT * FROM T* ORDER BY CASE WHEN T1.'Status' LIKE "Escalation Review" THEN 1 WHEN T1.'Status' LIKE "Root Cause Analysis" THEN 2 WHEN T1.'Status' LIKE "Corrective Action Plan" THEN 3 WHEN T1.'Status' LIKE "Pending Approval" THEN 4 ELSE 5 END Katerina Stiltsoft

Hello @Lisa Doris , You can try the Table Filter and Chart for Confuence app. It works with the standard Confluence Office Excel macro in different combinations. You can not only make calculations, but also filter data and visualize it. Katerina Stiltsoft

Yes, it's because the second part is not the full written part of the query. I use this query and colors apply: SELECT FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Labels'="Good" THEN "green" WHEN T1.'Labels'="Warning" THEN "yellow" WHEN T1.'Labels'="Bad" THEN "red" ELSE T1.'Labels' END + "}" + T1.'Key' + "{cell}") AS…

Note that you are using this part of the SQL query twice: FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Labels'="Good" THEN "green" WHEN T1.'Labels'="Warning" THEN "yellow" WHEN T1.'Labels'="Bad" THEN "red" ELSE T1.'Labels' END Please try to delete one of them. ................. Katerina Stiltsoft

Yes, our app works with both manually created and macros generated tables. It seems that we've faced a bug. I'll release the fix for it soon. Now, please try to replace FROM T* to FROM T1 Would you please confirm that it works for you? Katerina Stiltsoft

Hello @Tonja Davis , Please wrap your source table with Table Transformer and use the SQL query like this: SELECT FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Labels'="Good" THEN "green" WHEN T1.'Labels'="Warning" THEN "yellow" WHEN T1.'Labels'="Bad" THEN "red" ELSE T1.'Labels' END + "}" + T1.'Labels' + "{cell}") AS…

Hi @John Steele, You can try the Table Filter macro of the Table Filter and Charts for Confluence app. It works in the combination with the Jira Issue macro and helps to filter rows not equal to selected values. Katerina Stiltsoft

Hello @Nidhi, Please note that in Confluence Cloud combining our macros included in the app is only possible with a help of Table Toolbox using a new editor. Katerina Stiltsoft 

Hi @cuong hoang , Yes, you shoud set the path to the array. Could you please send us your JSON file to our support and clarify what you try to reach with Table from JSON and Table Transformer? Katerina Stiltsoft

Hello @Blessing Oni, You can build different types of charts and set colors with the help of the Chart from Table macro of the Table Filter and Charts for Confluence app. Katerina Stiltsoft

Hi @shrikant maheshwari , We haven't got a definite solution. I think you need to analyze traffic between a browser and a server. But firstly, I recommend you disable extensions in a browser and check whether it helps. Katerina Stiltsoft

Hi @Selvakumar, You can wrap you source table manually or a macro generated with the Table Trasformer macro of Table Filter and Charts, enable the Export to CSV button and then export data by one click from the page view mode: Katerina Stiltsoft

Hello @aakif shaikh, You can try the Table from CSV macro of Table Filter and Charts for Confluence app in this case. It allows you to output a table from CSV or TSV data source on the Confluence page. Katerina Stiltsoft

Hi @Christie Smith , Please check whether Table Filter and Chart for Confluence is installed in your Confluence. You can also try the standard Confluence macros: Excerpt, Excerpt Include. Katerina Stiltsoft

@Christie Smith Also, you can wrap your test script table with the Table Filter macro, then apply filters and use Copy the filter URL option in the filtration panel. Katerina Stiltsoft

Hi @Christie Smith You can try to use the standard Expand macro in the Test Script cells, and Table Excerpt/Table Excerpt Include macros of the Table Filter and Chart for Confluence app to display needed data from one page to another. Here's the exampe: Katerina Stiltsoft

Hi @Wade Henderson, In this case, you can try the Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros to display data from one page to another and Table Filter to apply different kinds of filters. Here's the info on how to combine Table Excerpt/Table Excerpt Include with Table…

Hi @Ellis McMahon, You can try the Table Filter macro of the Table Filter and Charts for Confluence app in this case. It will allow you not only to filter all kinds of table data, but also to calculate totals, to sort tables, freeze rows and columns and apply other table viewing options. Katerina Stiltsoft

Hi @kirthyiyer, Please submit a support request and attach screenshots of the case, the page storage format. You can view the Confluence storage format for a given page by choosing - > ​View Storage Format​. Thanks! Katerina Stiltsoft

Hi @David Wu, Note that there's also a row numbering option using the Table Filter macro. Katerina Stiltsoft

Unfortunately, there's no way to display non-tabular data to tabular using our app. Katerina Stiltsoft

Hi @Jm Ul, In this case, you can try the Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros to display data from one page to another, Table Transformer to combine several tables from the pages in a final table. Please see the example here: Merging Tables from Different Pages…

Hi @Kristen Pennell, You can try to do it with the help of Table Filter macro of Table Filter and Chart for Confluence app. Katerina Stiltsoft

Hello @Karthikeyan A , Please note that using the Chart from Table macro of Table Filter and Chart for Confluence app you can try the Multicolor scheme in the Column chart type (since version 7.3.0): Katerina Stiltsoft

Hello @Mukund Iyer Rajamony , You can try to use the Chart from Table macro of the Table Filter and Charts for Confluence app in your case: Katerina Stiltsoft

Hello @Emily Berg , We've released the fix for thу following issue in the 7.2.0 version: 1. Although the table data no longer appears within the Confluence page, it DOES still appear when I export the page to PDF (using Scroll PDF). Any thoughts on how to translate to the export? Katerina Stiltsoft

Hello buchhaltung@die-besserwisser.de , Please try our Table Excerpt(Include) macros to reuse your table on the current page or another one first. Then wrap your source table (Table Excerpt Include) with the Table Filter macro and specify the checkbox filter: Katerina Stiltsoft