Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hi @Katharina_Klaus, We can also suggest trying our app – Table Filter and Charts for Confluence. If we are talking about manually created native Confluence tables, you’ll be able to use pagination and freeze first N rows/columns with the help of the Table Filter macro. The Table Transformer macro will help you to set the…

Hi @Lynda Jachimiak, We can also suggest trying our Table Filter and Charts for Confluence app and its Table Spreadsheet macro. You'll be able to import existing csv/xlsx files and continue to work with them in Confluence with all the Excel-like features. The add-on is free for Cloud 1-10 users, otherwise you’ll get free…

Hi @Chris Jones, The Table from JSON macro is provided by our app – Table Filter and Charts for Confluence. So, please let’s move to our support portal (it is based on Jira Service Desk and it’s confidential). Attach an example of your JSON file itself (not a screenshot), and we’ll try to help you with the case.

Hi @Rizwana_Firdaus, The Table Spreadsheet macro is stored as a page attachment: right upper corner of the page -> menu … -> Attachments. Here you may download the required previous versions of your spreadsheet and restore them.

Hi @Katie McGoff, Unfortunately, I couldn’t reproduce the issue (app version 9.7.1): I have the Jira Issues macro wrapped inside the Table Transformer macro with a simple SQL query “SELECT T1.'Key' FROM T1”. If I choose to hide all content, I see only a one-column table coming from the Table Transformer macro in my result…

