Two Dimensional Filter Statistics - Across Projects

[Garth Smitman]

I have Components XYZ, ABC, JKL in Project A

I have Components ABC, DEF, GHI in Project B

When I have the filter to pull both projects, the Two Dimensional Filter Statistics gadget gives me:

• ABC
• ABC
• DEF
• GHI
• JKL
• XYZ

 How to I get the issues for Project A with Component ABC added to the issues for Project B with Component ABC so that a single line appears?

I notice in the query when I click on the issues that the JQL automatically includes the 

AND component = "ABC" AND project = A  

[Bill Sheboy · Accepted solution]

Hi @Garth Smitman 

That built-in gadget cannot do that, because...

Components are defined by project and so your different values for "ABC" in Project A and B are indeed different components.  The gadget is using the components' id value and not the display name for the grouping items.

There may be marketplace addon gadgets that can do this.

Kind regards,
Bill

[Garth Smitman]

Perfect. Makes sense. (I should have examined the API, thanks for the reminder Bill!)

-gs

[Marlene Kegel - codefortynine · Accepted solution]

Hi @Garth Smitman,

I am Marlene from codefortynine.

Our app Quick Filters for Jira Dashboards matches components of different projects with the same name. 

On this screenshot below you can see the native Two Dimensional Filter Statistics (bottom) gadget  compared with our Quick Gadget (top).

Our app provides other advanced dashboard features, like filtering gadgets dynamically and summing up number fields in our statistics gadgets (including the Two Dimensional Filter Statistics gadget). 

You can check out our app on our demo dashboards.

[Garth Smitman]

@Marlene Kegel - codefortynine Thank you!

Yeah. I was hopeful for a native solution. While I have a 1,000+ active users, I only have a single user that is complaining about this single use case within the native functionality at the moment. I was hopeful I was missing something. 

Your solution looks promising! As we mature in our reporting, I'll keep this in mind.

Thank you for the quick response!

-gs

[Hannes Obweger - JXL for Jira]

Hi @Garth Smitman

I understand you are after a native solution, but just for future reference, this would be trivial to do 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 issue grouping by any issue field(s), and sum-ups. With these, you can recreate a lot of the use cases for the Two Dimensional Filter Statistics gadget, and many more. Plus, if you group by components, this works across projects, like so:

As you can see above, this view remains 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).

Hope this is useful,

Best,

Hannes