Find MaxN value (species count) per ID for overlapping time range.
Hi,
I am trying to find the maximum number of individuals observed in a single video frame.
I have roughly 3000 2min videos with 5000 observations recorded.
For a given ID, what is the greatest value of the sum of Count for a species (eg. DuCr & ShPe) when the same species has overlapping time_start and time_end
example data:
| ID | Species | Count | time_start | time_end |
| video_1 | DuCr | 1 | 12:00 | 12:01 |
| video_1 | ShPe | 1 | 12:00 | 12:01 |
| video_1 | Shpe | 1 | 12:05 | 12:06 |
| video_2 | DuCr | 1 | 12:00 | 12:01 |
| video_2 | ShPe | 1 | 12:00 | 12:01 |
| video_2 | Shpe | 1 | 12:00 | 12:01 |
The output should look like this:
| ID | DuCr | ShPe |
| video_1 | 1 | 1 |
| video_2 | 1 | 2 |
This is the most related discussion post I could find:
https://community.jmp.com/t5/Discussions/Finding-the-max-value-as-per-ID/m-p/52616#M29792
AnalyticsRe: Find MaxN value (species count) per ID for overlapping time range.This post might give some ideasOverlap / Count of periods at the same point of time .
One question, if time period is 12:00 - 12:01 and other one is 12:01 - 12:02 is that an overlap or not?
Re: Find MaxN value (species count) per ID for overlapping time range.Yes, the 12:01 would be the overlapping second.
Im just looking at the highest count for 1 second.
