Hi! I’m using Influx 1.7.0 with Chronograf to use the flux editor.
My goal is to display a graph similar to the below in Grafana. This graph (I think), needs transforming beyond InfluxQL’s abilities. A heatmap comes close but is not quite right. Hence: use Flux.
The data are values (0-4 on the y-axis) across many days (one per line in the graph), with hour-of-day on the x-axis. The original timeseries data is just a single measurement. In pyplot, Excel, etc, a “Pivot” is used to produce a dataset as follows:
I’m here with the flux query. I think the rowKey should be “time-of-day” and the columnKey “day” or similar.
|> filter(fn: ® => r._measurement == “Net” and (r._field == “value”))
- How do I use pivot() to perform this query? (Or something else)
- Once that’s done, what’s the best approach to graphing this in grafana? (Perhaps this is a question for elsewhere.)