Discrepancies with Open Issues calculations (JIRA)


#1

So for some reason my open issues on EazyBI is show a much higher number than what I get using JQL.
JQL issuetype = “ISSUETYPE” AND resolution = Unresolved [OR is empty, both returns same] = 140 results
EazyBI is showing 300 for the month and no 160 issues were not resolved in the month of March.
When I drill down into the 300 open issues, most are “resolved” so I am not sure why old resolved tickets are being marked open.


#2

Hi @Harold_Wong,

Measure Open issues is a total count of created issues until the period end minus a total count of resolved issues until the period end. eazyBI considers the issue resolved if it has a resolution date (https://docs.eazybi.com/eazybijira/getting-started/measures-and-dimensions). In your case, most likely some issues are in resolved statuses but do not have resolution date and therefore are not counted as Issues resolved and accordingly are counted as Open issues. Usually, when an issue is resolved (moved to resolved status), Jira assigns resolution date to it. Many resolved issues with no resolution date may indicate that Jira issue workflow is not configured completely.

You may test the data quality of your Jira issues using this report from Demo account:

Import report definition into your eazyBI account and see which issues conflicting data. Please see a short instruction on how to import report definition: https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions

Best,
Zane / support@eazyBI.com