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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,555,368
Community Members
 
Community Events
184
Community Groups

Weighted Jira Statistics

Edited
Kevin Lin
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Mar 25, 2023

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 overall status.

Open*0, In-progress*5, Done*10

So if there is 5 open tickets, 2 in-progress ticket, and 1 done tickets.

I should get a table that shows the number of each kind of tickets, and the overall score 20, like below.

Screenshot from 2023-03-25 17-32-12.png

Please help providing a method to accomplish so.

Thanks you.

2 answers

3 votes
Katerina Rudkovskaya _Stiltsoft_
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.
Mar 27, 2023

Hi @Kevin Lin,

You may look into the following standard Confluence macros to show info from Jira on Confluence pages:

Jira Chart – Two Dimensional Chart (creates an aggregated tabular view of your Jira issues, not very flexible).

Jira Issues (creates a non-aggregated tabular view of your Jira Issues: each row relates to a specific issue, you can also choose what fields you want to pull from Jira yourself).

The latter macro can be aggregated as you need with the help of the Table Filter and Charts for Confluence app (this is our add-on and it supports dynamic Confluence macros). Please check our Pivot Table macro – it may help your case.

And here you may find several examples of the dashboards in Confluence created with the help of the Jira Issues macro and our app.

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Mar 27, 2023

One way to do this:

  1. Export to Excel with this app
  2. Add the formula in Excel
  3. Attach the Excel file to a Confluence page and display it with the corresponding macro

You can even create a custom Excel template that will save step 2 and produce the Excel file with the pre-calculated statistics.

For example, here is a template calculates "created" and "resolved" over time by aggregating them by year, month and day:

jira-created-vs-resolved-pivot-table.png

(Discl. this is a paid and supported app that we develop.)

Suggest an answer

Log in or Sign up to answer