I have a question, i get some data from the solar pannel which i cant change the format of into my influxdb. Here is an example, to test i was trying only with 1 Datapoint:
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] =~ /plenticore.0.forecast.day1.power.9h.(power|time)$/)
|> filter(fn: (r) => r[“_field”] == “value”)
|> aggregateWindow(every: 24h, fn: last)
|> yield(name: “forecast”)
response:Object results:Object B:Object frames:Array 0:Object schema:Object data:Object values:Array 0:Array 1:Array[3460.0666666666666] 1:Object schema:Object data:Object values:Array 0:Array 1:Array refId:"B"
So basicly as you can see i have a structure
Now what i would like to do is draw the …power.9h.power.value in a graph with …power.9h.time.value as timestamp to display it at the rigth time in the graph.
In the end i need to have points/bars spaced by 1h, each with hes power value.
I use Grafana 8.4.3 with influxdb 2.0 flux syntax
Anyone got a solution, or perhaps an other aproach to get those values displayed?