I have a log in ElasticSearch with these fields: response-time, uri, path.
I need to calculate average response-time and group by on substring (uri,path), showing in a table panel.
substring (uri,path) is always /example/test so the response-time values must be used to calculate average value of /example/test record.
I try with group by Terms but I can put only exactly field names…
Can anyone help me?