Hi all, My users had a request to take some large tables with checkboxes, and create smaller linked tables where 1 of the checkboxes in the smaller table would link to the 2 or more in the larger ...
I'm familiar with the ability to use the Literal operation in the Pivot Table macro in the Table Toolbox. Is there any equivalent of that literal operation when using the PIVOT function wi...
Hi there: Not even sure how to formulate my question clearly which may be why I can't find any info on it: I have two tables (Page Properties reports actually); for simplicity's sake: Table 1:...
Using Confluence 7.19.6 I am building a dashboard page to combine Jira metrics for completed, incomplete and changed stories from multiple engagement teams. Each team creates a page usin...
I want to move a check lists from spreadsheets in to a confluence page. The checkbox can be used to show if a line/task is complete but I also need to show tasks in groups (sections) and also display...
Are you ready for the most anticipated event of the year? Atlassian Team'23 in Las Vegas is just around the corner, and we couldn't be more excited to attend in person as both sponsor and participant...
Confluence Cloud I have 3 Confluence "sprint performance" tables with data pasted from Jira for sprint stories that are complete, incomplete, or removed, respectively. These are for multiple e...
Hi All, Hoping to get a community help on the following question. I have a macro that pulls the information from different confluence pages into one table on single page. Table has colu...
Hi community, I am figuring out whether I can do some calculation on statistics from JIRA, and show them in the Confluence page as a table. For example, I want to get a weighted score on ov...
Hello, I need to remove duplicates from a table that I created getting issues from jira using the table transformer macro. for example if I have a table like this: colun1 | column2 | colum...
Native Confluence features allow you to customize your table. But if you want to achieve something similar to MS Excel conditional formatting, you can use the Table Transformer macro from the Table F...
Hi, I'd like to create a high-level roadmap view in the form of a table in Confluence where: Each row of the table is a swimlane (I can pull this from a picklist/enum from each issue in Jira) Each...
I have a table of cars where each row represents a separate car and one of the columns will have a date in it to represent when the car is ready. I would like a bar chart to show how many cars ...
I have got a table with 21 entries/rows. If i create a "chart from table" and enter the "title" for the "value columns" I receive currently 21.01, because one row title says "Example 01.01". If i cha...
Hi, I would like to merge 2 tables with the Table Transformer macro, but in the first table (Issues) there are multiple values (names and PIDs) in the Names field that I would like to use to merge i...
When you work with tabular data, sometimes it gets messy. The tables add up on your page, and you need to share and reuse the data, so you make copies you later forget to update. We get you, and we k...
I would like to count first the number of row entries for every date then get the running total. This is for custom transformation in the Table Transformer Macro. Example Data: Date 4/4/20...
Hello All, I have a confluence page, which displays tables of issues form jira. The Jira chart is used to access jira with a jql, and nested in a table transformer. There is a datepicker , which u...
Confluence tables can be a great tool if you work with data in Confluence. But to get the most out of them, you might need to know some tricks. That is why we decided to start a series of posts to sh...
I have 2 table excerpts: T1 - Platform Table generated by a Jira Filter which contains the following fields: Issue Type, Key, Parent Summary, Summary, Feature type, Dev Fix Version, NTL Fix V...
Hello, I have a large table with a "QTY" column and other columns identifying inclusion of the QTY (labeled as "A", "B", and "C" below). I would like to create a "Total" row using the Sumproduct fo...
Hey, everyone! You've probably noticed the PM72 Meet The Speaker series and lots of activity here 🤓 I'm super excited to be a part of PM72 Summit too! Join this 72-hour online event to learn e...
If you use Excel in your daily work, put your Excel spreadsheets on Confluence. Benefits of having an Excel spreadsheet in Confluence You can put notes, procedures, and other explanations of ...
If you're a businessman, you may face the problem of identifying the effectiveness of your subordinates. What does it mean? Let’s determine 2 important features of effectiveness: How much time does...
Hello community, im struggling with a basic operation for counting the amount of values on a given column aiming to get the total value, however the result by using COUNT or SUM return weird d...
Copied to clipboard