Histograms over day-of-week, month-of-year, day-in-month.

[brolund]

I'd like to be able to plot a histogram over e.g nr of requests per day-of-week (Mon, Tue, ...), summarized over the selected period.

Creating such histograms is possible if I have the x-axis defined in another field (like plotting response bytes against response time).

My request is that Kibana pulls the data for the x-axis from the timestamp.

I could probably solve this in e.g. Logstash by adding a field or tag for day-of-week, day-of-month and month-of-year, but it would be more elegant to have it in Kibana.

One possibility is that this feature is already available, but I have searched for all the terms I could come up with, and read the docs that I found relevant, to no avail.

[slothbag]

I'd be particularly interested in month-of-year and quarter-of-year also..

It looked like a month interval was considered but then removed, see #609

[qraynaud]

I don't know if Elasticsearch can even express this... I believe this is very missing.

[rashidkpc]

Elasticsearch can do it, but it requires scripting. We're working on a better, safer, scripting model that might make this possible, but unfortunately storing another field is the only good way todo it right now.

[qraynaud]

Yeah, I knew this was possible to do it using scripting. I found this bug looking for a way to do it without. I opened elastic/elasticsearch#6408 to provide a good semantic to express this without using scripts.

[koocotte]

This look very interesting.

I would also like to plot a serie in an interval and it's max/mean/min on the past. It will probably not fit in the histogram panel as designed today.

This would allow to see if I have more/less requests on this monday that on previous mondays, of this day/week/month/year comparing to previous.

The trends panel is interesting, but does not work well with the histogram panel and does not display series.

[rashidkpc]

As elasticsearch has made scripts safer we've created a kibana roadmap item for creating scripted fields. I'm going to close this ticket since we have an open scripted fields ticket: #1537