I am tring to use Created Vs Resolved gadget

[Ravina Jigyasi]

Hi,

So i have been trying to configure my project dashboard with a created vs resolved chart and the avg number of days issues have been open but both gadgets are not behaving properly and not showing accurate data.LIike today 61 issues were open and now there are 53 but it is not getting captured here.Can someone please help?

[Danut M _StonikByte_]

Hi @Ravina Jigyasi,

As a better alternative to this Jira gadget, you could try the ones offered by our Great Gadgets app. As far as I can see, you have Jira FREE product plan; our app is also free in this case.

See this article on how to add a Reported vs Done chart: https://community.atlassian.com/t5/App-Central/A-powerful-Reported-vs-Done-chart-for-Jira-dashboards/ba-p/2610902

Even better, you could try using the Cumulative Flow Diagram (CFD) gadget offered by the same app. 

Done represents "resolved" and Total is "reported", so you can use it as "Created vs Resolved" chart.

See more examples of this gadget in this article: 

https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Danut. 

[Tim Kopperud]

Hi @Ravina Jigyasi, welcome to the Atlassian community.

Can you confirm that the resolved issues actually are set as resolved? That means having the resolution field set, and not only a status of category Done (green statuses). 

TimK

[Ravina Jigyasi]

Hi @Tim Kopperud,

Yes the team moves the status to live and then I personally have marked multiple issues as resolved.

[Tim Kopperud]

Hi @Ravina Jigyasi, are you able to

• show the JQL used in the filter HCM client issues?
• provide some details (image) of an issue that you expect to see in the chart, but dont? 

You might conceal sencitive information by "blacking out" on the provided images.

TimK

[Ravina Jigyasi]

Hi @Tim Kopperud please find the jql query below.

[Tim Kopperud]

Hi @Ravina Jigyasi, thanks. Do you also have this? 

• provide some details (image) of an issue that you expect to see in the chart, but dont? 

TimK

[Adrián García González]

Hi @Ravina Jigyasiwelcome to the Atlassian Community!

I understand that your problem is that when you create issues in the HCM Client project they are not reflected (or not all of them at least) in the Created vs Resolved Issues chart. If so, it is most likely that the filter you have selected is not selecting all the issues in the project. Can you share it? If it is a single project the JQL query could be something like this:

project = ‘HCM Client’

It will depend on your requirements of course.

Best regards!

[Ravina Jigyasi]

Hi Adrián García González please find the jql query below.

[Adrián García González]

Thanks for that.

The filter seems to be consistent. To try to find the problem here I recommend you to do the following:

Do this JQL search:

project = "HCM" AND created >= startOfDay() AND created <= endOfDay()

Check if the resulting number of issues is what you expect and the same as the one shown in the chart.

Hope that helps, best regards!

[Ravina Jigyasi]

@Adrián García González I created a test filter as given by you but the chart is not capturing any resolved items and only one day resolved.

[Adrián García González]

This means that 6 issues have been created in this project today and none of them have been resolved. In your initial question you said that 61 issues had been generated, could it be that they have been created (and eventually resolved) in other projects?

To solve this you need to find the issues you want to see, so you can adjust the filter.

Best regards!

[Ravina Jigyasi]

I meant that 61 issues are open currently and overall 160 issues have been resolved but chart is not capturing the resolved part

[Adrián García González]

Ah ok, thanks for the clarification. Could you show a query that selects the issues that have been created and resolved in the date range you expect?

This would help to see if the problem is that the gadget is not ‘looking’ at the issues it should be selecting.

In the end the gadget just selects the issues from the project or filter you specify and looks at the creation and resolution dates.

Best regards!

[Ravina Jigyasi]

This is the filer I use and the result I am getting.I think the gadget have a problem.

.

[Adrián García González]

Do resolved issues have a value in the Resolution field? I ask because in your query you are selecting those that are in Completed or Resolved status. The criteria that the gadget (and Jira in general) uses to determine if an issue is resolved is that some resolution has been set in the Resolution field of the issue.

This is usually done automatically when an issue is moved to Done status, although there are more ways to set this. You can see the best practices for this in this link.

Hope this helps, best regards!