Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,526
Community Members
 
Community Events
165
Community Groups

Simple chart report based on custom field

Hi,

I'm trying to create some reports based on a custom field. However, this field doesn't appear in the drop down list of fields when creating reports or gadgets (some other custom fields are there). 

I tried changing the type from text to number field type, but this didn't change behaviour. What's going on?

In addition to typical Jira reports I would like to get simple chart based on one field in the issues like I would do in excel. E.g stacked chart showing cumulative value of this field for all issues of high priority.

I know this is not what's Jira geared towards, but it must be possible to do something as simple as that without export to excel? 

Br,

Maya

1 answer

Hi @Majda Lazarevic 

I agree that the built-in, Jira Cloud gadgets are quite limited in what they support.  Without more information about what you are trying to visualize/report on, your options appear to be:

  • Investigate the other dashboard gadgets to see if they support your field
  • Investigate marketplace add-on products (for purchase) with better gadgets
  • Investigate the Atlassian Excel add-on (or Google Sheets) to simplify data access with Jira and build your own charting
  • Build your own gadget for displaying information on a dashboard

 

Best regards,

Bill

I'm having almost the same issue. Specifically, I'm trying to generate a chart in Confluence that would allow a colleague to see all the tickets (and their statuses) under one "Customer Name" (the custom field). This is a field all the epics in the Jira project have. 

This field does show up when I make a different chart, more of a list though, and not actually a ticket overview. So I don't understand what the difference is. 

Hi @Jordyn K_ Lee 

Are you trying to filter by the custom field or to chart the values in the custom field?  If just filter the values with JQL, have you tried the Jira Two Dimensional chart on your Confluence page?  This would be a table allowing you to select rows/columns, such as Assignee and Status.

Kind regards,
Bill

@Bill Sheboy Thank you for coming back to this! 

So specifically, the custom field of "Customer Name" does not populate as an option to chose in the Y or X axis. So yes, ideally, a 2D chart would serve perfectly, but I don't know how to make it appear for me. 

The field is a text field, but I wouldn't think that would be a problem, it should just list whatever was filled in. 

Yes, I wish the gadgets were "smarter" that way...but simple typos could lead to lots of values not merging as a single reporting value. 

The only work-arounds I know of for this would be to use Components, Labels, or a single-select custom field for customer name.  Those would allow selection for what you noted.

Like Jordyn K_ Lee likes this

That is valuable info. that might work for my purposes. Thank you! 

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,113 views 34 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you