I would like to show in a singlestat panel the sum, at a certain time, starting from a certain date of a value from an influxdb database.
Something like:
SELECT sum(“thevalue”) FROM “thedata” WHERE Time=‘22:00:00’ and date > ‘01/01/2000’
Any idea how to achieve this?