Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×Hi, I am using the pivot table macro to create a report like table. In my table, I aggregate the values with count and the column title for that in the pivot table says "Count". Another column...
Hi all, I have two PageList Tables with Labels and I want to merge them: One table pages as Columns, the other as rows And mark the fields with an "X"where the labels from one table are the...
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
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...
I have status (Red/Amber/Green) and phase(Initialization/Planning/Execution/Closure) in my status report page for each projects. Ask is, I have to convert the projects with different status in a sepa...
We currently use Data Center, and get a lot of value from applying the Table macros (Table Filter, Table Transformer, Pivot Table, etc.) to Requirement Yogi data from RY Report macros. On the ...
I'm using a pivot table, which works nicely to get me the data I need. But I don't like the grey look, and want to change the formatting of the table. I've wrapped the pivot table in a Table Transfo...
I need to create a weekly project status confluence report wherein there will be approx 15-20 projects tobe included. All these projects will be created in Jira as well which will used for tes...
Hi there! I am in the process of migrating my team from Excel to JIRA/Confluence for our 2025 roadmap. We have a custom JIRA field for all of our projects, which are defined at the Story level. For h...
I created a project template page for my team with specific attributes that are used in page properties and a page-properties report. I would like to use similar macro - if it exists - to automatica...
Hello Confluencers ;) I am trying to find a way to automate the counting of specific string values from a table. Based on that count, I want to generate a new table to display the number of oc...
I am trying to create a pivot table on a confluence page through the REST API. Basicly I have to peridically update a page on my confluence space with some data oganized as a table. Currently I can u...
Is there a way to use a column in the Pivot table but hide just that column from the results of the table transformer macro? Here are additional details: I am joining Jira results with a calculated...
Fellows! Salma is here from a Platinum Marketplace Partner. This time, I’m speaking to Confluence users who play with data in their day-to-day tasks. You’ll thank me later! I mean “us”. To mak...
I am trying to reorder a Pivot in Confluence which is from a Filter in Jira. Pivot looks good but I'd like the column order to be defined by the Status column: Backlog, Analysing, Ready ...
I'd like to add below jira table to confluence page. Anybody know how to implement that add one more row at the bottom to compute the "Passed" rate? Thanks! Currently, I only got pivot table /...
Hi, i want to use several pivot table to build a summary table in another page of conflucence. Is it possible to link table from a page to another? Sorry, i am now starting to us...
Not able to use table filter macro and pivot table together in confluence cloud
Hi guys! Here is the Table Filter, Charts & Spreadsheets for Confluence team with the updates regarding our discussion from last week. Unfortunately, we weren't successful in engaging...
We currently have a confluence page for reporting project status - which is essentially a table which lists the project name/ manager and then a RAG status (using the status gadget) for project healt...
I'm using a pivot table and want to simply round the data from a calculated column, to the nearest integer, no decimal places. Here is the configuration of the pivot table. It doesn't seem ...
Hi, i need a pivot table created with a running total. Eg: source table: Quarter AM GF GWM Q1 2023 1 3 Q2 2023 2 Q3 2023 &n...
Example of what table 1 will look like: I want to pull data from Table 1 and regroup them accordingly to Table 2 so i was working my way through. Firstly, I want to pull all data from Table 1 in...
Ignoring the chaos of our data thats lead me here, I am trying to find a way to combine all values in a row from specific columns into a new colum. In the below picture the red columns are really th...
When I create a pie chart or table using a field with multiple select or one that can contain multiple values (like labels, components, etc), Chart from Table treats these as a single value rather th...
Copied to clipboard