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; } } }

Summarize table with Jira proyects

tpedriel

Hello. I'm looking for a tool in order to create this type of dashboard/table:

Asignee(Responsible for the task) Total of story points

Sprint Juan Carlos Sonia

Sprint1 10 9 6

Sprint2 7 10 5

Sprint3 6 6 5

To summarize, I would like to have a summary where I can visualize by sprint, the number of story points that each team member made.
I was able to create a dashboard with 2 axes (asignee vs sprint), but it only counts the tasks per users, and there is no possibility tu sum the story points.
Can anybody help me?

Thank you

Accepted answers

Joseph Chung Yin

@tpedriel -

Welcome to the community. Unfortunately using out of the box functionality (gadgets for dashboards/reports) in Jira/JSM is not possible to generate the reports that you wanted. I would recommend you to search via Atlassian Marketplace for third party add-ons that provide the functionality.

Examples - (NOTE- I have not used or evaluated any of those add-ons mentioned below)

https://marketplace.atlassian.com/apps/1219429/status-progress-report-gadget-for-jira?hosting=cloud&tab=overview

https://marketplace.atlassian.com/apps/1220136/quick-filters-for-jira-dashboards?hosting=cloud&tab=overview&source=community24

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

All comments

Joseph Chung Yin

@tpedriel -

Examples - (NOTE- I have not used or evaluated any of those add-ons mentioned below)

https://marketplace.atlassian.com/apps/1219429/status-progress-report-gadget-for-jira?hosting=cloud&tab=overview

https://marketplace.atlassian.com/apps/1220136/quick-filters-for-jira-dashboards?hosting=cloud&tab=overview&source=community24

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Esther Strom

Welcome to the Community, @tpedriel !

I agree with Joseph; it's not natively possible (if you have access to the beta Analytics product it might be possible at some point, but as of now sprint data isn't part of the data lake.)

You can pretty easily create a view like that in eazyBI if you own it, but even easier is sumUp. It's a set of dashboard gadgets that do on-the-fly calculations of things exactly like this.

2022-10-17 18_01_31-Edit - Esther's Demo Dash - Jira.png

2022-10-17 18_00_23-Esther's Demo Dash - Jira.png

Nauris Malitis -eazyBI-

Hi @tpedriel

In eazyBI you can use the predefined Sprint scope measures together with Sprint and Assignee dimensions to achieve a report like this.

We have a similar sample report in our Demo account:

https://eazybi.com/accounts/1000/cubes/Issues/reports/149997-story-points-resolved-by-assignee

You can modify this report by switching to the Table view, removing the Time dimension, and adding the Sprint dimension to the Rows section:

After that, explore the different Story Point measures you can select in the Measures dimension.

Let me know if you have any additional questions on this, or feel free to reach out to us at support@eazybi.com

P.S. @Esther Strom thanks for the shout-out!

Best regards,

Nauris / eazyBI support

tpedriel

Is this tool integrated with Jira?

Nauris Malitis -eazyBI-

Hi,

eazyBI is available in the Atlassian Marketplace as an app for Jira Cloud and Jira Server/Data Center: https://marketplace.atlassian.com/apps/1211051/eazybi-reports-and-charts-for-jira?hosting=cloud&tab=overview

Out of the box, eazyBI offers built-in integration with core dimensions and measures of Jira: https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-core-measures-and-dimensions

I would recommend checking out the short videos on eazyBI to get to know it better: https://docs.eazybi.com/eazybi/learn-more/training-videos#Trainingvideos-Let'sgetstarted

Let me know if you have any additional questions on this!

Best regards,

Nauris

tpedriel

Ok thank you. I will try it.

Another question, do you know if we can send automated reports when we close a sprint? Instead of doing it by a standard measure of time (e.g. daily, weekly, monthly), we do it when a sprint is close. We need this because many times the sprints doesn't have a strict standard duration, sometimes it last 17 days (because we have holidays in the middle) or it can even last for 20 days.

Thanks

tpedriel

Thank you!! that was really helpful, the only thing that is remaining is the order of the chart.

After sorting and filtering it, I can't show it chronologically in the graph. (In the example, the sprint Camelot 2.5 is the newest, I should visualize it in the right of the bar chart).

Is there any way I can sort the bar chart without removing the filter of top 5 rows?

Thanks!

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management