How to display a total number of Story points estimate per assignee per active sprint in Confluence?

[Lina Sabestinaite]

I have embedded a filter table from Jira to Confluence showing issue, assignee, sprint, story point estimate. This was as a macro table. I am not able to create a chart or calculate totals of story point estimates per assignee. A total in a table or chart would work. Could anyone advice how to do this, please?

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Lina Sabestinaite,

If we talk about standard Confluence macros, I can suggest trying the Jira Chart macro to aggregate and visualize your Jira issues.

To aggregate/visualize the Jira Issues macro in a more customized way, you may try our app that is Table Filter and Charts for Confluence (it is free for Cloud 1-10 users).

All our macros support tables coming from the Jira Issues macros and allow you to perform calculations, filter and group your data, create dynamic charts right in Confluence.

Here you may find several examples with step-by-step guides. The only difference for you as a Cloud user will be in macro nesting: you don’t wrap them directly on the page but via our Table Toolbox macro. Other steps and settings will be the same.

[Lina Sabestinaite]

I will look forward into this app. Meanwhile, how to add "story points estimate" into the drop down in the Jira Pie Chart, Display options, "Chart by"?

Or into Jira issue/filter display options?

[Katerina Rudkovskaya _Stiltsoft_]

You can get Remaining Estimate, Time Spent columns to display in Jira Issue if Time Tracking is set in your Jira.

Along with Jira Issue you can use our Table Toobox then to create pivot tables, charts or transform data somehow etc. 

[Jesal Taneja]

Hello @Lina Sabestinaite  Did you eventually manage to display the sum of story points in a table? I'm looking to do the same.

thanks