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],
[Time].CurrentHierarchy.DefaultMember
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.
Consider using Custom JavaScript code instead to fix the data. You can manipulate some historical data entries with JavaScript code, for example, removing some history entries, updating dates of historical entries, etc. Please check if the final history data flow is consistent and represent the correct data changes. Many measures in eazyBI rely on correct consistent historical data entries. With this approach, you will be able to use many default measures to get the best out of eazyBI.
Another option would be importing a new date custom field representing the last valid status change thus creating a new set of default measures. You can use calculated JavaScript custom field for this. You can use Javascript to go through issue historical entries and retrieve the first date of the status change and set it to some new custom field.