Sort field Using Kibana

Elastic Stack Kibana
1

Hi

I was wondering how to go about sorting one field wrt another field. Suppose we have two fields in our object.
eg.
1 {
id: x1
val : 3 }
2{
id: x2
val : 4 }
Can we sort id's as x2,x1 (wrt val in this scenario) in kibana?

Thanks.

2

Sure, just add both to a data table and search by either header from there

Screen Shot 2015-07-20 at 3.37.10 PM.png2068×1002 137 KB

3

Thanks it worked !

4

Also if i want metric but by a query in elasticsearch , how would i go about it.

I tried following query but it's throwing an error.

GET /index/table/_search/
{
"sort": [
{
"x1": {"order" : "asc"}
}
],
"query": {
"term": { "id" }
},
}

Thanks in advance

5

All aggregations and sorting are configured via the visual builder in the UI. The search bar can accept query DSL for the purposes of filtering the documents, but only the query/filter part of the DSL.

Check out this thread for such an example: Where to add a missing filter in this Kibana search

6

Thanks. Currently i want to port either the dashboard completely to my website or get the metric table data from the elasticsearch via query , aggregation (I am not sure which needs to be used), so i can use it.

Thanks again for the patience and help. :blush: