Filter returning wrong data

[Akash]

Hi, I have created three Gadgetsj and their filters are as follows along with their outputs:

1) Filter counts: Number of Tickets Created
JQL
Gadget Output:


2) Filter counts: Number of Tickets Resolved
JQL

Gadget Output:


3) Created vs Resolved Filter
JQL

Gadget Output:

-----------------------------------------------------------------
Why I am getting wrong count of Resolved issues in the Created vs Resolved Gadget. Please let me know. Thanks

[Trudy Claspill]

Hello @Akash 

In Filter #1 you are using

status not in (Cancelled, Rejected)

In Filter #2 where you are selecting what you are calling "resolved" issues (which is not the same as what the gadget considers Resolved issues) you are using

status = Done

In the gadget filter you have

and (created <= now() OR (status = Done and resolution is EMPTY))
and status not in (Cancelled, Rejected)

Your gadget filter does not represent a combination of the first two filters, so you are not getting the same set of issues.

Additionally the Created vs. Resolved gadget looks at the Resolution field and Resolved date to determine which issues are resolved and when they were resolved. It does not rely on the Status of the issues. So the Resolved issues it is counting are only the ones where the Resolved field is not empty, within the set of issues selected by your filter.

Can you explain what metrics you are trying to get, and the reasoning behind the filters you created?

[Trudy Claspill]

No it is not possible to change the configuration of the gadget to consider issues with an empty Resolution field as Resolved.

For creating valid data for future use, you should update your workflows so that transitions to "done" statuses also set the Resolution field.

Based on the response to the following post it is possible to set the Resolution field and the Resolved timestamp using a CSV import. I haven't tested this for myself.

https://community.atlassian.com/t5/Jira-questions/Change-the-resolution-date-to-the-date-of-the-status-category/qaq-p/2480530

[Akash]

Thanks for all the input. I think the main issue is that the Resolution field is not set and the status is done. I have tested this and the Created vs Resolved gadget is not considering the tickets where the Resolution field is empty and is showing unresolved. Further, we can't edit the Resolution field either.

Is there any solution to have the Gadget include the tickets without the Resolution field as well?

[Bill Sheboy]

Hi @Akash 

First thing, for your "3) Created vs Resolved Filter", you have this expression:

AND (created <= now() OR (status = Done AND Resolution IS EMPTY))

now() is "now" and so it would not be possible for issues to be created after the moment the query runs.  Thus the second part of that expression will never impact the results.

Next, you are hiding much of the JQL for three queries.  This makes it quite difficult for the community to advise on what may be different.

My suggestion is:

• Run each query with View All Issues, exporting the results
• Note in the dashboard gadget for Created vs Resolved the link near the bottom to "View in Issue Navigator".  Select the link to view the issues.
• Now compare the results of all three to identify what is different.

Kind regards,
Bill