I’m trying to query an amount of servers every day to show the change in the amount.
These tables however do not have a timestamp.
I was able to insert the current time with NOW() as time_sec.
This is my SQL:
select NOW(), count(object_uuid) from idam_contracts
where purge_done = false
purge_requested_at is not null
If I plot this as a time series however I can only see the current data point.
It looks like this:
How can I make Grafana remeber all the past datapoints to plot as a line?