I need help with an employee travel analysis report. I have an index containing information about employee office check-ins in various countries. Events have fields Employee, Time, Country For example John Doe, 2023-11-15T20:05:31.000+00:00, France ... John Doe, 2023-11-18T10:00:31.000+00:00, France ... John Doe, 2023-11-20T10:05:31.000+00:00, United States ... John Doe, 2023-11-25T20:05:31.000+00:00, United States At the end I would like to get the result showing duration in days between first checkin and last checkin per employee per country John Doe, 3d, France John Doe, 5d, United States
... View more