Hello,
I have a list report that tracks time in status. We are using it to record time in spent waiting to triage, so the time in status "Triage" is the time spent waiting to triage. The report works great except for one logical flaw. We also have our workflow setup so that when a jira moves to another team, either by being moved to another project or to another component, we reset the jira to status triage, since it represents the workflow that a bug needs to be triaged again. Some teams do not like this for the AIO report that we have built to track time spent waiting to triage, since that results in the time spent waiting to triage for all teams, not the team to which the bug currently belongs.
So the remedy would be to have the report track the most recent History Status of triage, but how do I setup my filter to do that?
The Report looks like this: https://www.dropbox.com/s/4ozrhwimb77ta6p/Screenshot%202020-06-15%2013.53.19.png?dl=0
The calculated field that's used to group them by the 1 day SLA is described here: https://www.dropbox.com/s/1gw8lk1os6ppcg8/Screenshot%202020-06-15%2013.54.08.png?dl=0
But the filter on History Status groups together all instances of the jira having been in the History Status so that it measures it that way. This results in a jiras that show up as being in Triage state for a long time, like 5 days or so, but that's because it was in the "Triage" status multiple times. The one I want to have the option to measure is only the most recent one.
Is there a way to have it only return a line in the filter, if it's the most recent instance of having been in the History Status?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.