i’m looking for a report which shows how many tickets did pass the condition. f.ex. if a issue was in the status longer than 2 Days then the goal is not reached.
I already build the Status age:
–set of issues having been in at least one of the selected statuses
[Measures].[Transitions from status issues count]>0
–for each issue, days spent in the selected statuses
[Measures].[Days in transition status] *24 *60
and try with this one addiotional Meassure
[Measures].[Median Status Age] < 2880 THEN “Reached”
[Measures].[Median Status Age] >= 2880 THEN “Not Reached”
But i need to filter out the status.
Open Status 2 Days
Classification 1 week
and so one.
I would like to show this in a gauge. How many tickets in the certain status passed and how many not.