Show table data as time series

[jonathan3c0e]

Hello,

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
and
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?

[yosiasz]

@jonathan3c0e

select NOW(), count(object_uuid) from idam_contracts
where purge_done = false
and
purge_requested_at is not null

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