Hi @Megan, I can suggest the following workaround for the case: The internal Table Transformer macros are used for your original queries and ad additional line with future headers: SELECT "Score" AS 'Value', SUM ('Score Value') AS 'Cost of Delay' FROM T1 WHERE Variable IN ("Revenue", "Cost Savings", "Strategic Value",…

Not sure that it is exactly your case, but you'll be able to delete (or change) data from table cells based on this cell's value or based on the value from another cell (but in the same row). You may browse our documentation for the "CASE... WHEN..." examples. The Table Transformer macro itself is based on the AlaSQL…

Hi @Ishaan Dev, We can also suggest our app that is Table Filter and Charts for Confluence. You may check its Table Spreadsheet macro and/or Pivot Table and Table Transformer macros if you prefer to use formulas in native Confluence tables. We’ll be also happy to arrange a live demo for you and your team – please book a…

Hi @Justine Hughes, If your company uses our Table Filter and Charts for Confluence app, we can suggest trying its Table Excerpt/Table Excerpt Include macros. You’ll be able to combine several tables into one master report, reuse your source tables and your master table several times, and aggregate/visualize them…

Hi @silvio croce, The simplest way to aggregate tables is to use the Pivot Table macro: And here is another variant using the Table Transformer macro: SELECT 'column1', 'column2', CONCAT_VIEW_AGGR(FORMATWIKI('column3' , "\n")) AS 'column3' FROM T* GROUP BY 'column1', 'column2' Hope it helps your case

Hi @Etienne Daloze, If I understand your question right, you have smth like this in your report: You may use the following solution for the case: SELECT *, DATEDIFF(day, "today", 'Stale Date') AS 'Remaining days till stale date' FROM (SELECT *, FORMATDATE(DATEADD(month, (SUBSTRING('Validity', 2, 1)::number), 'Updated')) AS…

Hi @Tatiana Marti, If you need to set background colors (conditional formatting), you may try our Table Filter and Charts for Confluence app and its Table Transformer macro. The add-on supports the Jira Issues macro, and you’ll be able to color its cells based on values (text, statuses, etc.).

Hi @[deleted], Sorry I haven’t come across the question earlier due to the weekend and time zones difference. Glad that you’ve found the solution yourself. For other people who may come across this question: in Confluence Cloud you need to use the Table Toolbox macro to nest several macros (just drag’n’drop other macros…

Hi @Blair Steinsson, We can also suggest trying our Table Filter and Charts for Confluence app and its Table Spreadsheet macro. The add-on is free for Cloud 1-10 users, otherwise you’ll get free 1-month trial. We’ll be happy to arrange a live demo for you and your team: besides the Table Spreadsheet macro, the app provides…

Hi @Ajay Shenoy, I can suggest the following workaround: Here you may use the Pivot Table macro or the third external Table Transformer macro (we’ll use them later for grouping).Also I’ve taken my screenshots for Data Center, so my macros are nested directly on the page. For Cloud you’ll need to recreate the same structure…

Hi @Ajay Shenoy, Not sure that I've got the case. The T2 comes from the Jira Issues macro, the T1 comes from the Table Excerpt Include macro and looks like the structure you provided ('SME' and 'User ID' columns). At first, you look up these two tables by T2.'Technical Lead' and T1.'User ID' columns. It means that when the…

Hi @Juan Carlos Toro, For me everything works just fine: SELECT *, FORMATWIKI("{cell:width=400px}" + T1.'Company name' + "{cell}") AS 'Company name' FROM T* As you can see, the second column bacame really wide after the transformation. So, please check your SQL query once more: maybe there are any typos or smth.

Hi @Danner Breault, Unfortunately, you can't exclude only the middle step of your transformation from showing. In this case you can show only the result transformed table or the source table+pivot table+transformed table. But there is a workaround: wrap your source table into the Table Excerpt macro and reuse it via the…

Hi @Jim Solomon, Yes, smth like this is definitely possible, please check the example below: Instead of the manually created table that I've taken for my example, you should put the Jira Issues macro inside the Pivot Table macro (our macros support dynamic Confluence tables such as Jira Issues, Page Properties Report,…

Unfortunately, the app doesn't provide this functionality and I really can't think of any possible workaround.

Hi @Kumar Bavandla, We can suggest trying our Table Filter and Charts for Confluence app and its Table from JSON macro.You’ll be able to recreate a table from a JSON attachment/url and then filter/aggregate/visualize it with the help of other macros that are also provided with the add-on.

Hi @Jim Solomon, Not sure if that is exactly your case, but maybe our Table Filter and Charts for Confluence app will help.If you use the Jira Issues macro with the most general JQL (for example, all the issues for one or several projects), you may use our Pivot Table macro to group (aggregate) this dynamic table. The…

Hi @Eva Kröger, Please raise a support request providing us with the page storage format and screenshots of your source data. We'll investigate the issue and hope it'll be resolved soon.

Hi @Casey Carll, Unfortunately, I don’t think that the Table Transformer macro will help with the case. It can, for example, rename a bunch of links in the column to smth short and clickable (please navigate to the “Creating clickable links” section). And you may try to split your full link by some symbol to leave only the…

Hi @Pujita, You’ll need an additional app from the Atlassian Marketplace to fulfill the case. For example, we can suggest trying our Table Filter and Charts for Confluence app and its Table Spreadsheet macro.

Hi @Pete Kalibat, To put it simply, you need to use the Jira Issues macro as a source table for the Table Spreadsheet macro. Unfortunately, it is not possible as for now, but we have such feature planned. I’ve added the link to this thread to our ticket, we’ll return here to notify you once the feature is implemented.

You can change the date format in the Reporting column of your source table to have it in the x-axis of the chart then. It's possible to do with the help of Table Transformer. Please see the example below:

Hi @[deleted], We can suggest trying our Table Filter and Charts for Confluence app and its Table Filter macro to export your tables in csv, Word and PDF formats.

Hi @Eva Kröger, Your tags say that you are on Confluence Cloud: it means that you can't wrap macros directly one into another and should use the Table Toolbox macro to create macro sequences. If you are on Server/Data Center, then your macros can be nested directly on the page. As I saw several errors from different…

Hi @Eva Kröger, From the visible error messages I can see that the Chart from Table macro can’t see its source table, then the Pivot Table macro also can’t see the source table, then there are other two errors that are not visible (the pink one is the most interesting one). As I understand, you have smth like that: Chart…