Incident mapping on timeline

Questions & Answers
, ,
1

Hey there,
I’m currently trying to map onto a timeline when an incident happened.
The report is based on weeks, so I would need something similar to the Version Report here.

I’ve tried to map it, but it seems I’m getting something wrong on the leveling aspect, as I do not get a similar result and only see the word ‘Incident’ visible when adding the Issue dimension.

Please find the measure formular below:

Generate(Filter( 
  [Issue Type].[Incident],
  IIF (
  DateInPeriod(
    [Issue].CurrentMember.Get('Started at'),
      [Time].CurrentHierarchyMember
    ) , 
    ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]) ,0) > 0),
  -- show incident key
  [Issue Type].[Incident].Name,
  ', '
)

Cheers, Felix

2

I figured it out after some research.

It all depends on the same level and dimension. I mixed Issue Type dimension and Issue dimension. By using [Issue] it seems to expected the issue dimension in the report.

I’ve changed it to:

Generate(Filter( 
  [Issue].[Issue].Members,
  IIF (
  DateInPeriod(
    [Issue].CurrentMember.Get('Started at'),
      [Time].CurrentHierarchyMember
    ) , 
    ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]) ,0) > 0),
  -- show incident key
  [Measures].[Issue key],
  ', '
)

and it works as expected.

Still happy for some Tipps, Tricks or recommendations :slight_smile:

Cheers,
Felix

3

Related to that is there a way to show only the count of the Incident happened?

Currently it shows for each Set the Incident Name, and what would be amazing is to show the count during that period. Can somebody advise how to do that?

4

Hi, @felix.geelhaar

Welcome back to the eazyBI community. It’s nice to see you succeed.

In future, please use the Descendants() instead of [Issue].[Issue].Members

Please consider using a tuple to calculate the number of incidents that started during the period.

Please import the field “Started at” in the eazyBI as a measure. The new measure “Issues with Started at” will be created.

Use the created measure together with the Issue Type dimension in the tuple: Tuple

([Mesures][Issues with Started at],
[Issue Type].[Incident])

Please use auto-complete to write the tuple and use the right measures and dimensions’ members.

Kindly,
Ilze

1 Like
5

Thank you @ilze.mezite. Great insights and tips. Appreciate it :pray: