Count "Time to resolution issues"

Questions & Answers
1

Our developer team has created a custom SLA Field as translation of the english field “Time to resolution issues”. The new name is “Lösungszeit Issues”

Now I´m trying to count all issues that are time to resolution relevant using also the Time Dimension (it should count only issues created in the chosen time period).

I´m using the following formula, but EazyBI keep showing Tickets created in different time periods.
What am I doing wrong?:

Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentHierarchyMember.Get(‘Created at’),
[Time].CurrentHierarchyMember
)
AND
(
[Measures].[Time to resolution Issues]=1 or [Measures].[Lösungszeit Issues]=1

)

), [Measures].[Issues created]

)

2

@AntonBDR

Try this formula to add context in your calculation

Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentHierarchyMember.Get('Created at'),
[Time].CurrentHierarchyMember
)
AND
[Measures].[Issues created]>0
AND
(
[Measures].[Time to resolution Issues]=1 
or 
[Measures].[Lösungszeit Issues]=1
)
)

)

Martins / eazyBI

3

Thanks @martins.vanags ,

somehow I still see Issues in the results that were not created in the selected Time Dimension.

When I select August 2021 as time frame, I see tickets that were created before.
I realized that all these tickets created in previous times, were updated in August 2021

image

Erstellt: Created / Aktualisiert: Updated / Erledigt: Resolved

Is there a connection between “created date” and “update date” ?

Thanks for your help!

4

Please reach out to eazyBI support and send the report definition in a text file.
The formula shouldn’t switch to “updated date” automatically.

Martins

5

Hi @martins.vanags ,

I think I´ve found where the problem is. This script works as desired:

Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentHierarchyMember.Get(‘Created at’),
[Time].CurrentHierarchyMember
)
AND
[Measures].[Issues created]>0
AND
(
[Measures].[Issue Time to resolution Breached]=“Breached”
or
[Measures].[Issue Time to resolution Breached]=“Not breached”
or
[Measures].[Issue Lösungszeit Breached]=“Breached”
or
[Measures].[Issue Lösungszeit Breached]=“Not breached”
)
)

)

It looks like the problem is to use [Measures].[Time to resolution Issues]=1 in combination with Time dimension.
Do you know why is like that?

Thanks for your help.

6

Hi
Time to resolution issues returns 1 for the issues in the time period where the issue reached the SLA (was resolved in this case).
It would make more sense to combine [Measures].[Time to resolution Issues]=1 with
[Measures].[Issues resolved]>0

I think you don’t need to use that filter in your formula.

Martins