nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Katerina Rudkovskaya _Stiltsoft_

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.

All comments

Katerina Rudkovskaya _Stiltsoft_

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

jira

cloud

confluence-cloud

filter

table

table-filter

table-filter-and-charts