Need of Gadget/Chart for Developer's Sprint Load

[Laxman Prasad Kuppili]

Greetings Everyone!

I need someone to help me achieve the below use-cases either with the help of Gadgets or Charts on Dashboard.

I have a Squad of 8 members. Each member has certain number of stories for a Sprint with the Story points. 

 Although I can pull up the details using JQL and export the results to Excel to apply Pivot - this is a manual task and needs multiple exports for the latest data every time.

Can somebody please suggest me what gadgets/charts are available in Jira that fulfills my requirement.

I should be seeing the Assignee of Jira and the Sum of total Story points that he/she has for a given sprint as depicted below.

Use-case #1:

Use-case #2:

[Trudy Claspill]

Hello @Laxman Prasad Kuppili 

Jira Cloud has a native feature in the Scrum Board Backlog to display the workload per assignee for a single sprint, at least for Company Managed projects.

When there are users assigned to the issues you'll see their avatars at the top of the sprint and a ... button.

If you click the ... button your get the workload report for that sprint.

I don't see the same capability in Team Managed Scrum boards.

There is no "export" option for that information. And there is no native option to get that report for multiple sprints.

You would need to leverage a third party app, such as the one suggested by @Hannes Obweger - JXL for Jira to get a solution that would generate a multiple sprint report in one action.

[Mehmet A _Bloompeak_]

Hi @Laxman Prasad Kuppili

You can try Reports - Charts and Graphs for Jira Dashboard app developed by our team to create various reports, charts and graphs for your Jira projects.

Here is our live demo dashboard where you can see and modify sample reports and play with them. For more detail, you can have a look at Reports - Charts and Graphs for Jira How to Videos and How to Create Custom and Flexible Reports, Charts and Graphs in Jira article.

• You can create custom, flexible and colorful bar charts and table views for any data you want/need. As data source, you can choose Projects or Saved Filters or Advanced (JQL).

• You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.
• You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.
• You can group your data on any field(Sprint, Status, Assignee, Component, Project etc.) you want.
• You can choose various date ranges like All Time, Last Year, Last 3 Months, Last 6 Months etc.
• You can modify existing Segments or add new segments.
• You can order the results by drag and drop.

If you are looking for a completely free solution, you can try the limited version Reports - Charts and Graphs for Jira Dashboard Free.

Hope it helps.

[Valeriia_Havrylenko_SaaSJet]

Hi @Laxman Prasad Kuppili  👋

For your case , I suggest you to try Time in Status for Jira. You can filter data by Assignee and by Story points and get your report. All the reports you can display as Pie, Bar or Area Charts.



Another way to demonstrate data related to time - is using your gadgets. 




Also, we built a new Sprint Performance Report where we have all the metrics for each sprint. One of them is Workload  that refers to the volume of work assigned to individual team members.

I would be happy if you had a look at it! 

Add-on has a 30-day free trial version and free up to 10 users.

You can also book a live demo - we'll show you the application inside out and answer all your questions.

Have a nice day and happy sprinting 🥳

[Marlene Kegel - codefortynine]

Hi @Laxman Prasad Kuppili,

I am Marlene, product manager of Quick Filters for Jira Dashboards.

With our app you can sum up story points or any number fields, with our statistic gadgets or Quick Pie Chart gadget.

It's also possible to filter the Quick gadgets on your Jira dashboard dynamically using the Quick Controller gadget.

You can check out our app without installation on our demo dashboards.

 

[Laxman Prasad Kuppili]

Hi @Marlene Kegel - codefortynine ,

I have tried Two Dimension Filter gadget but in vain.

Can you demonstrate the same gadget using Story points rather the Fix Version please?

[Marlene Kegel - codefortynine]

Hi @Laxman Prasad Kuppili,

Have you tried to rebuild it with the Jira native "Two Dimensional Filter Statistics" gadget, or have you tried the gadget of our app?

If you want to work with the Quick Gadget you need to install our app "Quick Filters for Jira Dashboards" first.

You can test our app for free for 30 days. 

[Hannes Obweger - JXL for Jira]

Hi @Laxman Prasad Kuppili

if you're open to solutions from the Atlassian Marketplace, this would be easy to model using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can model a view like this in just a couple of clicks:

You can also easily model your scenario #2. As you can see, these views are fully interactive, meaning that you can work on your issues directly in JXL (but also trigger various operations in Jira, or export your data to CSV or Excel in just a click).

Since you've tagged your question for Jira Server: As you may have heard, support for Jira Server will end soon. Are you planning to migrate to Data Center or Cloud? I'd strongly recommend that. If you need some more time, JXL is perfectly compatible with Jira Server; it's just that we need to generate a license for you. If the above looks interesting, just let me know, and I'll happily start a free trial for you.

Best,

Hannes