How to add a Jira ticket field into Issue statistics macro in confluence?

[Vicente]

I am working with multiple Jira filters on confluence creating a dashboard with many issue statistics macro visualizations to present certain information.

When selecting the statistics Type there some fields that are missing from the selection that are part of my Jira tickets. (Images attached to clarify)

 

How can I add the fields missing?.

[Alex Christensen · Accepted solution]

What type of field is the "Brand" custom field? Typically, issue statistics macros only work with custom field types that accept pre-defined values (i.e. single-select dropdown, radio buttons, etc.). If that "Brand" field is a text field, for example, then this field won't show up as an option in the Confluence issue statistics macro.

[Vicente]

Hey Alex, thank you for replying, and clarify how issues statistics macros works.
Indeed, Brand its a text field. /: 

I think I will have to think a different option, is there a similar macro that can preset text fields information? 

I'm still a new entry in Jira/Confluence

Thanks!

[Alex Christensen]

There is not a similar macro that I know of, no. In my opinion, the change should be on the Jira side, not the Confluence side.

If possible, I'd suggest changing the Brand field into a single-select dropdown field with pre-defined values you can choose from. If this list is long, that might not be a manageable option for you, but if you want to report in the way you want to report, then you'll need to make that change on the Jira side of things.

[Vicente]

Yeah, changing the field is not a very suitable option as the list of brands is not quite small, it would be a lot of manual work. I will figure out another option, no worries

I appreciate your help!