Kibana: No "auto" choice for Interval

[timmolter]

In another dataset where logstash pushed data to ES, I can create visualizations with the "auto" interval, but with another dataset where i push data via the Java API, "auto" is not in the dropdown box. See screeny.

The Java code I'm using to push data is:

  IndexResponse response = transportClient.prepareIndex("foo", "bar", ("" + timestamp)).setSource( jsonBuilder()
      .startObject()
      .field("@timestamp", isoDateFormat.format(new Date(timestamp)))
      .field("url", "blah")
      .endObject()
      ).execute().actionGet();

[rashidkpc]

Auto is not supported for non-time based indices.

[timmolter]

In settings (in Kibana), it says my @timestamp field is of type "date". In my logstash generated dataset it says my @timestamp field is of type "date" also, but it also shows a little time icon next to the field name. Do you know how I can get Kibana to recognize my field as a time too? It sees it as a Date. What else needs to be configured or changed?

[timmolter]

I figured it out after hours of frustration. Refreshing the field list in settings is not sufficient. You need to first delete the index in Kibana and re-add it, where it lets you pick the timestamp field. Afterwards the little time icon shows up and "auto" shows up in the dropdown list.