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 , 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
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!
Lauma / firstname.lastname@example.org
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 / email@example.com
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 / firstname.lastname@example.org
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?
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:
-- 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)
-- for resolved issues only
not isEmpty([Measures].[Issue resolution date])
-- check if selected Assignee was the one when issue was moved to In Progress
([Measures].[Transitions to status],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember) > 0),
[Measures].[Issue Story Points]
Daina / email@example.com