Hi everyone, I am new here. I would like to know if it is possible to perform calculations in Confluence tables. For example: Column A = Price Column B = Taxes (%) I would like to automatically c...
Hi there, I would like to do the following and I'm not sure if the approach is even possible. Context: We are managing several Data Definitions in Confluence (1 Data Definition = 1 Confluence Pa...
Hi, I use the table transformer macro in confluence to display Jira tickets. The jira tickets have bilingual content in the decription field. I try to seperate via SQL query by the SPLIT or S...
In the Stiltsoft's Table Transformer macro, one can use the Atlassian Design System colours, as described here: https://docs.stiltsoft.com/tfac/cloud/using-beautiful-colors-from-the-atlassian-de...
Hi Team, Just migrated to Confluence cloud and have been trying to understand the new editor. I have a few tables whose structure look like this: Table toolbox>table filter>table tran...
Hi, I'm working with the 'Jira' macro in Confluence to display a list of Jira issues. I've noticed an issue with the table formatting. The "Assignee" column appears to be excessively wide, ...
Hello, Wondering if anyone can help me with a query. I have created a report by majorly using spreadsheet, Pivot table, Table Transformer macros. My report finally creates a table with some v...
I am creating a report page in Confluence. I want to have a table where I will aggregate different data. I want some cells in the table to show only the total Story Points of the active sprint. ...
Hello folks, I have a RAID log in excel format (attached in the screenshot, top table). Using the raid log I want to fill the values in Risk Matrix table (attached in the screenshot, bottom ta...
Good day everybody, I am currently create a Table of some defects which are read out of JIRA. Now i want to limit the maximum height of the columns to a defined value (like 50px...
Hi, I have one table transformer, which used two table, table1 generated through JIRA and table2 has add manually have two column Key and Comment. I want all the Key from table1 to be replicated on ...
I have a Jira table which shows a list of jiras with jira details in the columns. I need to add another column to the same table to be able to add comments corresponding to the jira. Please tell me h...
Hi everyone, I'm currently working on adapting an existing meeting template in Confluence. While there's already a native Confluence table in use, we’d like to further optimize it - especially in te...
Hello, I have a table of lego parts with their properties (shape, color, size, ...). One of the properties is "Model", which determines to which model the part corresponds (it could correspond to sev...
I want to create a table view of ticket items we are taking in to PI. I can't figure out the correct macro to use but I want to have a confluence page with a 'source table' at the bottom that lists a...
Hi Team, Trying to calculate the balance ticket of each month, the value should be accumulate, but seems the query ( in bold ) not works, can someone please help to check? Thank you. &nb...
Hello, I have a project with Epics with Stories that are linked as "Issues in epic". The summary of the Epics can have an identical names in my project. This turns out as a big problem in Jira, be...
Hi. We're seeing an issue where our confluence reports are failing. We have several reports built using the Page Properties and Page Properties Report and Table Transformer macros.&...
Dear All, In the Confluence, Table Transformer, I'm trying to derive a logic to colour the output cells based on a condition but not successful though: Table: Note: (...
Take care
I'm pulling a Jira table into the table filter and charts macro in Confluence. One of the fields returned contains a comma separated list of url links to a confluence page. Each page has details on ...
I have a table with many rows. A certain column (say, column 3) will be populated with strings. There will only be a certain number of distinct strings -- for the sake of numbers, let's say 7 -- so l...
We had this code in our confluence page on the Table transformer macro Code: SELECT X.'Feature Key' ,X.'Feature Name' ,CONCAT_VIEW_AGGR(FORMATWIKI(X.'Key' + " \n")) as 'Work Key' ,CONCAT_...
I’ve created a survey in Confluence using ConfiForms with radio buttons, allowing users to rate a question on a scale from 1 to 6. I’m using the ConfiForms TableView macro in combination with the Cha...
Dear All, I have a scenario where i need to find the JIRA Tickets having more than one Labels of the same category (not duplicates .. but of same category as explained below) .. i h...
Copied to clipboard