Count number of parallel tickets in given time interval

Hi,

I am quite new to EazyBi.
Where is my mistake? - I don’t get it :slight_smile:

I would like to count parallel user Stories in a given time interval to measure the workload of a specific assignee. (In our project we don’'t use 'time spend/ worklog/ … - 1 task equals one resource,). As a report I like to use a line chart or time chart to see the parallel tasks of a specific assignee (in the best case multiple at once)

  • As page I use ‘Assignee’
  • As Row I use Time (weekly)
  • As column I created the measure below

My approach is to count all User Stories whose

  • Start Date is smaller than [Time].CurrentHierarchyMember.NextStartDate AND
  • Due Date is larger than CurrentHierarchyMember.StartDate

to catch all events where the person is ‘busy’ in the given time interval.

I receive some numbers, but they are not right. Additionally the result is super slow and a timeout occurs when using time intervalls < ~1week.
(~2000 user stories in total)

NonZero(
Sum(
Filter(
[Issue].[Issue].Members,
[Measures].[Issues created] > 0 AND
DateCompare(
[Measures].[Issue due date],
[Time].CurrentHierarchyMember.StartDate
) > 0 AND
DateCompare(
[Measures].[Issue start date],
[Time].CurrentHierarchyMember.NextStartDate
) < 0
),
[Measures].[Issues created]
)
)

Kind regards,
Fabian