gadget to display story points per assignee by status?

[Marcus Choi]

Hello,

Is there a gadget or a way display story points per assignee for the current sprint based on the status in a jira dashboard? 

For example, the gadget would display assignees on the y-axis and display the count of story points in each given status for the current sprint.

[Chris Buzon]

Those are not statuses on the sprint board, they are GROUPS of statuses (go into the board settings to see what statuses are actually there in the columns tab).  

You can then use various gadgets and reports to show you the workload in a sprint.  I don't know which version of server or what add-ons you have, so I can't be more specific. 

One way to approach this, assuming you've used the Status Categories correctly is to build a JQL query that takes into account statusCategory (ToDo, In Progress, Or DONE) and the sprint name/number (you can also use openSprints() function here sometimes).

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

[Marcus Choi]

Hi Chris,

After going into the board settings, it seems like there is a status for each column. (when scrolling to the right, it shows each columns with review, validate, and done after blocked in screen shot below)

I believe it is the cloud server and do not have any add-ons. I was exploring any built in functions first where it does not cost anything. Are there any recommended free add-ons? Basically, I would like recreate the table, except instead of counting the number of issues/stories, I would like to display the number of story points. 

However, I think the two dimensional filter gadget only counts the number of issues as default setting which cannot be configured when editing the gadget. Can't seem to change it to count the story points. Any tips?

Additionally, the JQL filter that is being is:

project = "CF" AND type in (Story, Task, Subtask) AND status in (Blocked, Done, "In Progress", Review, "To Do", "Validate") AND "Story point estimate" > 0 AND Sprint in openSprints()

[Chris Buzon]

Ah I see, these are Team managed projects - that's an important consideration.  The reports you can use are limited - you'll have to explore the ones found in the reports tab in the project settings.  As far as I know, that's pretty much all you can do. 

I'll poke around a bit and see if anyone has recommendations.

[Marcus Choi]

I see thank you. Also if there are any plugin recommendations to purchase will be great too.