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

[Amit Tandon]

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:

1. Created a filter to get all issues of type "Sub-Task".
2. 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_]

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

[Bill Sheboy]

Hi @Amit Tandon -- Welcome to the Atlassian Community!

That gadget only allows selecting fields with discrete values, not time tracking or number fields.  Those would have an infinite number of values and so could not be displayed one-by-one on an axis.

The built-in reports for time tracking are quite limited, so please consider either exporting the data to perform the analysis in a spreadsheet or investigating marketplace addons for dashboard gadgets / reporting.

Kind regards,
Bill

[Marlene Kegel - codefortynine]

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]

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

[Danut M _StonikByte_]

Hi @Amit Tandon,

Welcome to the Atlassian Community!

I assume that you want to display the sum of Original Estimate per assignee. Unfortunately that Jira gadget does not support stats by Original Estimate field. In general, the gadgets of Jira display stats by issue count, not by sum of field values.

A solution in this case would be to search on Atlassian Marketplace for a plugin that provides a gadget capable to generate such stats. 

If you want to try a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that allows you to easily calculate and display this in form of multi-dimensional tables or charts. See some examples.

If you need any help in setting-up this gadget, feel free to contact us at support@stonikbyte.com.

Danut

[Vishal Biyani]

@Amit Tandon 

Another option is to copy these values in a custom field using automation. Then the custom field can be viewed in the Two-dimensional table.