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

Unable to get assignee wise cumulative story points in native dashboard

Utsav Kothari

Hi all, I'm working with Jira Cloud and trying to create a dashboard to see assignee-wise cumulative story points in a tabular view. I have tried using Two Dimensional Filter Statistics and Issue Statistics widgets with a filter to show all open issues, but in either of the widgets or any other widgets I'm not getting the option to select Story Points (except for Filter Results widget). I tried searching online and found out that in these widgets there will be an option to select "Value to Display" but I'm not getting that option as well. Since Story Points is a custom field in our project I have also verified that it is used in my project's screens, has type as "Number" & Search Template as "Number Range Searcher".

Please give your inputs as to how I can achieve this output of getting assignee-wise cumulative story points in a tabular view using the native dashboard only.

Accepted answers

Martin Sturm - JXL

Hi @Utsav Kothari

To the best of my knowledge the Issue Statistics and Two Dimensional Filter Statistics gadgets only support counting issues, not summing custom field values. So what you're trying to do isn't possible with native dashboard gadgets alone.

If you're open to solutions from the Atlassian Marketplace, JXL can do exactly this. You'd set up a sheet with your issues, group by Assignee, and add a sum-up on the Story Points column. The result is a collapsible table showing the total story points per person, and you can embed it on a Jira dashboard using the JXL Sheet gadget.

Disclosure: I work for the team that builds JXL.

Best,

Martin

Danut M _StonikByte_

Hi @Utsav Kothari,

Welcome to the Atlassian Community,

Indeed, the Jira’s native gadgets do not support summing up story points. To achieve this, you will need to look for an app on the Atlassian Marketplace that provides this functionality.

If you decide to use an app, I recommend taking a look at the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app.

With this gadget you can easily calculate the sum of story points per assignee and display it as a table, heatmap table or charts of various types.

To get a table like this, you have to configure the gadget like in this example:

Hope this helps.

Danut.

All comments

Martin Sturm - JXL

Hi @Utsav Kothari

Disclosure: I work for the team that builds JXL.

Best,

Martin

Utsav Kothari

Thanks @Martin Sturm - JXL . Due to budgetary constraints on the project I’m currently working on, we’re unable to onboard a Marketplace app at this time. That said, I appreciate your guidance and recommendations on this topic.

Danut M _StonikByte_

Hi @Utsav Kothari,

Welcome to the Atlassian Community,

Indeed, the Jira’s native gadgets do not support summing up story points. To achieve this, you will need to look for an app on the Atlassian Marketplace that provides this functionality.

If you decide to use an app, I recommend taking a look at the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app.

With this gadget you can easily calculate the sum of story points per assignee and display it as a table, heatmap table or charts of various types.

To get a table like this, you have to configure the gadget like in this example:

Hope this helps.

Danut.

Marlene Kegel - codefortynine

Welcome to the community, @Utsav Kothari.

I am Marlene and I work on the team that develops Quick Filters for Jira Dashboards.

What you describe can be done with most of the Quick gadgets of our Marketplace app, since they are able to aggregate any Jira number field, including story points.

For your use case I recommend the Quick Work Item Statistics gadget.

quick-filters-jira-dashboards_issue-statistics_assignee.png

Other Quick Filter for Jira Dashboards gadgets that can aggregate number fields are:

- Quick Two Dimensional Filter Statistics

- Quick Pie Chart

- Quick Bar Chart

- Quick Time Series

- Quick Created vs Resolved

Alina Chyzh_Grandia Solutions

Hi, @Utsav Kothari

The native Jira widgets have limitations when displaying custom field statistics, which is why you're not seeing Story Points as an option in the Two Dimensional Filter Statistics widget. For a native approach, the Filter Results widget can show Story Points but won't aggregate them by assignee in the way you need.

Since you need assignee-wise cumulative story points in a tabular view, if you consider Marketplace apps, Report Hub would be an ideal solution for this requirement. I work for the company that built it, and it's designed specifically to create custom tabular reports with aggregated values from custom fields like Story Points grouped by any field including assignee. You can find it here: https://bit.ly/4cbZyIZ

Rahul_RVS

Hi @Utsav Kothari

Welcome to the community !!

If you would be interested in a mktplace app, I can suggest

Dashboard Charts for Jira

The app allows you to build interactive Jira dashboards with powerful charts, gadgets, and reports. Visualize issue progress, team workload etc

There are multiple configuration and customization options which the apps provides. You can easily get the story points / time spent for each assignee and many other data points .Some of the sample charts are as below.

Chart Config.png

Disclaimer : I am part of the team which developed this app

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud