Reports with Custom Field

This question is in reference to Atlassian Documentation: Advanced searching

Hello there, I currently have a custom fselect all of the ield set so my costumers can choose their country from a list(Is there another way to do this? Currently Im doing some codes in the custom field description field).

These countries is added by code by appending all of the countries into the dropdown list that I've created in my Issue Collector.

But now I'd like to create reports for these countries, the amount of issue for each country. This would take me days if I would add all of the contries manually, so what I would like is some JQL that could select all of the disctinct values that has been provided in my custom country field. 

 

 

1 answer

This widget could not be displayed.

I'm not quite sure what you're doing, but if you're using a standard select list for the country, then you're doing the right thing.

To report on it, run a filter and save it.  The filter needs to return all the issues you are interested in (so "project = xxx" or "country is not empty" might be simple starting points).  Once it's got the right set of issues in the issue navigator, save it with a sensible name.

Now go to your dashboard, add a gadget for "filter statistics" and select "country" as the field to report on.

So I'd have to add all of the countries in the whole world, manually.. for this to be able to be filtered?

Yes, that's how a select list works.

Sounds like JIRA should have a countrypicker. 


Well, let's say that I have a custom field that contains normal strings, can I somehow get a report on how many of each string there is on just that specific custom field? 

It's actually very hard to implement a generic country-picker to suit all your possible clients, as you rapidly run into country specific issues at a business level.  Do you just list all the sovereign states recognised by the UN?  Or do you mean actual countries?  What about principalities or protectorates?  I live and work in England, and the country is the UK on a broad level.  Some people can work fine with UK.  But if you're a lawyer, you need to be aware that Scotland's legal system has very significant differences to that of England Wales and Northern Ireland.  If you want to talk about money, you'll often need to select from Jersey, Guernsey, Isle of Mann, Gibraltar, and so-on.  I imagine many other "countries" have similar issues.  On top of that, what happens when you don't need all the countries?  Some people might only need the Commonwealth, or EU or Schengen area, or African countries.  And so-on.  It's easier to let people have a select list and they can put in their options.

Anyway, no, you can't easily report on text like that.  You'd need to run individual reports for each string you want to find (and what happens when someone makes a spelling mistake or uses a synonym?  A lot of people mix up Britain, the UK and often England, using them interchangably - we know what they usually mean, but the words are totally different)


Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

111 views 15 7
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