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.

[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.