Kibana AVG last hour

[User_2_Guest_Incomin (JoelIncoming)]

Hi there,

I'm trying to create a line chart that shows the average of field1(number field) in the last hour but showing an interval in minutes from field2 (date field), when I try to do with "Date Histogram", field2, interval minutes and using a search of the last 60 minutes it gives me this war:

Then I think it's because it would have 60 buckets and they don't fit, i tried to make a custom interval of 30m for example, and same war apear. It doesn't have any sense for me, I understand if I have a search of the last 60 min, and make a custom interval of 30 minutes like this:

it should work right?

I want something like this:

But X-Axis every minute in the last hour, or 5 min interval and I'm giving up

[Bill_McConaghy]

I have attempted to make this work locally and have not had any luck locally. What are you trying to use this visualization for? Seems like moving average with 1 minute buckets might give you what you are looking for.

[User_2_Guest_Incomin (JoelIncoming)]

Ye, I tried to do so, but it didn't work like my boss wanted . Anyway today after few hours we found the problem. When we creat the index on kibana, we select time filter (@timestamp), and that filter works over ALL the others, so finally we decided to creat them without time filter and everything works now with this conf:

Thank for your reply!

BTW, ELK it's and amazing tool. Keep the good work!

[Bill_McConaghy]

Glad you got things working and glad you like the stack.