Hello,
I have a series of events with a JoinTime field and a LeaveTime field. Each of these events essentially represents the duration of time that a video call was in progress.
I want to do a line graph that represents the total number of calls that were simultaneously in progress over a 24 hour time period with a span of one hour.
So, essentially, I need to create a search that looks at an event and evaluates whether it was in progress at a time of, for example, 2:00 pm and add that to the total number of other events where active at that time. Then do the same for 3:00 pm, 4:00 pm, etc, etc.
Finally, towards the end of the time period, there will be some events that have no value for LeaveTime. Those are active calls and need to be added to the sum for that time period, but don’t necessarily fit into the same logic as the calls that have a specific end time
Any help that the community has is greatly appreciated.
Thanks!
... View more