I have some data collected at regular intervals, and I can’t work out how to graph them as time-of-day. For example I want to look at a week’s worth of data and have all the values for 09:00 averaged to a single value for 9:00, all the 9:01 values from each day averaged to a single 9:01 value, and so on, resulting in a graph with no dates but showing times from 00:00 to 23:59 on the X-axis.
From this I hope to be able to see intra-day trends like (for example) at 9am the values start to increase, and at 5pm they decrease, so I can average a week or more’s data to see what times of the day different behaviour is more or less likely to happen.
When looking at the InfluxQL query functions I can only see how to group by time intervals, whereas I really want to take the timestamp, drop the date, and just look at the hour/minute component when doing the grouping. Sort of like “GROUP BY drop_date(time(1m))” if there was such a thing as drop_date().
How can I achieve this?