Unable to sort by percentile in aggregation widget

[miwent]

When attempting to sort an aggregation by a percentile metric the sort tile disappears.

Expected Behavior

Able to sort by percentile

Current Behavior

The sort widget disappears when attempting to preview/update the aggregation widget. No error appears in the server log and there is no obvious (to me) error in the developer tools.

Possible Solution

Steps to Reproduce (for bugs)

1. Create an aggregation widget grouping by a numeric field (any type of visualization)
2. Add a metric for "percentile" and select any number
3. Add a sort for the percentile field, any order
4. Click either "Update Preview" or "Update Widget"
5. In either case, the sort by percentile option is removed

Context

Your Environment

• Graylog Version: 5.1.5
• Java Version: 17.0.8.1
• OpenSearch Version: 1.3.6
• MongoDB Version: 5.0.19
• Operating System: Ubuntu 20.04.6 LTS
• Browser version: Firefox 117.0

[luk-kaminski]

After quick recon, it seems it may be a FE issue, BE receives search with empty sort:

(...)
"series":[{"id":"percentile(ticks,95)","type":"percentile","field":"ticks","percentile":"95"}],
"rollup":true,
"row_groups":[{"type":"values","fields":["action"],"limit":15}],
"type":"pivot",
"id":"b5d3a37e-c95c-48fb-95f8-559aa9a1fbaa",
"filters":[],
"column_groups":[],
"sort":[]
(...)