Hi - I’m new to EazyBI and trying to report the average number days issues remain in a given status. So far I have been able to create a report very similar to this demo: https://eazybi.com/accounts/1000/cubes/Issues/reports/50046-history-of-unresolved-issue-statuses
However, I am running into an issue where some weeks show that it took an unusually long amount of time for issues to progress through statuses. This bug is due to an edge case in our data where some JIRA tickets go stale and are left in a given status and never closed. Periodically, we go through and clean up JIRA by closing all such issues.
The problem is, my report registers this cleanup as normal JIRA activity, and therefore shows these weeks as having a massive average amount of time spent in some statuses. In order to fix this, when I query issues eazyBI, I want to filter out issues that were in a transition status for more than 50 days.
Is there a way to write such a filter?