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

Pulling a chart based off story points from Jira

BJ Thompson

I'm working in Confluence and looking to create a chart based on story points instead of on the number of issues.

Example: I've seen multiple examples of a pie chart based on the number of issues split out by Department (Department is an internal field we use), but I can't seem to find an easy way to get that same data in a pie chart based off the number of story points.

any ideas?

Accepted answers

Ste Wright

Hi @BJ Thompson

Can I confirm a few things?

At present, do you have multiple Pie Charts for the Department/Number of Issues - one per Department? Or one Pie Chart that shows issues per Department?
Are you looking for a Pie Chart that would show total Story points per Department?

---

Just to be clear, I'm pretty sure summarising a number field in this manner is not possible natively - you'd need an App to get this type of functionality.

You could try Apps such as:

Or, look for another App from the Marketplace

Ste

All comments

Ste Wright

Hi @BJ Thompson

Can I confirm a few things?

At present, do you have multiple Pie Charts for the Department/Number of Issues - one per Department? Or one Pie Chart that shows issues per Department?
Are you looking for a Pie Chart that would show total Story points per Department?

---

Just to be clear, I'm pretty sure summarising a number field in this manner is not possible natively - you'd need an App to get this type of functionality.

You could try Apps such as:

Or, look for another App from the Marketplace

Ste

BJ Thompson

@Ste Wright

I'm looking for one Pie chart that shows issues per department for the past sprint broken down by number of story points completed.

We just recently switched over to Jira, and in the past as well as right now, I do this manually in excel by updating the most recent sprints data creating 3 different pie charts, one for the most recent sprint, one for the aggregate of the past 4 sprints, and one for all time. Gives a good trend to the PO allowing them to better prioritize what tickets to work on next by understanding if they have been putting more effort towards one department rather than another in the past. I'm hoping to find a way to automate this.

I'm guessing you are right and it needs an app, but wanted to at least reach out and ask to see if I missed anything. Thanks for the list of Apps. I'll take a look at those.

Ste Wright

Hi @BJ Thompson

I think the summarisation of Story Points is what is key here.

The Pie Chart doesn't just show Issues per Department (which is simple), it shows Issues Per Department AND Story Points per Department (eg. 2+1+3+5 = 11).

For this type of metric in Confluence, you'll need an App I believe.

Ste

BJ Thompson

Ste, Just following up, helpful to know that not possible directly in Jira.

FYI I did eventually find a workaround. I used Jira Cloud for Google Sheets (Official)

The key being it's free, didn't want to pay for a 3rd party app. I then used google sheets, formulas, and their charts to automate the charts I was looking for.

Took a bit of setup, but seems to be working well for me now.

Thanks,

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