I need to create an eazyBI Measure which allows me to calculate the total time to resolution for incidents of a certain priority. I am happy with most of this, but cannot see how to capture the 'running time' of an incident.(How long an incident actually took to resolve.
To create my Measure I have coded this;
Sum(Filter(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
StrComp([Measures].[Issue priority], "Highest") = 0),
DateInPeriod([Issue].CurrentMember.get('Created at'),
[Time].CurrentHierarchyMember)),
7
))
The 'random looking' 7 is there to make the Measure complete. This needs to be the resolution duration of the incident.
Can someone please give me a steer on how to find this data.
Thanks
(eazyBI newbie, so treat me gently :-))