nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to create a pie chart using JQL

THE STORY TELLER

Hi team,

I want to create a pie chart that used more filter values. The pie chart option in Reports has an option to choose only 1 filter criteria.

For eg: I want to filter based on project team name, status and also say automation status - how to write a JQL and get a pie chart. I am aware of the JQL, but I am not sure how to use the JQL and build the pie chart in JIRA.

Can you pls help?

Accepted answers

Hana Kučerová

Hi @THE STORY TELLER ,

in pie chart gadget configuration you need to set two parameters:

Project or Saved Filter: the list of issues you want to work with
Statistic type: the field, which will be used to group the issues

It seems to me you mean you want to have more parameters for grouping, but this is not possible using pie chart gadget.

Use can use Two Dimensional Filter Statistics gadget to have two fields for grouping available.

All comments

Hana Kučerová

Hi @THE STORY TELLER ,

in pie chart gadget configuration you need to set two parameters:

Project or Saved Filter: the list of issues you want to work with
Statistic type: the field, which will be used to group the issues

It seems to me you mean you want to have more parameters for grouping, but this is not possible using pie chart gadget.

Use can use Two Dimensional Filter Statistics gadget to have two fields for grouping available.

THE STORY TELLER

Thank you Hana. I have seen in my earlier company where they used more than 1 filter.

Eg: Label ="xyx", status = "closed" and issuetype = "test" and automation ="Complete"

So this pie chart query will give all test cases for the team xyz, which are closed and automation is completed. With this I want to show a pie chart that will show completed, planned and cannot be automated automation cases as a pie for that team.

But I am not sure how it was done.

Hana Kučerová

Hi @THE STORY TELLER ,

sure you can search issues using JQL like:

labels in ("xyz") AND status = "Closed" AND issuetype = "test" AND automation = "Complete"

If you are happy with the result, you can save this JQL as filter and use this filter in pie chart gadget in parameter Project of Saved Filter.

Rodrigo Salomao

Hi @Hana Kučerová
Can I create a Pie Chart from the result of this JQL you shared?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud