How can I add a chart to a confluence page showing story points per assignee in a sprint?

[Joseph Gordon]

I'm looking for a chart similar to the Two Dimensional chart showing the number of stories per assignee, but I would like to see the number of story points per assignee 

Thanks

[Tinker Fadoua]

Hi Joseph

project = X AND issuetype in (Story, Task) AND "Story Points" = "65" AND assignee in (currentUser())

You should apply this JQL query to the Two Dimensional Chart

let me know if you need more details or need more assistance

[Joseph Gordon]

Thank you, Fadoua! 

I have applied the JQL query to the Two Dimensional Chart. 

Admittedly I'm new to this so it's likely there's user error, but I was not able to render a table. 

Notes:

• I added the Project name for "X"
• I added a current user in the () - for example - assignee in (currenUser (inserted username here)) 

Any suggestions?

Thanks.

[Tinker Fadoua]

Hi Joseph,

Assignee in(name) remove currentUser

[Tinker Fadoua]

I also found this old discussion

[Joseph Gordon]

Thank you for your help, Fadoua!  Much appreciated. 

[Tinker Fadoua]

Any luck?

[Joseph Gordon]

We tried playing around with a the queries but unfortunately couldn't make it work.   We ended using the "Workload by assignee" Pop up window (that is generated by selected the "..." in the backlog for the active sprint).  

It shows a nice breakdown of points per assignee, but unfortunately it does not show how many points by assignee by status.  Not a huge deal, but I was trying to get creative for our reporting. 

[Tinker Fadoua]

Are you using a board? If you are by selecting a user you will be able to see the user's story point and progress. Attached is a screenshot

[Tinker Fadoua]

The screenshot above is after selecting myself from the quick filters on our team board

45 story points in to do

65 story points in progress

145 story point done