How to build a histogram of the dependence of activity on the hour in a day?

Question

Monitoring

There is a metric (current user activity) which I drop in influxdb and view in grafane.
Naturally, there are daily fluctuations in it - at lunchtime, activity increases, by 2 am - it decreases.
I would like to add a histogram of the dependence of activity on the time of day, averaged over the last N days.
Is it possible to do this only from the influxdb + grafana bundle?
So far, the only thing I could do was to periodically build this histogram in the sql database by a third-party agent and display it as X-Axes / Series

Answer 1

Found the answer: Influx itself says it's not possible - They have a feature request for this:
https://github.com/influxdata/influxdb/issues/6723
If there is a time-series-db that allows this - please throw in options, for the sake of such a feature, they are ready to move.