Event Store Database Analysis

[yogeshmaney]

I have an event store single database, and I want to study the Time motion study of triggered events like task assigned, the task started, task finished, etc. Any cues on how it can be done?

[v-yalanwu-msft]

Hi, @yogeshmaney ;

I'm sorry I didn't understand what you meant, can you share the sample data you want the output to be combined with? And its logic?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yogeshmaney]

How can we calculate efforts by each individual? like How much time has been taken to start a task. How much time was taken to complete the task etc? Data sample attached below

[yogeshmaney]

Attaching the sample data. How can we calculate efforts by each individual?

Sr	Task ID	Event Summary	Date Created
110010	101010	Task Created by X	21-10-2022 17:58
110011	101010	Task Assigned to A	22-10-2022 18:53
110012	101010	Task Started by A	23-10-2022 17:53
110013	101010	Task Paused by A	24-10-2022 17:53
110014	101010	Task Assigned to B	25-10-2022 17:33
110015	101010	Task Started by B	25-10-2022 20:33
110016	101010	Task Finished by B	26-10-2022 17:33