I wanted to follow up on this, as the original reply did get me on the correct path. It took me a while to figure out I could click the pencil icon and enter in a direct SQL query. Once I got past that, the syntax didn’t exactly work for my v1 database, but the following is one of the queries I used for the finished dashboard.
SELECT count(rtt_ms) AS count
FROM ping
WHERE time > now() - 60m AND timeout = false;
Thank you Anaisdg!