Can JIRA Free Text fields be used as reportable fields in a Pie Chart?

Question

I want to use a JIRA field that has been specified with the Free Text Searcher Search Template in JIRA as a reportable field in Confluence when creating a Pie Chart using the Pie Chart macro. Unfortunately, the field does not show up in the Statistical Type menu, so I cannot select it. Is there a workaround for making a Free Text field reportable?

Nic Brough -Adaptavist- · Answer

Not natively because free-text fields are by definition free-text.  They're not expected to hold limited options from a pre-set list, they're intended for data that in a pie chart would simply return a chart made up of slices of 1 item (one for each issue)

If you're willing to code, script or use add-ons, there are ways you could get around this, like parsing a text field for what you're interested in and setting a select list to the right value, and there are some things that can do some form of translations that subtly ignore this.

But the real answer is to use a select list instead.

Andrey Khaneev _StiltSoft_ · Answer

Hello Dena,

You can use Jira Issues macro to output the table with issues and this field and then use Chart from Table macro (Table Filter and Charts add-on) to create a pie chart. Possibly, you'll need to use Pivot Table macro to count number of each value of the Free Text field.