Unable to get the Total number of defects per story point

[kavyapm]

I have two custom columns “story point” and “Defects count” as below.I need a filter which will sum up the Defect count per story point.

Story point	Defect Count
5	2
8	3
5	4
8	5

Expected Output:

Story Point	Defect Count
5	6
8	8

Could you help on how to achieve this?

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @kavyapm ,

You can try the Table Filter and Charts for Confluence app.

Wrap your table (or an output of your Jira Issues macro) in the Pivot Table macro and create the required pivot (works similar to Excel):

[kavyapm]

Thank you. Can we show this in Jira dashboard?

[Katerina Kovriga _Stiltsoft_]

The app is for Confluence, not for Jira - you can create visualized Jira dashboards in Confluence with its help but not vice versa.

[kavyapm]

Thank you so much. I am able to get the chart prepared with this plug in.This Plugin is free only for 1 month. Please let me know If same thing can be achieved in Jira

[Katerina Kovriga _Stiltsoft_]

Sorry, we work with Confluence - try to browse Atlassian Marketplace and find something free for Jira, as far as I know, there are no such feature out-of-the-box.