Unresolved issues over time

Hello, I’m stuck with one report and I can’t find help on other similar topics here. I need to create a daily report showing:

  • how many all unresolved tickets were at the end of the day (issue history) - I have it done with the formula (name “All open”):

([Measures].[Issues history],
[Transition Status.Category].[In Progress])

  • how many unresolved tickets were at the end of the day more than 2 days (issue history) - Here I have a problem and I do not know how to do it, example: today 02.12 I want to see how many aged tickets (the date of creating the ticket is more than 2 days from today) is unresolved
    Second example: on 22.11 I want to see how many aged tickets were unresolved over 2 days (the date of creating the ticket is over 2 days from 22.11)
  • same as above but unresolved tickets over 8 days

it seems to me that I need Age interval for this but I try in this way and unfortunately it does not work:
([Measures].[All open],
[Age interval].[Aged more than 2 days])

aged more than 2 days looks like this:
[Age interval].[002 - 900]

I don’t know how to go about it, how to start it. Please help

Thank you

My table looks like this (over 2 days does not work properly):


You can try this formula when creating new calculated measure:

[Time].CurrentHierarchyMember.level.name = "Day"
IsEmpty([Issue].CurrentHierarchyMember.get('Resolved at'))
DatewithoutTime([Issue].CurrentHierarchyMember.get('Created at')),
[Measures].[Issues history],
[Transition Status.Category].[In progress]

It will count Issues history in In progress category at the end of each day with a condition that the issue was created more than 2 days before a particular day in the report.

Martins / eazyBI

1 Like

thank you once again Martins