I have a page with an extensive table in which I am attempting to resize columns of to fit better on the screen. I have changed the table to fixed width but am only able to resize a single column w...
Hi, I am able to split based on ";" in Table Transformer. I am unable to split based on new line. Please help. I tried "\n", "\n\r", "\r\n", CHAR(10), CHAR(1...
I want to include only distinct teams in the current query which aggregates the teams CONCAT_VIEW_AGGR(FORMATWIKI(T1.'Team', " \n")) AS 'Teams', --- The formatting is...
...hore than a solution? That’s where Elements Project Table comes to the rescue. It’s not just a tool; it’s your ultimate sidekick for turning chaotic data into organized, actionable insights. H...
Hi, We do a evaluation every other month for 3 processes which have different criterias. Every other month I create a table excerpt like the one shown below from a table spreadsheet, so for Oct, i...
I have a SQL table transformer having different values. Some values are left aligned and some are right aligned. I want that all values to be right aligned. What could be the code in S...
Hello all, Has anyone had luck using the chart macro with a jira filter and specific columns in the table to make a chart out of it? Specifically utilizing group bys. Thanks
Hi. I'm running into an issue with the MATCH_REGEXP function in a Confluence Table Toolbox SQL statement. Here's the use case. I have Confluence table in Confluence with a c...
Is it possible to rotate elements or text in Confluence Cloud? I'm getting lost in documentation, including Google.
Hi, If I have a table which has the following format: Date Status 01/01/2024 Pass 02/01/2024 Fail 30/01/2024 Fail How do I transform it so I can calculate a cumulative count a...
Good morning everybody, I am working with a large table, and I would like to use filters. Most of instructions online point to /table toolbox macro but It is not available as an option and support f...
Hi Team, I have a a data source from jql wrapped in a table transformer macro. One of the columns (or fields, in my jira source), let's call it ABC. This column has numerical data and I want to c...
Hi all, I have a Jira filter macro nested in a Table Transformer (to transpose it) nested in a Page Properties macro - in my child page. When I look at my parent page, the Page Properties R...
I have a confluence page which shows the status of about 56 projects (Backlog, Blocked, In Progress, Done). On a project summary page, which is on a separate confluence page, I want to provide the st...
...n tables in Confluence, on the other hand, everyone working in Confluence can view and edit the data related to the project in real-time. They’ll know it’s the same version and there’s no need to be c...
At some point over the past week, something on Jira has changed to where tables in comments are no longer displaying correctly. The column widths are huge, and there is no way to resize them; they s...
I’m using the below SQL in a Table transformer Macro to group epic information (in table 1) and subtasks information (in table 2 - an epic might have more than one subtask). Note: Table...
When managing workflows in Jira, visualizing data is key to uncovering actionable insights. One of the most effective ways to do this is through Column Charts. These charts are not just visually appe...
Hello, I would like to know if exist a way in table transformer (through SQL) to make a kind of sum of colors when the persons are coloring the table with the option of confluence (not by table t...
I have a use case where I am using multiple table excerpt includes wrapped in a table transformer that joins all results with a key field. My problem appears when some of the table...
I have a use case where I am using multiple table excerpt includes wrapped in a table transformer that joins all results with a key field. My problem appears when some of the tables are empty (w...
We use the Jira Legacy macro in our release notes, however we can't control the column width of this macro, which is really frustrating. If we use the Jira Issues macro, we can adjust columns,...
Hi, Is there a way to achieve the following please... I have an excel tracker, I need to retain it in Excel for the formula, formatting, functionality built in that comes with Excel, but I would rea...
We are using the table transform to join two tables together and then using the FORMATWIKI function to identify all issues that have been updated in the last 3 days and coloring the text to easily i...
Hello everyone! I recently discovered the "Database" macro in Confluence, and I really like it! However, I’m running into one small issue: Initially, I misunderstood the "+" button under "Edit view...
Copied to clipboard