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?

2 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

Thanks!

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.

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

22,336 views 2 7
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you