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 show resolved vs. open

Inna Kohler

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

Accepted answers

Chris K_4mhp8d

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

All comments

Jack Brickey

Hi @Inna Kohler ,

have you looked at creating a dashboard and adding the created versus resolved gadget?

Chris K_4mhp8d

Hello Inna,

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))

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

Chris K_4mhp8d

This is also a superb gadget to check out Still need to adjust the filter, though.

Inna Kohler

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

Danut M _StonikByte_

Hi @Inna Kohler,

Have a look also over these articles on our blog on how to display a open vs resolved chart.

You can have this info as a trend chart:

Or as numbers:

If you need any assistance with the configuration of our gadgets, please don't hesitate to contact support@stonikbyte.com.

Regards,

Danut Manda

Chris K_4mhp8d

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":