Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hello @Robin, To hide the source table in Table Transformer, please switch to the Options tab and set Hide all content in Source data: In general, notice that if you're using the latest versions of the app, you do not need to use Table Transformer now for merging tables, just tick the Show as a report table option in Table…

Hi @Joanna Weir You can try the following SQL query in Table Transformer: SELECT T1.*, (SELECT COUNT(DISTINCT T2.'Score') + 1 FROM T1 T2 WHERE T2.'Score' > T1.'Score') AS 'Rank' FROM T1

Hi @jira_admin_cu, You can set the following dynamic time interval format in the Table Filter macro: weekstart But note that filtration will work starting with Monday in case of using English(UK) language instead of, for example, English (US) in Profile (find more details here).

Hi @carmel farrugia, If you use the standard Excel macro and by the slicer you mean filtration, then your case is not possible. If you want to filter your data and create pivot tables/charts based on this filtered table, then you need additional apps from the Atlassian Marketplace. We can suggest trying the app that we…

Hi @Megan, You may use the following SQL query: SELECT 'Key', FORMATWIKI("$" + 'Revenue') AS 'Revenue, $' FROM T* Hope it helps your case.

Hi @Brijendra Singh, Hope that I’ve got your question right: to create several different charts based on the same filtered table, you need to use the Table Excerpt/Table Excerpt Include macros. So, you’ll have the following structure of nested macros: Confiform Table View <- Table Filter <- Table Excerpt. We reuse your…

