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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Report for done story points

Hi, we use kanban board. Each card mandatory has story points fields.

I would like to create daily/weekly report

I want to group all issues in status "done"/"released" by assignee and sum issues story points.

That would show me how many story points each assignee get during each day and each week.

 

Where should I start?

3 answers

Craft a JQL for your desired data, Export them to an Excel file then compute the total Story Points from there.

Hi, thanks for your reply. I would like to have it inside jira...Like other reports

You will have to find add-ons for that (try the JIRA Misc Custom Fields or SumUp) or the Scriptrunner's aggregate function.

Hi Sergey,

Please take a look at eazyBI report creation add-on for JIRA. With eazyBI you can create custom reports based on JIRA data.

Here is an example timeline report that shows total of Story Points for resolved issues grouped by issue resolution week and Assignee. If you click on Time dimension on rows and select All Hierarchy level members, you can change that measures are displayed per Day or Month or other Time frame. 

Let me know if you have any questions regarding eazyBI!

Kind regards,
Lauma / support@eazybi.com 

HI Lauma! This is great. Using eazy bi with JIRA for a "story points per assignee report". Are we only able to see 'resolved' story points per assignee or can we also see 'in progress' story points per assignee? Also is there a way to then export the report to google sheets?

Hi James, I am happy to hear that eazyBI is helping you to get to reports you are looking for! There is also a 'Story points due' measure in Measures dimension. When selected, this measure shows total story points for the unresolved issues grouped on Timeline by their due date. Would this be what you are looking for? For now it is only possible to export reports to excel (and some other formats), but not to Google sheets directly. When exported to excel you can upload the sheet to Google spreadsheet. Please let me know if you have further questions regarding this! Kind regards, Lauma / support@eazybi.com

I'm looking for almost the exact thing but the linked example timeline report isn't working anymore. Could you update the link?

Hi @Achim Sperling!

I updated the link. Here it is the new link as well: https://eazybi.com/accounts/1000/cubes/Issues/reports/149997-story-points-resolved-by-assignee. 

Let me know if there is anything else I can assist you with!

Lauma / support@eazybi.com

Hi @Lauma, I am also trying to sort out a similar such report. The problem is, the assignee changes throughout the lifecycle of the ticket, as dev works on it first, followed by QA, so I can't pull it on who the assignee was when the issue/story is completed. In Jira I wrote a JQL to see who the assignee was when the story transitions from one status to another (In Dev to Ready for QA), for closed stories within a certain time period or sprint.

We have EazyBI, and I'm wondering if there is any way to create a custom calculated member or something to that effect that would pull story points for resolved tickets, giving the credit to whomever the assignee was during a certain ticket transition?

Thanks.

eazyBI historical measures would reference to the assignee at the moment when an issue was moved to a particular status. If you would like to combine historical activity with a current status you can create a calculation at issue level and use different criteria both current and historical for counting data.

Here is an example formula for counting issues for Assignees at the time when an issue was moved to status In Development:

NonZero(SUM(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
-- for selected sprint it will validate if this is the last sprint
IIF([Sprint].CurrentMember.Level.Name = "Sprint",
[Sprint].CurrentMember.Name = [Measures].[Issue Sprint],1)
AND
-- for resolved issues only
not isEmpty([Measures].[Issue resolution date])
AND
-- check if selected Assignee was the one when issue was moved to In Progress
([Measures].[Transitions to status],
[Transition Status].[In Progress],
[Sprint].DefaultMember,
[Time].CurrentHierarchy.DefaultMember) > 0),
[Measures].[Issue Story Points]
))

 

Daina / support@eazybi.com

understanding that this is 5 years late...

 

There is no need for any add-ons or JQL queries. IF you go into the reports tab and click into Sprint Reports you will see the total number of story points that are completed in that sprint.

Yes and this is helpful, but what is needed is to see a breakdown of total completed story points by the assignee. I still can't find a way to do this.

Why cant you just use the advanced search option > Filter Status "Done" > Filter Assignee - is that not what you are looking for?

@jposluns , this is quite useful as i'm trying to find a solution within JIRA itself. Could you please supply a screen shot of how you are using the Sprint Reports function to capture story points reporting? when I go into my Sprint reporting, there's a bunch of reporting widgets to choose from but none show story points. thanks much

@Ryan Li It's one of the default reports. Sprint Report. (pictured). What's missing is the Assignee, though. 

Like Ryan Li likes this
Walaa I'm New Here Mar 04, 2021

Hi @jposluns @JonathonBarton

what if I'm using KAnban Board without sprint and need to see issue progress based on Story points? is it possible with Jira built in reports?

thank you

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you