Unresolved issues over time

Questions & Answers
, , , ,
1

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):

image
image397×787 8.63 KB

2

@Damian

You can try this formula when creating new calculated measure:

CASE WHEN
[Time].CurrentHierarchyMember.level.name = "Day"
THEN
Sum(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
IsEmpty([Issue].CurrentHierarchyMember.get('Resolved at'))
AND
Datediffworkdays(
DatewithoutTime([Issue].CurrentHierarchyMember.get('Created at')),
[Time].CurrentHierarchyMember.StartDate
)>2
),
(
[Measures].[Issues history],
[Transition Status.Category].[In progress]
)
)
END

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
3

thank you once again Martins