Hi, I'm working on a case where we're analyzing activity time by users, by leveraging source - target.
Looking at the simplified example below, I want to show that John has been working for 1 hr while Paul worked for 4.5 hrs. This works fine, however I'd also like to show the number of activities they have performed in the same table. As John only has one SOURCE activity (Activity 1, as Activity 2 is the last activity of the case and is therefore not connected to a TARGET activity), it appears if he only performed 1 task while Paul performed 2.
The intended output is as shown below, with SOURCE(Name) as dimension
Is it possible to adjust the SOURCE config to include Activity 4 in Johns activity count? Or is there any other approach to get this done? Note that the actual throughput time calculation is rather complex (taking various attributes like user activity type into account), so SOURCE/TARGET seems to be the only way to calculate the right duration. Thanks in advance!
