Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Set All Column Data to 100%

Sophia Kroening April 1, 2024

Confluence Data Center

I am trying to create an automated chart from Jira Xray data that looks like this: 

image.png 

 

Each feature (represented by a row) has different numbers of test cases. Example data:

image.png

I need each row to be 100% with each status comprising some amount that equals 100%

I have been using Table Filter, Table Transformer, & Pivot Tables to try and accomplish this with no luck so reaching out for help from the community.

1 answer

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 2, 2024

Hi @Sophia Kroening ,

You may use the following structure:

Tue 6-1.png

SELECT 'Feature',
'OK'*100/'Total' AS 'OK %',
'NOK'*100/'Total' AS 'NOK %',
'Blocked'*100/'Total' AS 'Blocked %',
'Not Tested'*100/'Total' AS 'Not Tested %'
FROM T*

Tue 6-2.png

Tue 6-3.png

Hope it helps your case.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events