Average number of logs

[sachinbal]

Hi,

Can anyone please help me create such a visualization report in kibana. I want to find out the average number of logs generated by the system per hour per day in a week. I am attaching an image of the report which I need.

The column on the left is the hourly breakup of time from 8 am to 9 pm. The remaining columns correspond to weekdays.

Thanks
Sachin

[christophilus (Chris Davies)]

It would be tricky to get it to lay out exactly like that, but you should be able to get the data you want. You might be able to accomplish that layout using scripted fields. You can also export data from any visualization, so as long as you get the data you want, you can export it to CSV by clicking the "formatted" link when viewing the visualization.

To get the data you are looking for, you need to do an average aggregation, combined with an hourly date histogram. Here's an example:

So, it simply lists out the date + time along with the average.