How to Display "Original Estimate" in Two Dimensional Filter Statistics Gadget?

Question

Hi everyone,

I'm trying to generate a report to get the total estimates added per assignee using the Two Dimensional Filter Statistics gadget in Jira. Here's what I've done so far:

* Created a filter to get all issues of type "Sub-Task".
* Selected "Assignee" for the X-axis.

However, I'm unable to select "Original Estimate" for the Y-axis as it doesn't appear in the dropdown.

Has anyone encountered this issue before? How can I get the "Original Estimate" field to show up in the Y-axis dropdown or is there an alternative way to generate this report?

Thanks in advance for your help!

Alexey Pavlenko _App Developer_ · Answer

Hi @Amit Tandon ,

Unfortunately, neither the Two Dimensional Filter Statistics nor any other JIRA native gadget can do this type of aggregation.

However, if you are open to other views as well, you can consider the 3rd party app I developed - Multi-team Scrum Metrics & Retrospective.

You can display multiple boards over various periods - years, half-years, quarters, months, or sprints in a single view. In the same place you get statistics and the content of each bar. With the app, you can cover a lot of other gaps - for example, you can conduct in-place retrospections.

Best regards,
Alexey

Marlene Kegel - codefortynine · Answer

Welcome to the community, @Amit Tandon,

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

As others have mentioned this is not possible with Jira native gadgets.

Our apps also provides a lot of dashboard gadgets that enables you to sum up all Jira number fields, including estimates.

You can try out Quick Filters for Jira Dashboards without installation on our demo dashboards.

Hannes Obweger - JXL for Jira · Answer

Hi @Amit Tandon

welcome to the community!

Just to add to Bill's great answer: If you're open to solutions from the Atlassian Marketplace, you'll have a number of options available. E.g., I believe that your use case would be easy to solve 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 long list of advanced features, including support for issue grouping by any issue field(s) and sum-ups.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc.

I should also add that JXL can do much more than the above: From support for (configurable) issue hierarchies, to conditional formatting, or inline bulk editing via copy/paste.

Any questions just let me know,

Best,

Hannes