How to find overlapping datetime for two different entries | Help and How-To

RobertToumbs · 2024-08-14T18:26:07.123000Z

Hello, I am using a product that is built off of sisense and need to build a script so that I can create a custom function or script that will show all over lapping entries. Below is a sample row from the data I am working with. Incident NumberDispatched TimeCleared Time Unit Number 2024-100008/14/2024 07:0008/14/2024 10:00 M66 2024-100108/14/2024 09:30 08/14/2024 12:00 M68 In this case I am hoping to return the data in one dashboard and a count of total number of overlapping incidents based on these two values in the data.In this example there was a second incident that occurred and the first was still in progress. If this was the only overlapping call it should return a count of 1 and the above table. The table columns are already in the dashboard but show all incidents.

MoreDiscussions

How to find overlapping datetime for two different entries | Help and How-To | Sisense Community