Table first time per day with value > 0

Hello folks!

Thanks for your time reading and trying to solve this!

I relatively new to Grafana - so, maybe this is a no-brainer, to you!

I have a datapoint “X”, which contains numeric data in an influx database. Each datapoint has a timestamp - how else could it be. :wink:

How can I create a table in Grafana containing the (date and) time of the first “X” with value > 0?

Thank you very much,

My naive guess: use FIRST function and WHERE value>0 condition.


Are you using influxQL or flux to do your queries?