Sort option is not active in kibana

We are using ELK stack in our lab.

We have created 2 new fields by name “Certificate” (which contains certificate names) and “Days_Remaining”(which shows the number of days left for certificate expiry) using GROK filter and we are able to see it in Kibana Discover tab as expected.

Now we want them to put in a tabular format dashboard, hence we are very new to this ELK stack we are starting with a simple dashboard by just saving this search and open it in Visualize tab. We are able to see the data as expected but in random format so we need to sort this table in a descending order as per the field “Days_Remaining” (which shows the number of days left for certificate expiry).

Note : We have something called “sort” query in splunk but we are not finding it in Kibana.

If we mouse over the column header of this field “Days_Remaining” then we get only "Remove Column" and "Move Column to the right or left" options but no “Sort By” option. But we can see this option "sort by" UI popping out successfully for other fields which are created by default in kibana like @timestamp, event_id, beat_version, record number, _index etc...

So our question is how to enable this "sort by" UI on this field “Days_Remaining” which is manually created by us using grok filter. Please advise.

We'll likely have to change the mappings. Can you share how elasticsearch has the field mapped? We'll want it to be an integer or similar (not text).

Hi Jon, we are very very new to this ELK stack, can you please tell me where to check this option? Apologies for these kind of basic questions.

No problem!

If you click on the dev tools application on the left hand side, we can query elasticsearch directly:

GET winlogbeat*/_mappings

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.