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.
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.
Hello,
It is not possible with JQL. JQL always returns issues. It can not return customers.
You would need an add-on like easybi.
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 FROMTABLE(AUX.JQL('Reporter, Key','project in (...mentioned projects here...)') JQLGROUP BY JQL.ReporterORDER BY COUNT(JQL.Key)
Mentioned addon allows you to use mix of JQL and SQL worlds.
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
Thank you, this works a treat
It looks like you're new here. Sign in or register to get started.
