Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL to return open Tickets count for Customer.

Deleted user July 15, 2018

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.

3 answers

1 accepted

0 votes
Answer accepted
Kat Warner
Atlassian Partner
July 15, 2018

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.

Capture 2018-07-16 at 15.56.03.png

Deleted user July 17, 2018

Thank you, this works a treat

1 vote
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 15, 2018

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-
Atlassian Partner
July 16, 2018

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

0 votes
Piotr Bojko
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 16, 2018

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events