Hi, (running grafana v7.0.3)
I have data, every 2 minutes of “% disk busy” for a few HDDs, going into Whisper DB.
(link pastebin of raw data exported as csv:)
(0% = idle 100%= full load)
Im trying to get a heatmap (or histogram) that shows me which hours of the day, on average, have the most activity , across a 30d timeframe (30days for example).
A visualization similar to this is what im aiming for:
(ie this would help me answer, at 6am average disk busy is 9%, over the prior 30 days- so that would be a good time to run a disk intensive cron job)
Everything i find on the web about this uses functions from InfluxDB or Promethius, however im using WhisperDB , so is this not possible in my case?
(i thought that Summarize() or maybe Timestack() + avgseries could do it for me, but it does not appear to)
any ideas on how i can get this? (or is this even possible w grafana + whisperDB as the datasource?) thanks!