elastic / elastic/roadmap

Top metrics/ first and last aggs in ES|QL

Open
#47 0 comments 0 reactions 1 assignee Assigned to @tylerperk View on GitHub
Component: Elasticsearch Component: Kibana temp:removal-candidate
Dominant language
No language data
Stars
6
Forks
1
PR merge metrics
No merged PRs in 30d

Description

**Value Proposition**

ES|QL lacks First/Last aggregation functions that are commonly used in observability and security use-cases in order to emit the first/last observed metric value within a time window. This is most commonly based on a timestamp ordering but it can also be useful to get the first document based on another criteria, such as a numerical size/salary/length/distance etc.

**Expected Outcomes**

First and last functions to return the earliest or latest value of a field, respectively, when no sort criteria is provided (default to @timestamp). Optional sort criteria which could be a numeric field

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.