Katerina Kovriga {Stiltsoft} Expert

Hi @MOh G , I'm sorry, I'm out of the office for the next two weeks. Please raise a support ticket for the case.

Please raise a support ticket. As you have Server/Data Center, attach the page storage format (upper right corner - menu ... - View Storage Format). If you don't see the option, ask your Confluence administrator to do it for you. Then we'll be able to recreate your macros, their settings and queries. The Jira Issues macro…

Or you are on Server/Data Center and trying to find the Table Toolbox macro? I've mentioned in the beginning of the answer that for Server/Data Center you place your source table inside the Table Transformer and then wrap your Table Transformer macro into the Table Filter macro directly on the page. If you check the…

In the original question you've mentioned the Table Transformer twice - this is one of the macros provided with the Table Filter and Charts for Confluence app (along with Table Filter, Pivot Table, Chart from Table macros and many more). Maybe I didn't get the question then and you mean smth else.

Hi @Anders Johnsgaard , We can suggest using the following workaround to convert different dates to the Jira format with the help of the Table Transformer macro: Set the Date Format as "dd.mm.yy": And use the following SQL query: SELECT T1.'Date' AS 'Original Date', T1.'Date'::Date->toLocaleDateString("en-us", {…

Hi @nppani You may use the following solution (the screenshots were taken for Cloud, so I use the Table Toolbox macro to nest macros, for Server/Data Center you may wrap them directly): SELECT T1.'Col A', CASE WHEN T1.'Col A' LIKE "USA" THEN T1.'Col B' + T1.'Col C' END AS 'USA Total', CASE WHEN T1.'Col A' LIKE "China" THEN…

I've seen your ticket - yesterday I misunderstood you. You mean that if you add columns, the new AA columns are added. If you delete them, you want not only the contents to be deleted but the number of columns as well: back to Z, Y, etc. We don't have such behaviour at the moment, so Nikita created a ticket for our…

Hi @Holly Perry , It may be a little tricky to achieve with the Table Transformer macro, but here is the solution that our developers have come up with: SELECT TT1.*, TT2.'Week' AS 'Previous week', ((TT1.'Overall'-TT2.'Overall')/TT2.'Overall')*100 AS 'Percentage from Original, %' FROM T1 AS TT1 LEFT JOIN T1 AS TT2 ON…

Hi @David Rohm , The article kindly provided by @Srinatha Tondihal mentions our Table Filter and Charts for Confluence app. The add-on provides a bunch of macros to implement all the basic Excel features right in Confluence. We'll be happy to organize a live demo for you and your team - please book a suitable time slot…

Your screenshot looks like a plain Jira Issues macro - check the first link given by @Melo. Insert the macro, choose the required Jira instance connected to your Confluence and type in a JQL query to get the issues.

Hi @Katie Calabrese , I don't think that anything has changed yet.

Hi @Qwert Zuipü , Just checked the behavior in our test Server instance: I can delete both columns and rows from the edit and view modes. Right-click the mouse, select Delete selected Row/Column and it works fine for me. Note that after doing any changes in the page view mode you need to save them: File -> Save/Save As. If…

Hi @Christian Feise , I see that you want to accomplish the case without an add-on, but still I can suggest trying our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. The macros serve as an advanced version of the Page Properties Report macro and allow you to collect…

Hi @bruce_white , The Table Filter and Charts for Confluence app kindly mentioned by @Melo is our add-on. It supports the Jira Issues macro and allows you to create Jira dashboards right in Confluence. The screenshots were taken for Server/Data Center where you can wrap macros directly one into another. As you have Cloud,…

Hi @يحيى حسين , The Table Filter and Charts for Confluence app that provides the Table Filter macro is our add-on. @Pramodh M has kindly mentioned all the steps you need to take to make sure that the app is installed for your instance: * Ask your Confluence administrator. * Browse for other macros that are also provided by…

Hi @Nicole Griffin , The original request was to create a pivot table based on text values and only then to create a chart. The first part is not possible natively. To create a chart, you may use the standard Chart macro.

It's a string of words - you are right. And the words are counted by separators (spaces, commas, etc.). I mean even not considering SQL, but in general (for Python, for example) if you have a sentence and need to count its words, you will look for the spaces. Otherwise you don't know where the new word begins and ends as…

One more idea from me regarding the second question: maybe the FORMATWIKI function failed to set green status for the empty aggrerated cell with statuses because it is really empty? Like when you don't have any status and just leave the cell blank in the source table (don't use "-" or smth). The workaround may be to insert…

Hi, You may use the Table Filter macro for the first case. Set the Free Text filter for the PR# column and filter for the "PR" or whatever project name you need on the fly. And in the SQL queries of the Table Transformers we used the "WHERE 'PR#' IS NOT NULL" condition. You may change it to WHERE 'PR#' IS LIKE "PR%" to…

The "," may be confusing if there is only one vote or your vote is the last: | @katerinakovriga, | | @katerinakovriga, @johhnsmith, | Commas indeed are mostly used like separators, but here it's better to use something that equals the number of user names. From our experience, variants like "plus one ..." | +…

Hi @Brad Johnson , So here is a possible solution for the case: SELECT *, LENGTH('Votes (Name)') - LENGTH(REPLACE('Votes (Name)', "!", "")) AS 'Votes (Count)' FROM (SELECT *, CASE WHEN 'Votes (Name)' IS NULL THEN "No votes" ELSE 'Votes (Name)' END AS 'Votes (Name)' FROM T1) I'm gonna try to describe what I have done here…

Thank you, I'll return here shortly.

And there will be no the "Votes (Count)" column in the result table? This column was shown in the original one-row table. If no and you want to count names in the cells, what element is supposed to be between them? The space? As I see the case, it will be much easier to use the Table Excerpt/Table Excerpt Include macros.…

If you have the examples of real source tables with data for the Page Properties Report macro (with headers that we'll be able to use inside the SQL query), raise a support ticket - attach the screenshots for our agents to recreate similar tables and guide you through the process. If you prefer manually created tables with…

Hi @Norbert Murzsa , We can suggest trying our Table Filter and Charts for Confluence app. You can build a combined report from several multiple-row tables on other pages using the Table Excerpt/Table Excerpt Include macros. The result table can be searched (filtered) with the help of the Table Filter macro. To keep the…

Hi @Brad Johnson , If you need help with the Table Transformer macro (or maybe the Pivot Table macro will suit you), you may give us a manually created table with dummy data that looks like the Page Properties Report macro that you will get for the real use case. Then you may provide us with the desired output (to count…

Hi @Pavel , We can suggest using our app - Table Filter and Charts for Confluence. The add-on supports the Jira Issues macro, so you'll be able to aggregate and calculate data using our Pivot Table and Table Transformer macros. And here you may check several examples of the dashboards based on the Jira Issues macro and our…

Hi @Jes Holden , The macro works correctly: if you set a dropdown filter, then the whole contents of a cell becomes its possible option. As you have a list of labels inside one cell (not one label per cell), the whole list is an option. If you want to search by single labels, you need to set a free text filter for this…

We can suggest using Stacked Bar graph and you may have the number of pages (or percentage) on the bar's sections: Unfortunately, it is not possible to reproduce your exact screenshot with the help of our app.

Hi @Anisha R , You may also search for some 3rd party apps on the Atlassian Marketplace. For example, we can suggest trying our Table Filter and Charts for Confluence app (available for Cloud and Server/Data Center). You'll be able to aggregate and visualize data coming from the Jira Issues macro and create live Jira…