I have a site monitor that writes to an AWS Timestream database. I store the load times for all of the sites monitored in a single table, so when I do the query SELECT * FROM "<database>"."<table>"
I get:
SiteName measure_value::double measure_name time
site1.example 5.5 LoadTimeMS 2021-03-02 16:24
site2.example 5.3 LoadTimeMS 2021-03-02 16:24
site1.example 5.6 LoadTimeMS 2021-03-02 16:25
site2.example 5.2 LoadTimeMS 2021-03-02 16:25
What I’d like to do is have a panel in Grafana that displays this time series data labeled with the site name. I’d prefer to pull it from the SiteName field, but if that’s not possible, I can put it in manually. How do I do this?