What is the way to ask in JQL to count the issues, but only count once issue with the same value?

[George Edward Yong García]

Hello,

I would like to know if there is a way to ask in JQL to count the issues, but only count once issue with the same value in a field.

[Ronald Khoo]

In the bottom of the results list, you may see the total count of issues returned by your JQL:

[Tim Perrault]

Hi @George Edward Yong García 

There isn't really any JQL that will help you count. You could write a filter and then use a dashboard gadget that might be able to give you a count. You could also export the search and use Excel to filter on the field.

Thanks,

Tim

[George Edward Yong García]

is not there "GROUP BY" instruction ?

[Tim Perrault]

You could use ORDER BY Resumen but it won't give you a number count it would just order them by that field.

[George Edward Yong García]

Sorry, I could not express what i want correctly. What I really want is that if several issues have the same value in a field, then only one issue of them appears.

[Bill Sheboy]

Hi @George Edward Yong García 

To add to what @Tim Perrault is describing, JQL is not a SQL, and so does not have many SQL common features, like GROUP BY, COUNT, etc.

Your work-around options are influenced by how often you need this capability:

• infrequently: export your issue data for analysis in another tool, such as a spreadsheet, for analysis
• frequently: investigate the marketplace for JQL addon apps

Kind regards,
Bill

[George Edward Yong García]

Thanks a lot for your answers @Tim Perrault and @Bill Sheboy .

Regards

[John Rocha]

The idea for exporting to excel doesn't work. JIRA stops after 1,001 entries, even when there are many, many more.....

[Tim Perrault]

@John Rocha 

It is possible to get more than 1000 entries, but it does require a bit more work than just hitting the export to csv button.

https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html