I am working with influxDB and wanted to plot the difference between now() and the last timestamp of my measurement on a status panel in Grafana. I understand that if I implement a table it shows the timestamps, but I cant have an operation between the last timestamp and the actual current time.
It’s possible to use the now() function with some arithmetic operation in the where clause, but can it be used in the select statement itself, somehow to show something like now()-last_timestamp ?