JIRA - adding a field w/in a gadget in a dashboard

[Julio Valdez]

Hi,

I have a JIRA project with custom fields (inventory for computer workstations) and would like to create a 'pie chart' representing the different type of workstations we have (custom field 'model' describes the type of workstations we have). 

When I create a dashboard, I select a 'pie chart' as a gadget. I then select  the 'Statistic Type' field selector which does not include my custom field 'model' hence I'm not able to create a pie chart depicting the different model of workstations we have.  

Any ideas?

Thanks in advance. 

JIRA v 6.2.2

[Andy Heinzer]

I think it is possible that this was a bug in these older versions of Jira.  I found this bug ticket about problems with the pie chart gadget in older Jira versions 6.3.x https://jira.atlassian.com/browse/JRASERVER-40989

In my 7.7.0 version of Jira I was able to create a pie chart and then choose my custom field of type "Single Select field".   This field has 4 options in my instance and it was able to create a pie chart for all the issues included by the JQL filter about those issues.

That version of Jira is beyond end of life for support.  However if you were to obtain an updated license you could upgrade your Jira version to a supported version where this fix should already exist.   In cases of these older Jira versions, I would recommend upgrading to a 7.0.x version and then making sure to update all your needed plugins before then upgrading to the latest versions.  There are known problems with trying to upgrade Jira from 6.x versions directly to any version 7.2.x or higher that can be avoided by simply doing this intermediate upgrade first.

[Julio Valdez]

I have a Q&A instance with v7.2.2

I have multiple Dell workstation models and want to create a pie chart to display this.  I can't quite figure it out.  What JQL entry do I need to capture this?  The JQL below displays all my workstatsions. Thanks in advance.

project = SYSI AND OS ~ "Red Hat Enterprise Linux Client" AND model ~ Dell AND region_building in (SDUS-MIL-B1-F1, SDUS-MIL-B1-F2, SDUS-MIL-B2-F1, SDUS-MIL-B2-F2, SDUS-MIL-B3-F1, SDUS-MIL-B3-F2, SDUS-MIL-B4-F1, SDUS-MIL-B4-F2, SDUS-MIL-B5-F1, SDUS-MIL-B5-F2, SDUS-MIL-B6-F1, SDUS-MIL-B6-F2)

[Andy Heinzer]

I'm not sure what field you're using for the statistic type in the pie chart.  When you edit this gadget on a dashboard, you have to pick a filter, and a statistic field.   The filter it up to you, it should include all the jira issues you want to represent on this pie chart.  I would recommend starting with a really general jql filter like 'project =xyz and issuetype=task'

Just to see what results come back in the gadget.  You can always then go back and edit the filter to refine your selection criteria.

But the statistic field depends on how you want to represent the data on the pie chart.   Are you using the field called 'model' for this statistic type?   If so, this could work, but I don't know what field values exist in that field, is it something like 'Dell Optiplex 745' and alike?   Provided that model has distinct values there, I think that should work for your pie chart.

Also, what kind of custom field is 'model'?  Is this a text field single line, text field multiple, select field, cascading select, etc?

[Julio Valdez]

I don't see "model" as an option though this is a field w/in the project I'm selecting. This is a text field.

 

[Andy Heinzer]

Hi Julio,

Thanks for posting the screenshots of this.  I was able then to better understand exactly what the problem is now with this information.

The problem here is that you cannot use a custom field of type 'text' in order to be a statistic type on that pie chart gadget.  My apologies, I did not realize this was the case until now. This gadget will let you select other fields of type, version, labels, single select, and others.   However it does not allow you to use a single line text or multi-line text field as the statistic type.

In your case, there does not appear to be a way to get that data in its current state to display for this gadget.

So I created a feature request in regards to this limitation:

https://jira.atlassian.com/browse/JRASERVER-66870

There is no guarantee that this feature would ever be implemented by Jira.

So in the meantime, it would probably be easier to export that data into a CSV, and then create a new field of type 'single select'.  Once that exists for these issues, you could then just reimport that data back to these issues on that new field.  This is one way you could then use that new custom field of type select in order to get that data to display.   This isn't a perfect solution, because then you have two fields on issues and in turn you might have to manage what options exist on the select field both before and after the csv import happens.  

There is a KB on the different methods you can use to try to migrate this custom field data into another format that Jira can use, Changing Custom Field Types in JIRA

[Julio Valdez]

Thanks for your reply.