Hi Everyone, In Jira Cloud, I need to generate a single downloadable report that shows issue counts grouped by Issue Type and by a custom field with two possible values (binary outcome). Example output required: Issue TypeValue AValue BService RequestXYIncidentAB Constraints: * Custom field already populated * Do not want to do any manual processing in Excel after export * Dashboard views or screenshots are not sufficient * Free solutions preferred Is this achievable using: * Native Jira features (filters, dashboards, gadgets), or * Any free Marketplace add-on? If not supported, can someone confirm this as a platform limitation and suggest the closest supported alternative?

Hello @gollapudi sidhvi , No, Jira Cloud cannot natively export a single file that already contains grouped/aggregated counts (Issue Type × Custom Field) without post-processing. That applies to: Filters Dashboards Gadgets Native CSV / Excel exports They all export raw issues, not aggregated results. So your example table: Issue TypeValue AValue BService RequestXYIncidentAB cannot be produced directly by Jira Cloud out of the box. Also i can't find any free options in marketplace.

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; } } }

Is it possible to export grouped issue counts by issue type and custom field in Jira ?

gollapudi sidhvi

Hi Everyone,

In Jira Cloud, I need to generate a single downloadable report that shows issue counts grouped by Issue Type and by a custom field with two possible values (binary outcome).

Example output required:

Issue Type	Value A	Value B
Service Request	X	Y
Incident	A	B

Constraints:

Custom field already populated
Do not want to do any manual processing in Excel after export
Dashboard views or screenshots are not sufficient
Free solutions preferred

Is this achievable using:
- Native Jira features (filters, dashboards, gadgets), or
- Any free Marketplace add-on?
If not supported, can someone confirm this as a platform limitation and suggest the closest supported alternative?

Accepted answers

Ugnius Aušra

Hello @gollapudi sidhvi ,

No, Jira Cloud cannot natively export a single file that already contains grouped/aggregated counts (Issue Type × Custom Field) without post-processing.

That applies to:

Filters
Dashboards
Gadgets
Native CSV / Excel exports

They all export raw issues, not aggregated results.

So your example table:

Issue Type	Value A	Value B
Service Request	X	Y
Incident	A	B

cannot be produced directly by Jira Cloud out of the box.

Also i can't find any free options in marketplace.

All comments

Ugnius Aušra

Hello @gollapudi sidhvi ,

No, Jira Cloud cannot natively export a single file that already contains grouped/aggregated counts (Issue Type × Custom Field) without post-processing.

That applies to:

Filters
Dashboards
Gadgets
Native CSV / Excel exports

They all export raw issues, not aggregated results.

So your example table:

Issue Type	Value A	Value B
Service Request	X	Y
Incident	A	B

cannot be produced directly by Jira Cloud out of the box.

Also i can't find any free options in marketplace.

Danut M _StonikByte_

Hi @gollapudi sidhvi,

Have you tried the Two-Dimensional Filter Statistics gadget in Jira? It displays statistics like this, though I’m not sure whether your field is available as an option in the gadget’s settings.

If this Jira gadget does not work, I would recommend searching for an app (plugin) on Atlassian Marketplace.

If you want to try a plugin, our Great Gadgets app (free only during 30-days trial) offers a Pivot Table & Pivot Chart gadget that should do the trick.

To get this, configure the gadget like this:

Thank you,

Danut Manda

burakgeyik

Hello @gollapudi sidhvi

Please also give this app a try:

https://marketplace.atlassian.com/apps/2099091683/metrics-and-reports-for-jira-service-management-jsm

Kind regards,

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-service-management-cloud

jira-service-management

reports