ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: How to find overlapping datetime for two different entries 10K rows would be the upper limit. I doubt it would be that high but thinking in longevity. Never more than 96 hours overlapping I have complete access including designer. I am in charge of making changes to our model Re: How to find overlapping datetime for two different entries ESO who uses sisense has basically said that this is not a priority and won't assign a specific analyst to help with the issue. This is an issue that their whole platform has and they are working towards backing it possible. ESO doesn't seem to reach out other than via email and won't escalate my issue to a developer. I'm looking for work arounds which they suggested I reach out on a community board on sisense. Re: How to find overlapping datetime for two different entries I'm using a product called ESO (EHR/Fire incidents) it uses sisense for its reporting software. I work for the fire department and am trying to pull back data. ESO states that it is not currently possible to show overlapping time data. How to find overlapping datetime for two different entries 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 Number Dispatched Time Cleared Time Unit Number 2024-1000 08/14/2024 07:00 08/14/2024 10:00 M66 2024-1001 08/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.