# Kibana doesn't visualize logdate's field

**URL:** <https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536>\
**Category:** Kibana\
**Created:** [September 14, 2016, 6:27pm UTC](https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536 "2016-09-14T18:27:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![RdrgPorto](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rdrgporto/32/13278_2.png) [@RdrgPorto](https://discuss.elastic.co/u/RdrgPorto)\
**Post date:** [September 14, 2016, 6:27pm UTC](https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536/1 "2016-09-14T18:27:30Z")

</div>

Hi everyone,

I have a problem with **Logstash**. In this case is about _date's creation_. I create a new field (logdate) based on severals fields which I have created with **Grok**. I don't receive any "error parsing", however, when I go to my **Kibana** , I create a "histogram" from logdate's field and I don't see nothing.

 ![](https://us1.discourse-cdn.com/elastic/original/2X/0/04c34d9bc3a213661d499dcfbf964e068a0a2d13.png) ![](https://us1.discourse-cdn.com/elastic/original/2X/c/cccc00d47e1865908d1ff23976ab879a686f2306.png)

An example of logdate : 2011-04-19T03:44:01.103Z

 ![](https://us1.discourse-cdn.com/elastic/original/2X/a/a37fbe0dadc050b2d7ad205fcd6a1cdbe7f497b0.png)

> mutate{  
> add\_field =\> { "logdate" =\> "%{year}-%{month}-%{day}T%{hour}:%{minute}:%{second}.%{ms}Z" }  
> remove\_field =\> ["year", "month", "day", "hour", "minute", "second", "ms"]  
> }

Any idea? 🙂

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Alex\_6](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_6/32/1330_2.png) [@Alex\_6](https://discuss.elastic.co/u/Alex_6)\
**Post date:** [September 16, 2016, 10:57am UTC](https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536/2 "2016-09-16T10:57:10Z")

</div>

Well, it looks like a Kibana issue to me...? You seem to be getting the logdate dates through to Kibana just fine and they have the correct type.

One thing, the order of operations within a single mutate filter is not guaranteed, you should split yours into two to be safe:

```
mutate { add_field => { "logdate" => "%{year}-%{month}-%{day}T%{hour}:%{minute}:%{second}.%{ms}Z" } }
mutate { remove_field => ["year", "month", "day", "hour", "minute", "second", "ms"] }
```

---

<div class="post-metadata">

**Author:** ![RdrgPorto](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rdrgporto/32/13278_2.png) [@RdrgPorto](https://discuss.elastic.co/u/RdrgPorto)\
**Post date:** [September 16, 2016, 11:28am UTC](https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536/3 "2016-09-16T11:28:41Z")

</div>

Hi Alex,

I have changed this issue to Kibana. I have done the modification which you has suggested. The problem continues yet. 😔

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [September 16, 2016, 5:23pm UTC](https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536/4 "2016-09-16T17:23:48Z")

</div>

It looks like the data is being indexed correctly, so that's good.

I'm not sure I understand the issue entirely, but what I think you're saying is that you have a date field and you are trying to create a visualization using that field and a _histogram_ aggregation, and you're not seeing what you expect to see.

Have you tried using the _date histogram_ aggregation instead?

Also, if you can provide some more information about what you're trying to visualize, that would probably be helpful.

---

<div class="post-metadata">

**Author:** ![RdrgPorto](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rdrgporto/32/13278_2.png) [@RdrgPorto](https://discuss.elastic.co/u/RdrgPorto)\
**Post date:** [September 17, 2016, 9:04am UTC](https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536/5 "2016-09-17T09:04:37Z")

</div>

Hi Joe,

In **Kibana 4** , it looks like works fine if I choose an " **interval**". 🙂

 ![](https://us1.discourse-cdn.com/elastic/original/2X/0/0cd18e09a233d11ec2a55f6a123d6bd8f6588727.png)

What I did, it was deleting index and create a new **Dashboard**.

Thanks for all,

Regards

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:38pm UTC](https://discuss.elastic.co/t/kibana-doesnt-visualize-logdates-field/60536/6 "2017-07-06T13:38:47Z")

</div>


