We’re trying to monitor the rate of reopened/closed Jiras using the EazyBI integration for Jira.
One major issue is that quite often, people close a jria in the wrong resolution, which leads to the same jira being reopened, in order to adjust the resolution (e.g. Closed as Fixed -> Reopened -> Closed as Won’t Fix).
So, to be more accurate we’re trying to find a way to exclude those tickets from the EazyBI report.
To do that, we tried to use the “Resolution” as a “Page”, and filter out the invalid tickets (e.g. won’t fix, invalid, duplicate, etc…), and only keeping the “Unresolved” and “Fixed”.
But it seems the EazyBI “Page” uses the Resolution at the time the ticket Status was changed, and not the final (current) resolution of the ticket.
How could we force the Page to use the current Resolution? Alternatively, is there a better way to achieve our goal?