How to convert keyword to integer in Kibana 5 using painless script?

Asked Oct 22 '17 at 08:11

Active Oct 22 '17 at 08:18

Viewed 918 times

I want to order Hour values in Ascending order in a bar chart of Kibana 5:

The problem is that the order is 0, 1, 10, 2, ... instead of 0, 1, 2, 3, .... The possible reason is that Hour is a keyword, not integer. In Elasticsearch I can see "Hour": "1", etc.

Is it possible to convert Hour values to integer on the fly in Kibana?

edited Oct 22 '17 at 08:18

asked Oct 22 '17 at 08:11

Dinosaurius

8,306
19
64
113

Converting data types on fly is not possible and that is not recommended too. You should fix your base( ES index) for it. – Hatim Stovewala Oct 22 '17 at 12:02
I found out that it's possible to create a scripted field like Integer.parseInt(doc["Hour"].value) – Dinosaurius Oct 22 '17 at 12:23
Yeah. Scripted fields of Kibana can be a choice but it would impact performance. Use it carefully. – Hatim Stovewala Oct 22 '17 at 12:39

How to convert keyword to integer in Kibana 5 using painless script?

0 Answers0