Search code examples
kibanakibana-4

Kibana shorten column name in data table

Is it possible to beautify this data table using advanced JSON or something?

Currently, I'm getting this back: My Kibana UI

Ideally, I'd like to get rid of everything else, except date, which is yyyy-MM-dd.

I've added this JSON to Advanced JSON Input:

{
  "format" : "yyyy-MM-dd"
}

It does work in backend side, results are brought back in this format. However - Kibana still displays them in its own manner.

Elasticsearch version - 2.0

Kibana version - 4.2

Solution

  • you can change the data format with kibana in the menu of the index. You go to the camp and select type date and the format. They allow multiple diferents format. As yyyy-mmmm that even display the name of the month.

    EDIT:

    The best option to dont change all the date is perhaps duplicate the date and only change the new data with the new format.

    PD: is awesome that with scripted field you can do doc['time].value and you can not change the type of the new field but Kibana change the value to miliseconds.