Hi @Megan, You are on the right way, just expand the existing structure of your SQL query to cover all the columns where you need to replace IDs by names: SELECT 'Col 1', 'Col 2', 'Col 3','Col 4', 'Name' AS 'Col 5' FROM (SELECT 'Col 1', 'Col 2', 'Col 3', 'Name' AS 'Col 4', 'Col 5' FROM (SELECT 'Col 1', 'Col 2', 'Name' AS…

Hi @Pei-ju Hsu, Please refer to our support (the portal is confidential). Attach the page storage format of the current page (with Table Excerpt Include and Table Filter) and of the source page where your Table Excerpt is located. To get the page storage format, navigate to the upper right corner of the page -> menu … ->…

Hi @Jason D, We can also suggest trying our app – Table Filter and Charts for Confluence. Our Table Spreadsheet macro allows you to import your existing Excel file in .xlsx and .csv formats and work with it right in Confluence. The macro supports all the basic Excel functions: cell formulas, filtration, dropdowns,…

Hi @Felicia Cazer, We can also suggest trying our Table Filter and Charts for Confluence app and its Table Spreadsheet macro. We developed this macro to transfer all the basic Excel-like features right in Confluence. Besides, our spreadsheets support collaborative editing and can be updated both from the page view and page…

Hi @[deleted], To rename the columns, you’ll need to wrap your Pivot Table macro in the Table Transformer macro. On Confluence Server/Data Center you can do it directly and on Confluence Cloud you need the Table Toolbox macro to nest macros. To hide unwanted columns, use the Table Filter macro on top. The “Hide column”…

Hi @Nate Dickinson, We can suggest trying our Table Filter and Charts for Confluence app. Our macros support the dynamic Jira Issues macro. So, you will be able to display your issues, their types, and priorities on Confluence page via the Jira Issues macro (in a tabular view, each issue for each row). Then you may wrap…

Hi @Rafael Gilardino, Hope this example will help your case: SELECT *, 'Pagetitle'->split(": ")->1 AS 'Component name' FROM (SELECT *, @PAGETITLE as 'Pagetitle' FROM T*) Then you will be able to use another Table Transformer macro and merge your master table with mini tables pulled from the specification pages by the…

Hi @udaykiran, We can suggest trying our app – Table Filter and Charts for Confluence. Its Pivot Table macro supports dynamic tabular Confluence macros. So, you may wrap your Jira Issues macro in the Pivot Table macro and count all the issues or create aggregated (pivot) tables like in Excel (count issues by statuses,…

Hi @Thejwal Pavithran, The Table Spreadsheet macro is our macro, and it belongs to the Table Filter and Charts for Confluence app. The macro is indeed stored as an attachment of your page. You may visit the Attachments section and check it yourself: each .tfss attachment corresponds to each Table Spreadsheet macro. You may…

Hi @Ajay.Amrite, I assume that you have smth like this coming from your Table Excerpts: So, you may use the ROWNUM() function in your Table Transformer macro: SELECT ROWNUM() AS 'No', * FROM T* Hope it helps your case.

Hi @[deleted], Not sure that this is exactly what you need but still: we develop the Table Filter and Charts for Confluence app (maybe you already have it installed for your instance) and its macros support the dynamic Jira Issues macro. So, you may wrap the Jira Issues macro in the Pivot Table macro and create complex…

Hi @Vaibhav V, As for now, it is not possible to use Excel features (table calculations, totals’ counting, merging, etc.) in Confluence, you’ll need some additional apps from the Atlassian Marketplace to perform such tasks. We can suggest using the app that we develop – Table Filter and Charts for Confluence. If you prefer…

Hi @Goh, Unfortunately, as we need to group your table by cost (no matter via the Table Transformer or Pivot Table macro), not only the last column will be merged but other columns as well. You'll get a standard Excel-like pivot table as a result.

Hi @Ryan Gagliardi, Indeed, you may use the Page Properties/Page Properties Report macros to collect one-row tables from different pages into one big report on the master page as @Brant Schroeder has mentioned.If you need to collect bigger tables with data, we can suggest using the app that we develop – Table Filter and…

Hi everyone, Please refer to the following additional links that may be helpful for you as well: * Our blog with product announcements and cases from our customers * Our support - don't hesitate to raise a ticket if you are stuck with smth * Answers to the security-related questions * Use cases using advanced SQL queries…

Hi Klaus, You need to download the tfss format file and just import it then via Table Spreadsheet.

Hi @Hannes, As for now, you can’t perform calculations and aggregation in Confluence natively, you’ll need some additional apps for this purpose. For example, we develop the Table Filter and Charts for Confluence app. Its Pivot Table macro and then Chart from Table macro will help you to group and visualize your data if…

Hi @Jessica Luo, Please use the following query: SELECT * FROM T1 WHERE 'STATUS' = "COMPLETE" As you refer to the value (string) and not the column, you should use not ‘COMPLETE’ but "COMPLETE" in your query.

Hi @Rafael Gaudeoso Vilarinho, In addition to my previous answer, please note that you can choose the type of filter yourself in the Table Filter macrobrowser and set the visual filter for the required columns manually (for filters in header as well, I used panel view just for the screenshot). But, of course, it can’t be…

Hi @Scott Gillespie, The original FORMATWIKI function shouldn’t change nulls to empty cells. I mean that if you have “0” in your column, then SQL queries SELECT FORMATWIKI("{cell:textColor=green|align=left|width=200px}", 'Column name', "{cell}") AS 'Column name' FROM T* or SELECT…

Hi @Rafael Gaudeoso Vilarinho, The behavior of the macro is correct. If you have only emoticons (icons) in your cells, then you are presented with a visual filter. Emoticons+text are recognized as strings, so you are given a dropdown filter to use. Seems that the only workaround here may be to use a separate column for…

Hi @Youri Hart, Unfortunately, technical limitations don't allow us to support this case. We've already notified Atlassian about it, and the Scroll PDF vendor that may implement improvement on their side once. 

Hi guys, Please notice that you can export data wrapped with the Table Filter and Charts macros via the standard Confluence Export to PDF option now.

Hello @Chris Hill , Please notice that you can export data wrapped with the Table Filter and Charts macros via the standard Export to PDF option now. Best regards, Katerina