Using aliases with out measurement title?

1

removeprefix
removeprefix1890×672 76.4 KB

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.

2

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)
3

I was able to solve this problem by adding $col to the “ALIAS BY” field

4

Just to clarify, what SQL have you ended up with?

5

I am using InfluxQL.