Show table data as time series


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?

You can’t as all you have is NOW() and NOW() is always now and not past :wink:
Do you have any other date time values in this table.