nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

In confluence - how to combine four tables

Rama_9vwicp

I've four tables which are results from two dimensional stats and i would like to combine 4 tables into one.

For example: For each project based on fixversion, i have set of results that needs to be combined in one table. These tables columns and rows are not same. Please find below.

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Rama ,

You may use our Table Filter and Charts for Confluence app and its Table Transformer macro that supports the Two-Dimensional Chart macro.

You may use the standard merge preset:

Wed 2-1.png Wed 2-2.png

The unwanted "Status T:" column and "Total Unique Issues:" rows can be further hidden with the help of the Table Filter macro.

All comments

Jack Brickey

Is this a one time thing? In which case manually doing this would be the right answer. If this is something that you want done automatically then you have to find someway to script it with a third-party add-on application.

Katerina Kovriga {Stiltsoft}

Hi @Rama ,

You may use our Table Filter and Charts for Confluence app and its Table Transformer macro that supports the Two-Dimensional Chart macro.

You may use the standard merge preset:

Wed 2-1.png Wed 2-2.png

The unwanted "Status T:" column and "Total Unique Issues:" rows can be further hidden with the help of the Table Filter macro.

Rama_9vwicp

Thank you @Katerina Kovriga _Stiltsoft_ I did exactly what you described before i started this conversation here. Here is the result table.

I assume this is because of fixversion field which is unique for each project in JIRA?

Katerina Kovriga {Stiltsoft}

Yes, it seems that all the Fix Versions' names are unique so your result table is combined as it is in my example.

If, for example, you think that the "Accepted" status for the first project is the same as the "Ready" status for the second project, then you may use an additional Table Transformer macro for the second Two-Dimensional Chart macro and rename its columns. And then merge your table with the external Table Transformer macro.

But if your statuses are really different then you may leave everything as it is.

Rama_9vwicp

Status are different, can't we convert as standard table from two dimensional macro result and merge?

Do we have any other options that could work in this scenario?

My requirement is quite simple - in a combined view across 4 projects in PI-1 how many issues are covered under each status.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server