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; } } }

How to display multiple counts base on data from one table?

Leona_y8vkcf

Hi,

I have one big table that I want to display counts of:

Total Number of Rows
Count of records with status "OPEN"
Calculate Percentage of Done

I was able to populate Table A with three macros (see screenshot). But this solution is heavy and takes a long time to load as I have many other macros on the page.

Any lightweight solution to look like Table B? Please note, I do not have TRANSWIKI.

Thank you.

Accepted answers

Srinatha Tondihal

HI @Leona ,

Welcome to Atlassian community.

The below thread has some solution for you. It uses table transformer macro.

Table-Transformer-SQL-query-for-counting-values

Try that.

Thanks,

Srinath T

All comments

Srinatha Tondihal

HI @Leona ,

Welcome to Atlassian community.

The below thread has some solution for you. It uses table transformer macro.

Table-Transformer-SQL-query-for-counting-values

Try that.

Thanks,

Srinath T

Katerina Kovriga {Stiltsoft}

Hi @Leona ,

As @Srinatha Tondihal has kindly mentioned, the similar case can be achieved with one Jira Issues macro and one Table Transformer macro.

Fri 9-1.png

Fri 10-1.png

SELECT *, 'Open'/'All'*100 AS '% of Completion'
FROM (SELECT SUM(IF(T1.'Status' = "To Do", 1, 0)) AS 'Open',
SUM(IF('Status' IN ("To Do", "In Progress", "Done", "Answered"), 1, 0)) AS 'All'
FROM T*)

To get a vertical table instead of the horizontal one go to the "Settings" tab of the Table Transformer macro and check the "Transpose result table" option.

Hope this helps your case.

Leona_y8vkcf

Thank you both for the quick response. The solution works beautifully.

I would use COUNT in the same way as SUM with the IF statement? When then would COUNT be a better solution than SUM? Thanks again.

Katerina Kovriga {Stiltsoft}

Hi @Leona ,

What do you mean by a better solution? I don't think that the change of the function will improve your performance or smth.

By the way you can check all the available functions here.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud