visState Kibana

Elastic Stack Kibana
1

Hello everyone!

I have datatable visualization and need multiply sort (two fields), also I need to get 15% of sorted results. Can I do this in visState, using elasticsearch sort, and how?

I tried to sort by the end of the request but It doesn't seem to work

"sort": [
{
"amount": {
"order": "desc"
},
"orders": {
"order": "desc"
}
}
],
"size": 150 ( for example, don't know how to write %)
Thx.

2

Not sure what you mean by 15% of the sorted results.

I don't believe there is a way to multiple columns in the aggregations for sorting. You might be able to accomplish what you're looking for with Scripted Fields.

https://www.elastic.co/guide/en/kibana/current/scripted-fields.html