I would like to count the number of issues in ToDo status, In Progress status, and Done status, but I am having trouble with the measurements. Maybe I don’t quite understand how to do it. Following previous suggestions received here in the community, and I always thank everyone for their helpfulness, I was able to set up measures that aggregate issues by status. For ToDo I aggregate Open and Technical Analysis, for In Progress I aggregate two other statuses, and so on. However, what happens is that when I run a JQL query and ask to display all issues with status “ToDo” or “Technical Analisys”, 10 issues are displayed. On eazyBi I only see 5. Maybe there is a problem with the logic used? In the sense that the creation date is used to show the issues on eazyBI, whereas I want to have some kind of snapshot that mimics what you would see if you ran a JQL.
Hi @kalos
I see that you have defined the Aggregate as a measure in the Measures dimension. By default, this will couple the statuses together with the default “Issues created” measure, so what you are currently seeing in the report are issues that were created in your selected Time periods that are currently in the “Open” or “Technical Analysis” status.
So the question here would be, what exactly would you expect this report to show for each of the months?
a) Would you like to see how many issues were created in each month that are currently in these statuses?
or
b) Would you like to see how many issues were in these statuses during the previous months?
About the “Issues resolved count” this will show the number of issues resolved during each month, however, this will use the Jira resolution field to determine the count of issues and will not look at the issue status. The numbers may not match up if you have several statuses with the Resolved resolution attached to them (Closed, Completed, Declined, etc.)
Best regards,
Nauris