Pie Chart Gadget - "Statistic Type" Fields Missing

What determines which fields are available under "Statistic Type" for the Pie Chart Gadget? The custom field I want to use is not there, yet there are many other custom fields (but not all) listed.

4 answers

1 accepted

2 votes

The fields have to be "statable", which is a dodgy word meaning simply "can be counted". Mostly means select list type fields, by which I mean you can look at a list, like the seven colours of a rainbow. Then you can count usage - "we've got 3 blue issues, 2 orange ones and 92 green". You cannot really do that usefully with text or date fields, it's nonsense - it would be vanishingly rare to get more than one.

I have to disagree with this assessment. There are many cases where you would want to have a generic text field, because you cannot predict what the values need to be, but where the actual values that are used will be some small finite list (customer names, for instance). I really with there was some support for this, even if you had to manually mark the field as allowable. The plugin mentioned below works great if you are hosting your own server, but if you use OnDemand, it seems like you're out-of-luck for the time being...

Hello Tim, I have been contacted recently for having this issue sorted out for a customer willing to switch to Jira On Demand. Let it be clear that your are not alone, feel free to contact me.

If you've got a small finite list of customer names, then you should put them in a list. Then the gadget will work. Unbounded fields don't make sense. What happens when I've got 10 distinct customers and a lot of bad spellers/readers/typists? I end up with a long list of duplicate entries. It doesn't work, because you're using the wrong field type.

@marc trey I was a bit puzzled by your response, Marc - Are you saying that you have found a solution for this issue that will work for OnDemand customers?

(Oh, and the case with the dodgy typists - I once worked around this "problem" by writing a field that took the non-stattable data and made it stattable - worked brilliantly for a while, then ran into massive performance issues as the data set grew. The chap who worked out what I'd got wrong said a solution like that simply cannot scale without rewriting part of the core of Jira)

@Tim the plugin is ready for JIRA Data Center , it is now up to Atlassian to add it to JIRA OnDemande , i have been ask by several customers for this plugin to be found within JIRA onDemande. @a display name Unbounded fields don't make sense to you. i think we had that discussion before. :)

We have used this strategy of dropdown lists as well, but there are still many cases where this is out of our control. For instance, the Jira Agile plugin uses custom fields for the Version, Sprint and Epic that an issue is associated with. Those fields are open-ended and are therefore not usable in gadgets. I could also see cases where someone would want to group data based on Requested Date, Affected Version, or even something like Labels. It seems like a solvable problem. The plugin below already provides the functionality, and I can also export the data into Excel and have it make those graphs for me. There is always the potential to configure something that returns meaningless data, but the tool itself should not limit that configuration. If there are concerns for performance, those should just be handled as edge cases (maybe showing an error if the number of categories exceeds some limit or if the underlying query would be too taxing).

Hi Michele,

You can have a look a this plugin , it add statistic for those custom fields:

  • Date Picker
  • Date Time Picker
  • Number
  • Select List (cascading)
  • Text Field (multi-line)
  • Text Field (single line)

Best regards

I have a field that represents queue ownership, there are only 10 possibilities for it.

The queue is used via a post- function that auto populates when a team is selected via transition.

That field shows which team owns ticket.

The search is based on this query - project = NOC AND project = NOC AND QUEUE ~ Fiber

How can I get the pie field options to show the "queue" field, is there an edit that can be done to query that will cause the field to display?

you need to change the searcher for your "queue" custom field , see configuring a custom field :

  • Search template — the mechanism for making a custom field searchable

ex :

 2356662647.png

I have a situation where a script compares the values of two custom fields that are single selects.  It then puts TRUE or FALSE (i.e. match or no match) into a script field.  This script field doesn't appear in the list of statistics available for the dashboard pie chart.

How do you suggest I get around that?

G>

You must assigne a statable search template that match the return type of your custom scripted field.

Here is a full example with a numeric value jira-stattable-searchers not working with scriptrunner

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,316 views 14 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot