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?

[Ugnius Aušra · Accepted solution]

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