Hallo fellow Users.
I would like to know how i can get the Time difference from the "First" to the"Last" Document within a specific Time Range.
Question: How much distance did i travel in a specific Time Range.
Situation (Aviation Data) :
Dokument has @Timestamp, Speed, and Altitude, Location
I want to know the covered
Distance = Average Speed * Time interval (e.g. last 5 hours).
Displayed in the Dashboard and Canvas via a Visualisation would be appreciated
Data is ingested via Filebeat into Elastic Cloud Service.
(Max.@Timerange - Min.@Timestamp) * Avergage Speed
but How =)
Thanks in advance!