Hi seems I’ve stuck calculating simple to the first look thing. In our Jira we have 3 statuses that we treat as a “Closed” statuses in Eazy BI: Closed, Awaiting Deployment and Done.
I need to calculate 2 metrics:
Days from Created to Resolved(to first of 3 statuses, because sometimes issues are moved directly to Done or Closed avoiding Awaiting deployment) and days from Created to Done. Also I need this metrics to be spread over time and priorities. As a result I want to get smth like this:
What goes wrong:
For average resolution days
- I’ve checked the data and report looks correctly except minor thing:
1.1 If the issue was resolved in previous time period(e.g. January), then reopened and then resolved again in February it won’t appear in selection, which - For Built-in “Average closing days” it simply doesn’t work:
2.1 Since I’m treating 3 statuses as closed all of them are in final selection which is expected, but not what I need
2.2 For the same reason I can’t use property “Closed at”(I’m interested in 2 statuses - “Closed” and “Done”)
I’ve tried solutions from here:
https://eazybi.com/accounts/1000/cubes/Issues/reports/50084-average-age-till-resolution-report
and here
which seem to be doing what I need with minor changes, but both of them are exceeding 60 seconds timeout.
My question is: how can I build the reports I need or optimize already suggested solutions?