Pulling most recent writes for two different databases with separate timestamps


I currently have two separate programs writing values to two separate databases for multiple servers. I’d like to make a single table panel in Grafana that displays the most recent database writes for each server.

db1 and db2 look something like
timestamp server val

I’d like my Grafana table to look like this:
server-a val1 val2
server-b val1 val2
server-c val1 val2

However, since the databases are written to by different programs at different times, they have different timestamps, and I can’t seem to find a way to store my most recent values for each server on the same row. Any suggestions?


First, what datasource are you using?