JQL to return open Tickets count for Customer.

[Deleted user]

We are using JIRA v7.1.4

I would like to display a query which return a list of customers with the most amount of open tickets. Top 10 customer with open tickets.

Thanks.

[Kat Warner · Accepted solution]

I have used a dashboard filter to get this information in the past. Here is a screen grab of the Two Dimensional Filter Statistics gadget settings that will give you a list of the topic 10 customers with the most open tickets. If you use a separate project for each customer then use 'project' in the Y-axis selection.

[Deleted user]

Thank you, this works a treat

[Alexey Matveev]

Hello,

It is not possible with JQL. JQL always returns issues. It can not return customers.

You would need an add-on like easybi.

[Martins Vanags -eazyBI-]

Hi,

Indeed, you could use eazyBI add-on for Jira to generate custom reports such as the required one.

Please find some useful demo reports here:

https://eazybi.com/accounts/1000/dashboards/4553-jira-issues-dashboard

Martins / eazyBI support

[Piotr Bojko]

Assuming your "customer" is a reporter in some projects, you can browse all issues with JQL:

project in (...mentioned projects here...)

Then, using third party addon, like https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview you can do a following query:

SELECT JQL.Reporter, COUNT(JQL.Key) ISSUES_NO FROM
TABLE(AUX.JQL('Reporter, Key','project in (...mentioned projects here...)') JQL
GROUP BY JQL.Reporter
ORDER BY COUNT(JQL.Key)

 Mentioned addon allows you to use mix of JQL and SQL worlds.