I wan’t to visualize the record_nr in a Grafana-graph, but only those from the last sequence.
So the query has to use the results of another query like this:
SELECT record_nr FROM “measurement” WHERE sequence = (SELECT last(“sequence”) FROM “measurement”);
Thanks, now I get a result, but only the last row. I need to have all rows with sequence = 1…
The challenge is to have two graphs in Grafana, one graph with all record numbers and one graph only with the record numbers of the last sequence