How to show resolved vs. open

Hello :)

Maybe you have a tip for me on how to create a chart that shows how many tickets we have already completed compared to the total ticket: resolved vs. open. e.g. 75 out of 250. This information should then always update itself. I want to see every day how many have already been completed out of the total number and how many are still outstanding.

Actually I'm working with this filter project in (APRICOTUI, APRICOTUIDEV, "MBUX-UI Software") AND issuetype in (Task, Sub-task) AND assignee in (bhenken, halisce, ikohler) AND resolved > startOfYear() but it shows only the resolved number.

It would be great if you could help as it's very important. Thanks in advance.

BR,

Inna

3 answers

1 accepted

1 vote

Answer accepted

Hello Inna,

It only shows the resolved issues, because you are explicitly filtering for it. In addition to "AND resolved > startofYear()", you could add "OR status in (Open)". Dont forget to add clips around it, so the full command would be

project in (APRICOTUI, APRICOTUIDEV, "MBUX-UI Software") AND issuetype in (Task, Sub-task) AND assignee in (bhenken, halisce, ikohler) AND (resolved > startOfYear() OR status in (Open))

Note: You have to add the exact status, which you use in your workflow, if you use the standard workflow this will probably be the status "Backlog" (instead of "Open"). But you can just check that in the workflow diagram.

To show these issues in a diagram, I would recommend creating a dashboard. There you can use different gadgets like pie charts or issue statistics.

Hope this helps.

Greetings Chris

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Chris,

Thank you very much for your help. I used the updated filter. Instead of "open" I searched for "to do".

Not it looks better:

Can I add one more status? I would like to see also the status "in progress". I tried to add it, but unfortunately the system didn't find it.

Thank you and BR,

Inna

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello @Inna Kohler

That's great to hear :)

Yes, you can add more status. For the status "In Progress" you can use the JQL:

project in (APRICOTUI, APRICOTUIDEV, "MBUX-UI Software") AND issuetype in (Task, Sub-task) AND assignee in (bhenken, halisce, ikohler) AND (resolved > startOfYear() OR status in (Open, In Progress))

Is the status part of your project workflow?

You can check that by opening an issue of your project and click "View Workflow":