I am quite new to EazyBi.
Where is my mistake? - I don’t get it
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)
[Measures].[Issues created] > 0 AND
[Measures].[Issue due date],
) > 0 AND
[Measures].[Issue start date],
) < 0