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?