I'd like to better understand the actual manual work involved by executing a certain activity. In my company, there are activities that are executed as "batch jobs". This means that we can execute the same activity across several line items. In this case, even though it only required one manual execution, it's counted as one across several line items adding up to several "manual" activities. To find a better estimate of the actual manual effort for each activity, I'd like to group them by user name, event time, and activity name.

Can anyone help me crack this nut?

Thank you in advance for your help!