Few of custom fields not showing in TWO Dimensional filter statics gadget

[Ramesh Udari1]

Hi,

We are using jira5.0.2 version and we came across one issue while configuring two dimensional filter statics gadget that is few of the custom fields not showing XAxis and YAxis drop downs.

[Nic Brough -Adaptavist- · Accepted solution]

It is not going to. As I already said, the axes fields must be countable, and text fields are NOT countable. Even if you coded to make them appear, you'd rarely get a result other than "1". Take this question as an example - each answer and comment is a text field. Unless someone posted exactly the same comment repeatedly, you've only got 1 of each.

As Keith has pointed out, the only useful one that's missing is cascading selects. Text, numbers, date/time, all produce nonsense if you could use them in this gadget.

[Nic Brough -Adaptavist-]

Hmm, someone just posted "this is a bad biased assumption" and voted me down I'm curious to know why. I'm interested in a use case for text - just because I can't think of anything even remotely useful (in the context of a counter gadget), doesn't mean there isn't one.

[&(*&)#)_*#@@(*)(@*)(*@]

the use case for text :

- user want the ability to enter arbitrary value to an issue.

- user want the ability to make 2dimensional statistic with this arbitrary value.

it mainly depend on the context and customers needs , arguing with uselfuness with customers is another story ;)

[Nic Brough -Adaptavist-]

Nope. Utterly useless. Arbitrary text is the whole point - it's mostly, if not entirely countless, and hence useless as a statable object.

This is not a case of arguing usefulness with a customer, it would be negligent to point out that they are trying to do something dumb.

On the other hand, I left out "labels". They should be statable too...

[&(*&)#)_*#@@(*)(@*)(*@]

'pointing out that they are trying to do something dumb' is a different story ..

[Ethan Foulkes]

Use case: We automatically populate a text field with an email address from an external database based a selected field in a parent issue when sub-task is created. It's a text field but since we control the input it is standardized and we'd like to be able to report on it.

[Nic Brough -Adaptavist-]

It's still a text field and hence arbitrary - it can't know that the values are fixed.  You could swap it to a select list as you know what the inputs are.

[Ethan Foulkes]

Yes I know. The list is controlled by an external system though and has a huge number of emails and is regularly updated. This isn't a big deal but I thought I'd give you an actual use case =)

[&(*&)#)_*#@@(*)(@*)(*@]

You can use this plugin

it add statistic for Custom Field Types :

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

best regards

[&(*&)#)_*#@@(*)(@*)(*@]

Anyone making the biased assumption that one use case must fit all use case is wrong .

It all depend on the context, but there is more than exctly one way.. ;)

Regarding the original question,

You can use this plugin

it add statistic for Custom Field Types :

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

best regards

[Keith Champoux]

It seems that Dashboard widgets like 2D Filter only allow selecting certain field types, per https://confluence.atlassian.com/display/JIRA/Adding+the+Two-Dimensional+Filter+Statistics+Gadget:
"If choosing a custom field, please note that the following types of custom fields are supported by this gadget out-of-the-box: 'Group picker', 'Multi select', 'User picker', 'Select list' and 'Version picker'."

In particular, note that per https://jira.atlassian.com/browse/JRA-6411, Cascading Selects are also noteworthy for not being selectable (without workarounds).

[Nic Brough -Adaptavist-]

Re-indexing only needs doing if you've been inserting data. New fields will show as soon as they're added.

However, for fields to be shown in the Axes drop-down, they must be "statable" - that is, things that can be counted. If you've added text, number or date fields, they'll never appear. Select list types and users will be,

[Ramesh Udari1]

Hi Nic & Keith,

I have created free text cutomfield and assiciated with project, but this custom field is not showing in two diemntional filter statics gadest.

[Sowndarya]

Nic,

I face some issues . I have 2 label fields

One label field is vaiable in the drop-down of Two dimensional gadget but the other field not listing.

What could be the reason?

[Nic Brough -Adaptavist-]

What type of fields are they?  Two label type fields works here for me.

[Sowndarya]

Both fields are label fields. Techncally it should work.

I have many Labels fields. There is no poblem with other Label fields.

But few of them not working.

[Nic Brough -Adaptavist-]

Ok.  Can you check that the fields have "searchers" in their definition (it's under custom fields -> field -> edit)

If they do, then the next thing is to start looking at logs, I'd expect to see errors when your user clicks on "edit" on the gadget to get the config screen to try to select the labels as axes.

[jose_castro]

Hello folks. I know this is an older post. However I just wanted to make you aware that I opened a feature request for the documentation to be updated https://jira.atlassian.com/browse/JSW-13785 as well as the ability to search instead of drop down when you are selecting fields https://jira.atlassian.com/browse/JSW-13786 for the gadget statistical parameters.

[&(*&)#)_*#@@(*)(@*)(*@]

the only useful one that's missing is cascading selects. Text, numbers, date/time, all produce nonsense if you could use them in this gadget.

this is a bad biased assumption.

[Tej]

Hi @Marc Trey

Even though I try with Stattable Searchers but still I didn't see number fields in 2d

[&(*&)#)_*#@@(*)(@*)(*@]

after changing the search template for your custom field you need to perform a reindex , please refer to jira-stattable-searchers wiki and https://bitbucket.org/treymarc/jira-stattable-searchers/issues/13  

[Tej]

Thank you! but to what template should I change for number field to display in two-dimensional 

I did re-index too but didn't see any this field in two-dimensional  

Screen Shot 2017-03-07 at 2.29.17 PM.png  

[Nic Brough -Adaptavist-]

Try changing it to "numeric (stats)" - that's the "searcher" that Marc's add-on adds.  (And re-index again, I'm afraid - not a lot we can do about the JIRA architecture here, however clever the code)

[Tej]

Thank you, @Nic Brough [Adaptavist] .. it worked 

[RambanamP]

if you created those custom fields then do reindex !!