How can I display the list of issues grouped by the assignee

[Sandeep Gangwar]

In my Jira dashboard I want to display the list of tasks/issues in current sprint grouped by the assignees , like how many tasks/issues user X is working over how many user Y etc.

[Bert van Dijk _TMC_nl_ · Accepted solution]

Hi @Sandeep Gangwar ,

Did you already try to create a dashboard with the "Two Dimensional Filter Statistics"?

https://XXX.atlassian.net/jira/dashboards

[Sandeep Gangwar]

Hello @Bert van Dijk _TMC_nl_ - I got this gadget, however the link you gave its broken ( 404 error) but this gadget info was helpful many thanks

[Geethanjali Katagani · Accepted solution]

Hi @Sandeep Gangwar ,

After creating the dashboard, please add the "Two Dimensional Filter Statistics" gadget to it.

During the configuration of the gadget, follow these steps:

1. Select a saved filter.
2. Create a filter for active sprint data using the provided query below.
Project = "EA" AND Sprint in openSprints()
3. Afterward, configure the gadget to match the settings shown in the attached screenshot.

4. Save it.

Let me know if you have any questions or need further assistance.

Best regards,

Geethanjali

[Sandeep Gangwar]

Thanks much @Geethanjali Katagani this was helpful.. I just started with it feeling like lot to explore.. as bit erroneous records coming too

[Geethanjali Katagani]

Can you share what are the errors you are facing, we will try to help you.

Regards,

Geethanjali

[Sandeep Gangwar]

Its actually not the error but to rename the fields being displayed so on X axis I took assignee in columns and sprint on Y axis .. So while the displayed it correctly but there are certain epics which are also assigned to the users that got displayed as "None" on Y axis.. I wanted to rename this None as Epic just to make it more meaning ful.

[Geethanjali Katagani]

The field names displayed in the gadget cannot be changed in gadget.

If those field are custom fields, you can rename the field in the custom field section (global settings>>issues>custom field>)

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Sandeep Gangwar

welcome to the community!

Just to add to Bert's answer: For a more advanced visualisation, you may want to have a look at 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 build a view like the following in just a couple of clicks:

(I should add that JXL doesn't currently come with a dashboard gadgets (although this is something we want to add soon), but many of our customers simply use a JXL sheet as a de-facto dashboard.)

Any questions just let me know,

Best,

Hannes

[Sandeep Gangwar]

hey @Hannes Obweger - JXL for Jira - This is certainly top notch and over and above what we have in existing gadget / widget .. Yes I want this shall I need to pay for this in future I can see free for now..

[Hannes Obweger - JXL for Jira]

Hi @Sandeep Gangwar,

I'm glad you like JXL!

JXL is an app that is available from the Atlassian Marketplace. Like any other Marketplace app, you can trial JXL for free for 1 month. After that, the price depends on the number of users on your Jira site - however for sites with up to 10 users, it is free forever. You can also check out our pricing calculator here.

Best,

Hannes