Create a pie chart using a filter with specific labels

[Antonio Carvetta]

Hello Community,

I would like to explain the issue I'm facing and seek your assistance.

Currently, when the Support team raises a new defect, they populate the 'Client Name' field with various values, depending on the clients experiencing the issue. Our organization has different client categories, namely Clients A, B, and C.

My goal is to generate a pie chart specifically showcasing the issues related to Client A. However, when using Jira JQL, the query consistently returns a set of tickets labeled with either Client B or C by the Support team.

Could you please advise if there is a way to refine the Jira JQL query to display only Client A issues?

[Anthony]

I have a somewhat similar question. I have a JQL returning a list of issues (for example, all issues with label set to "client"). If I make a pie chart and use labels field as "static type" all labels will be displayed. So if an issue has several labels (for example, "client" and "q1") this will result in both of "client" and "q1" present on the chart. I want to be able to make a chart based only on specific labels. This limits heavily how labels can be used. Especially if you want to use them for several aspects of the projects. For example, same issue can be tagged with "client" to show relation to the client, "large" to show size and "q1" to indicate when we plan to look into it. My goal is to see only one dimension on the pie chart (for example size or client) and not all 3 at once as they are not related.

[Jehan Bhathena]

Hi @Antonio Carvetta ,

From what I understand, If that field has more than 1 value, would recommend using the below:

"Client Name" = "Client A" AND "Client Name" not in ('Client B', 'Client C')

Hope this helps. :-)

[Antonio Carvetta]

Some tickets contains Client A and B labels.

Using the above query would filter out this type of ticket.. and I need to report Client A stats.

[Jehan Bhathena]

Hi,

Bit confused about the requirements, you mentioned "Jira JQL query to display only Client A issues".

Please can you elaborate the use case once more please, perhaps I mis understood the problem statement.