Hi,
For some time I am searching now, but cannot find if what I need is possible. I have this index with several fields that are aggregatable. I want to fill a table with these fields, one row per unique combination of fields. The events in ElasticSearch als have a duration time in the same event, so for these events I als want to have columns giving me the lowest duration, highest duration and average duration of this specific combination.
So let's say the events are as following:
request : url : device : duration(ms)
GET : /first/second/third : android : 20
GET : /first/second/fourth : android : 20
GET : /first/second/third : android : 31
GET : /first/second/third : android : 33
GET : /first/second/third : ios : 20
GET : /first/second/fourth : ios : 30
GET : /first/second/third : ios : 30
POST : /first/second/third : android : 20
POST : /first/second/fourth : android : 20
POST : /first/second/third : android : 31
POST : /first/second/third : android : 33
POST : /first/second/third : ios : 20
POST : /first/second/fourth : ios : 30
POST : /first/second/third : ios : 30
Then I want a table back with:
Nr. of occurrances: Call : min. dur. : avg. dur. : max. dur.
3 : GET /first/second/third/android : 20 : 28 : 33
1 : GET /first/second/fourth/android : 20 : 20 : 20
2 : GET /first/second/third/ios : 20 : 25 : 30
1 : GET /first/second/fourth/ios : 30 : 30 : 30
3 : POST /first/second/third/android : 20 : 28 : 33
1 : POST /first/second/fourth/android : 20 : 20 : 20
2 : POST /first/second/third/ios : 20 : 25 : 30
1 : POST /first/second/fourth/ios : 30 : 30 : 30
I know there are more questions like these on the forum, but since most of these are quite old I'm hoping on newer insights.