Kibana Data Table Date Histogram Aggregation Useless labels

Elastic Stack Kibana
1

image

So when I add the following split table aggregation to my data, instead of giving me the month name for my labels, it gives me the milliseconds for the timestamp. I also don't see a way to edit it.

Here's what it looks like:
image

Obviously, a label like that won't really do for a dashboard.

How can I format the label so it's MM-YYYY?

2

Hi,

You can use Kibana field formatters on your dateKey: https://www.elastic.co/guide/en/kibana/current/field-formatters-date.html

That should help.

Thanks,
Bhavya

3

Hi,

I'm having the same issue. After setting up a date histogram, daily, and getting the ouput I get the titile formatted as "millis:Label".

I have setted up the date format for that field in Kibana Index Pattern configuration as "DD/MM/YYYY" getting at the example output the expected value, but it seems that this configuration isn't enought for Data Table visualization.

Can you provide me one solution please?

Greetings,
Javi.

4

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