Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hi @Audra Bonacki, As Fabio Racobaldo _Herzum_ has kindly mentioned, the issue is not related to the type of your license. Only new Server trials and purchases are no longer available, otherwise everything should be working just fine. Please check the app on the Marketplace yourself. Maybe smth was done with the database…

Hi @yeeunhong, It is not possible to perform table calculations natively, you’ll need to install additional apps from the Atlassian Marketplace. For example, our company develops the Table Filter and Charts for Confluence app. You’ll be able to calculate data based on manually created Confluence tables and dynamic tabular…

Yes, you are right - don't forget to list your columns after the GROUP BY function: SELECT 'Sprint', 'New column 1', 'New column 2', 'Start date', 'End date', FORMATWIKI(SUM('Count' + " " + 'Country' + "\n")) AS 'Holidays' FROM ( SELECT T1.*, T2.'Country', COUNT(T2.'Country') AS 'Count' FROM T1 LEFT JOIN T2 ON T2.'Holiday'…

Hi @Shantharam, If you have the Table Filter and Charts for Confluence app (that is our add-on) installed for your instance, you may use its Table Transformer macro and the FORMATWIKI function for the case. Please check this part of our documentation (navigate to the “Conditional formatting” section). The Table Transformer…

Hi @Thomas Niederholz, If you have the Table Filter and Charts for Confluence app (that is our add-on) installed for your instance, its Table Filter macro provides the opportunity to Freeze first N rows/columns.

Hi @Scott Gillespie, We can suggest trying the following SQL query within the Table Transformer macro: SELECT *, (SELECT COUNT(*) FROM T2 WHERE T2.'Holiday' >= T1.'Start date' AND T2.'Holiday' <= T1.'End date') AS 'Number of Holidays' FROM T1 The date format for our example is set as “dd M yy”: And here is the second more…

Hi @Jim Solomon, The PIVOT function inside the Table Transformer macro doesn’t recognize the LITERAL option but you may use the GROUP BY function instead. Please see an example below: SELECT 'Person', FORMATWIKI(SUM('Activity' + "\n")) AS 'Activity', FORMATWIKI(SUM('Value'::string + "\n")) AS 'Value' FROM T1 GROUP BY…

Hi @Jitendra Shembekar, Please follow these steps: SELECT *, ROUND('Closed so far'*100/'Total problems', 0) + "%" AS 'Percent' FROM (SELECT 'Total problems'->split(" ")->0 AS 'Total problems', 'Closed so far'->split(" ")->0 AS 'Closed so far' FROM T*) Note that here the result table was transposed for better understanding…

Hi @Goh, In general, you may try the following SQL query to group your data: SELECT FORMATWIKI(SUM('Member' + "\n")) AS 'Member', 'Cost' FROM T* GROUP BY 'Cost' But I really can’t see how it will get along with your case. As I understand, you join all the three tables into one table, so all “members” should be in separate…

Hi @Shikha Saka, Please try to use commas instead of pluses for your SQL query - it may help to preserve initial cells' formatting.For me the original query somehow works fine regarding your example link, the underscores remained as they were.

Hi @Artur, You may also try our Table Filter and Charts for Confluence app and its Table Spreadsheet macro. You’ll be able to import your existing file in .xlsx and .csv formats and continue to work with it right in Confluence (using cell formulas, conditional formatting, pivot tables, charts, etc.). Maybe you are…

Hi @Scott Gillespie, Our macros understand the checked and empty checkboxes, please see the screenshots below related to the Table Filter macro: What concerns the Table Transformer macro, please refer to the cells with checkboxes as “Completed” and “Incomplete” for your CASE WHEN queries. I mean something like this: ……

Hi @Claudia Dufour, If it happens so that you have our Table Filter and Charts for Confluence app installed, you may use our new macro – Table Spreadsheet Include. The first step is to import your existing Excel file to the Table Spreadsheet macro or insert a new Table Spreadsheet macro and add your data, cells’ formulas,…

Hi @Charfi Ouacef, Please try the following SQL query for the case: SELECT FORMATWIKI(SUM('male' + "\n")) AS 'male', FORMATWIKI(SUM(DISTINCT('beard') + "\n")) AS 'beard', FORMATWIKI(SUM(DISTINCT('shoe size') + "\n")) AS 'shoe size' FROM (SELECT * FROM T1 OUTER JOIN T2 ON T1.'male' = T2.'male') Seems it can help your case.

