Report for done story points

[Sergey Sheypak]

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?

[jposluns]

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.

[Tara L Conklin]

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.

[jposluns]

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

[Ryan Li]

@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

[JonathonBarton]

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

[Walaa]

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

[Lauma Cīrule]

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 

[James Smolich]

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?

[Lauma Cīrule]

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

[Achim Sperling]

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

[Lauma Cīrule]

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

[Achim Sperling]

Thanks!

[Turan Yildirok]

Hi @Lauma Cīrule, 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.

[Daina Tupule eazyBI]

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

[Deleted user]

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

[Sergey Sheypak]

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

[Deleted user]

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