I want to display a custom timestamp of the oldest entry in a database table.
Therefore, I repeatedly query the database and get the oldest creation timestamp.
I then push it as a custom value to New Relic. In my dashboard I want to display the oldest value from the database. Meaning if there are no values anymore in table I report my custom timestamp as null (or do the event without the attribute) to New Relic and in the dashboard I want to see the “No values” result or something similar.
I start on that using the
latest function but that returns of course the latest existing value from my custom metrics.
Is there a way to get the value of the latest entry of my custom metrics even if that has no value in it?
Thanks and best regards!