nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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:

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

Accepted answers

Bill Sheboy

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

Marlene Kegel - codefortynine

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.

All comments

Bill Sheboy

Hi @Garth Smitman

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

There may be marketplace addon gadgets that can do this.

Kind regards,
Bill

Marlene Kegel - codefortynine

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

Garth Smitman

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

-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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

dashboard

gadget