Using Mysql, would like to display multiple values

1

Sorry if this is a stupid question, i could find anything relevant to my question. I’m trying to plot both the humidity and the temperature, right now I have no issues plotting only the humidity , how do I add the temperature to it. This is my query so far and the table

image.png1413×662 47.3 KB

thank you

2

You need to group by you get multiple different metrics in the metric column, or do a union query

3

Torkel,
Could you please be so nice to show me a quick example, I’m familiar with SQL but not understand how this would apply using the group by. Would I use the as value filed as well, I guess I’m confused.

On a different token, I’m discovering new great tools while I check stuff out, I like the table graph, nice done all.

When would you use the “A” and the “B” in the query builder?

Thanks