How can I get my alias to just be “Air Pump” instead of “Flows.Air Pump” ? The picture above better shows what I am trying to do.
What you have works ok for me (I don’t see measurement.column), though I am using avg(column). I am using Influx, though whether that makes a difference I don’t know.
So my equivalent query is
SELECT $__timeGroupAlias(measured_at,$__interval), avg(t_greenhouse) AS "t_greenhouse", avg(t_external) AS "t_external" FROM samples WHERE $__timeFilter(measured_at) GROUP BY 1 ORDER BY $__timeGroup(measured_at,$__interval)
I was able to solve this problem by adding $col to the “ALIAS BY” field
Just to clarify, what SQL have you ended up with?
I am using InfluxQL.