Unable to create Jira dashboards/reports based on Branch (auto-filled Text field from Assets)

[gollapudi sidhvi]

Hi Everyone,

I need to create dashboards and reports for auditing purposes, grouping issues by Branch.

The Branch field in my Jira project is a Text field that is automatically populated from Assets (CMDB) using automation. The field values are coming correctly into the issue.

However, when I try to create dashboards or reports (Pie Chart, Issue Statistics, Filter Statistics, etc.), I am unable to group or filter issues by the Branch field, as it does not appear under Statistic Type.

Is this a known limitation of Text fields in Jira reporting?

What is the recommended best practice to create branch-wise dashboards and audit reports when the source of data is Assets?

• Should Branch be a Select List instead?

• Is there any supported way to report directly on Asset-derived values?

• Are there automation or alternative approaches that work well for audit reporting?

Looking for guidance or real-world solutions.

[Marc -Devoteam-]

Hi @gollapudi sidhvi 

You can't use text field in a Pie chart, this is know limitation.

My other question i why copy assets info to a text field, why not create a custom field of type assets

Then you can create a Pie chart based on this field as statistic type.

Or if you want to keep your current setup, you would need to look at a 3rd party app from the marketplace to extend your dashboard options.

[Marlene Kegel - codefortynine]

Hello @gollapudi sidhvi

I’m Marlene from the team working on Quick Filters for Jira Dashboards.

With Jira’s standard gadgets, it’s unfortunately not possible to group by a text field. However, there are some workarounds.

For example, with our Quick Pie Chart gadget, you can create statistics based on custom JQL values. That means you can build charts for anything you’re able to filter using JQL. 

Here’s how this would look for a custom text field:

The main limitation to keep in mind is that you need to know the values in advance. If a new value is later written into the text field, you’d need to update or add a corresponding JQL query for it to be included in the statistics.

This is how the config looks like: 

But if that would be still an option for you, feel free to check out Quick Filters for Jira Dashboards or other in the Atlassian Marketplace. 

[Danut M _StonikByte_]

Hi @gollapudi sidhvi,

The fields of type "text" are not available to use in Jira native gadgets. You could try using a field of type single select instead.

If you consider the option of using a plugin from Atlassian Marketplace, this can be easily done by using the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app.

This gadget supports fields of type "text" and allows you to easily generate multi-dimensional statistics in form of tables, heatmap tables or charts of various types. 

To do this, just add the Pivot Table & Pivot Chat gadget to your dashboard and configure it like this: 

Danut.