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.
Daina / support@eazybi.com