Average number of records over hour of day, day of week and month of year

[shantanuchalla]

I want to generate a visualization which shows average no. of records generated over different hours of the day across days or average no. of records on a monday or any day of the week. Similarly for average no. of records in a month over the years.
i have been able to get the total count but not the average number of records.
My data has timestamp, Type of Record, host and user id

I have tried manually loading data for each hour, day and month using a different index. But, then I couldn't apply filters to get a better understanding of the visualization.

is there any method where I can generate such graphs or is it there some way that I load data to achieve this?

[ppisljar (Peter Pisljar)]

I am not sure i fully understand your question. Lets just go for the first use case you mentioned. You want to generate a bar chart for example, where each bar represents one hour of your data. so you want 24 bars (one for each hour of day) where the value is actually average count for that hour over a whole month of data for example ?
so lets say that today at 10' there was 50 documents and yesterday at 10' there were 30 documents ... you would want to show value 40 there ?

[shantanuchalla]

@ppisljar
Exactly the scenario!
And it would be better if it could pick up the period of time from the time picker as other visualizations pick up

[ppisljar (Peter Pisljar)]

I dont think this is currently possible but should be with nested type aggregations