Hi @Ajay Shenoy, It is possible to do if you have a manually created reference table with Name <-> ID. Please check this Community thread with a similar question.

Hi @lthln, Seems that the original case is a bit complex for the Table Transformer macro. It is possible to filter your first table using your second table as a variable. But the second table should contain only this variable (header for variable name and one row for variable itself). Please check this Community thread for…

Hi @Defne Alpdogan, You can find the list of the formulas that are supported by the Table Spreadsheet macro here. Seems that the functions that you’ve listed are valid, so please let’s move to our support portal (it’s confidential). Please export your problem spreadsheet in the .tfss format and attach it to the ticket.…

Hi, We can suggest the following workaround if you need to present some part of your data that is stored inside the Table Spreadsheet macro: use the Table Spreadsheet Include macro. The Table Spreadsheet Include macro allows you to choose the source page, source spreadsheet, source sheet within this spreadsheet and to…

Hi @NORBERTUS WUSANA, We can also suggest trying our Table Filter and Charts for Confluence app. Its Table Filter or Table Transformer macros will do the trick. Besides, you may also use the Table Spreadsheet macro to get the Excel-like functionality (cell formulas, conditional formatting, etc.) right in Confluence. The…

Hi @Evy Ballu, I've checked the data verification for a dropdown-list option for Confluence Cloud and Confluence Server/Data Center (app's version 9.8.3). After I saved the changes and reloaded the page I still see the data in my column. When I go to these cells, I see the dropdown check and the list with available…

Hi @[deleted], Our company develops the Table Filter and Charts for Confluence app that enhances user experience with tabular data, statistics, and analytics within Confluence. So, we often publish articles and videos regarding best practices for project management, planning, analysis, etc. using native Confluence features…

Hi @Evy Ballu, As @Juliette Lallement _Elements Apps_ has already asked, please clarify what app/macro you use for the case. For example, our Table Filter and Charts for Confluence app also provides the Table Spreadsheet macro – is this it? Then the last entry seems confusing: the file is always visible on the page, you…

Hi @Alyssa Hill, If you have our Table Filter and Charts for Confluence app installed for your instance, you may use its Table Transformer macro as a workaround. The idea is described into the second part of this Community thread – please find the Jira Issues macro on the screenshot and take a look.

Hi @Neumann Bernd, Please take a look on the screenshots below. Here is our test table wrapped in the Table Filter macro: Now we set a dropdown value, choose the delimiter (comma for our case) and choose the “AND” option: As a result, we have only one entry where both “A” and “B” options are present. Now we choose the “OR”…

Hi @Elliot Campbell, The new Cloud editor doesn’t allow such nesting. So, you may browse the Atlassian Marketplace and search for apps that will enhance your experience with big tables and loads of data. For example, our company develops the Table Filter and Charts for Confluence app. You may use its Table Filter macro to…

Hi @Vijay anand R, If you have the Table Filter and Charts for Confluence app (the add-on is developed by our company) installed for your instance, you may use the Table Transformer macro and the ROUND() SQL function for the case. For example, your SQL query may look like this: SELECT *, ROUND('Column A', 2) AS 'Column A'…

Hi @Ольга Ч, We can suggest trying our Table Filter and Charts for Confluence app (it’s free for Cloud 1-10 users). You’ll be able to upload your existing Excel file via our Table Spreadsheet macro and continue to work with your data using all the basic Excel-like features right in Confluence (cell formulas, conditional…

Hi @David Cuozzo, If you have the Table Filter and Charts for Confluence app (the add-on is developed by our company) installed for your instance, you may try to play with the Table Transformer macro – it will simplify your manual work. SELECT "Project A" AS 'Project Name', 'Status' FROM T* WHERE 'Status' LIKE "%JEOPARDY%"…

Hi @Moya Alhayek, @Fabio Racobaldo _Catworkx_ has kindly mentioned our Table Filter and Charts for Confluence app regarding your case, so let me clarify some points. If we are talking about native Confluence tables, the Table Excerpt/Table Excerpt Include macros can collect multiple-row tables with similar headers into one…

Hi @Krishna Chaitanya, As you’ve mentioned Gantt charts and filter, I assumed that you use our Table Filter and Charts for Confluence app. If this is the case, I can suggest the following workaround: reuse your source table with the help of the Table Excerpt/Table Excerpt Include macros and use the Table Filter and Chart…