Story points per assignee over a given period of time

[Jean Baptiste]

I would like to get a chart with the number of story points per assignee. For items current, done etc.

[Aylin Kohls]

Hi there! I don't know any gadget or report to do what you need, but just in case, you can filter issues over a period of time, export them to Excel and then use pivot table to calculate story points per assignee.

A possible jql for this is:

project = xxx and issuetype = Story and createdDate >= endOfMonth(-1) and createdDate < startOfMonth()

Instead of using createdDate, you could use sprint in (id, id, id), or any other date field that allows you to decide which issues filter.

I hope this was useful for you.

Regards, Aylin.

[Jean Baptiste]

Hi Aylin,

Great thanks. It could fit my need.

I created this jql:

project = DAS AND issuetype in (Bug, Epic, Idea, Improvement, "New Feature", Spike, Task, "Technical Story", "User Story") AND status = Closed ORDER BY cf[12366] ASC

But I would like to replace status = Closed ORDER BY cf[12366] ASC by a fix date like all the issuetype closed after the 2019/11/01. How can I write that please?

Thks.

[Aylin Kohls]

That's great!

A way I could think of is using the resolved jira field, or the status, with its modifiers:

resolved >= "2019/11/01" 

status changed from "In progress" to Done after "2019/11/01"

Regards, Aylin.