Report to show total complexation number of all issues against the name of assignee

[Eman Alfaour]

To get a report to include each team member’s task complexity total for the issues assigned to this team member . 

For example I want a report to display the team member name and next to it the correspond total number of complexity for the issues assigned to him . 

Also how can I calculate the summation of the complexation numbers across all issues  

[Valeriia_Havrylenko_SaaSJet]

Hello  @Eman Alfaour 

As an alternative, I guess you can try Time in Status  for Jira Cloud (developed by my SaaSJet team) with 7 types of status time reports can help you with this. 

For example The Time in status report shows how long an issue has been spent in each status.

The Assignee time report displays how long it takes each team member to solve a task.

Also, you can export a report as XLSX or CSV files for further analysis.

This add-on is developed by my SaaSJet team and has a 30-day free trial version.

Please, let me know if you have any questions

Best regards,

Valeriia

[Hannes Obweger - JXL for Jira]

Hi @Eman Alfaour,

since the field in question is a Single Select field and therefore not usually "numeric", I believe you'll have a hard time doing this in plain Jira; the only way I can think of is to copy the value from the Single Select into a number custom field using Jira Automation, and take it from there.

This being said, if you're open to solutions from the Atlassian Marketplace, this would be trivial to do in 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 the ability to group your issues by any issue field(s), and calculating sum-ups across these groupings. For sum-ups, JXL is smart enough to "detect" numeric values for select fields, like so:

As you can see above, I'm grouping by assignee and calculate a "sum" sum-up on the complexation field, which is a Single Select custom field (you could also configure other sum-up styles, like e.g. the average value). This works in combination with all other JXL features - from "basic" inline editing, to bulk editing using copy/paste, to other advanced features such as support for issue hierarchies or conditional formatting.

Note that all of this "just works", and doesn't require any scripting whatsoever - I set up the above report in just a couple of clicks.

Any questions just let me know,

Best,

Hannes

[Eman Alfaour]

Hi Hannes , 

Could you show me how to " copy the value from the Single Select into a number custom field using Jira Automation " 

I tried this (as shown in the below photo )but all I could get is a "none" outcome .

my single select field is "Task complexity per assignee " and the numeric field is " Task complexity " 

[Mehmet A _Bloompeak_]

Hi @Eman Alfaour 

There is a good solution for your request - Reports - Charts and Graphs for Jira app developed by our team.  As complexity is usually measured by Story points, you can get a bar chart of sum of story points by assignee as in the below screenshot.

Our app works on custom fields too. Therefore you can get the report based on your custom Select List (single choice) field too. Even you can get dynamic reports based on complexity like complexity by assignee and sprint, complexity by assignee and issue creation month.

Below you can see an article about creating custom charts in Jira with our app.
How to Create Custom and Flexible Reports, Charts and Graphs in Jira

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

[Joseph Chung Yin]

@Eman Alfaour -

Hi Eman:

What is your definition of task complexity?  In addition, how does your org determine the complexity (i.e. By story points or other custom fields) + are the org guidelines adhered by all the JSM teams?

Please advise, so I can suggest the appropriate actions on achieving your needs.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[Eman Alfaour]

this is done by a Select List (single choice) with numbers as its options , but if you have another suggestion regarding this please feel free to let me know .