I would like to find out how to report back on the first time all issues that were moved to (States category Done) Per month.
We have a situation where we need to Report on calls closed in a specific month.
I know how to add all the metrics of Time as a Measure etc etc.
The challenge I have is that I moved a lot of issues from one project to another in a specific month ( let say in Feb) as they were incorrectly logged in the wrong project.
The challenge is, Easy Bi is reporting on the last time the call was moved to (status category Done). So now we have a situation where a lot of issues looked like they were closed in Feb and not the actual months they were closed.
I have read up on help guides and there are custom Measures I can make but its complicated for my small brain.
Below this is the closest I have come, but this is not working.
I would like to add, we need the number of calls done and not a date, I am currently getting a date.
But like I say, I am new to easy Bi, so I have no clue how to edit the below to get that amount.
[Measures].[Transition to status first date],
[Transition Status.Category].[Status A],
You can use some MDX calculations to fix the data problems in Jira. However, in many cases, they could be issue-level calculations and could work slow. In any case, here are a couple of community posts on similar calculations in MDX:
However, if you have any data issues (incorrect status transitions or any other) you may find yourself in the place when you need to create custom complex calculations in eazyBI to get your reports working.