No "ALIAS BY" when using flux?

[kyled]

Hello all.

I am trying to set an “ALIAS BY” using flux lang. However I do not see an option to do so. Is this option implemented yet? It is implemented if I use influxql, but the option is not available when I change the data source to flux.

Thanks to all who reply in advance.

[andig]

Same question here (https://github.com/grafana/influxdb-flux-datasource/issues/42).

I’ve tried using |> yield(name: "alias") but that didn’t help either.

[xsherlock]

Did you managed to solve that problem in some easy way?
I do have graphs of the same data soruce (solar energy) with time shifts where I compare Today, Yesterday and Same Day year ago. and the results look terible and confusing.

[jwblaney]

This is the only topic I’ve found on this issue and can’t tell if it’s been resolved.

Using influxDB Cloud/Flux query language trying to rename the results of queries to be human friendly on the legend. Is there a command/method for this available in grafana?

[amotl]

Hi there,

the comment at https://github.com/grafana/influxdb-flux-datasource/issues/42#issuecomment-532402207 outlines a solution to this.

With kind regards,
Andreas.

[mikevaneerd]

Hi there,

I used the display name function of grafana to define my own name:

${__field.name} ${__series.name} [${__field.labels.Eenheid}]

The result is shown below:

[zeger]

Nice!

  |> filter(fn: (r) => r["entity_id"] == "buffer_tap_water_in_temperature" or r["entity_id"] == "buffer_tap_water_out_temperature")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> map(fn: (r) => ({  r with name: r.entity_id }))

works perfectly with

${__field.labels.name}

[thomasdc]

can you explain how to use this?
I’ve tried using it but it is not working.

if have the following ‘querry’

from(bucket: “PowerMonitoring”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == “Current”)
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: “mean”)

this gives back 4 values ( I1, I2, I3, IAvg) in grafana
but i would like to have it renamed ‘I Line 1’, ‘I Line 2’, ‘I Line 3’ and ‘I Average’
What do I need to do?
I think Grafana should work out the possibility to rename where we can also change the colors of the values (i think ‘alias’ in flux is difficult since we have multiple values from one ‘querry’ )

[zeger]

Used this:

    from(bucket: "home_assistant")
      |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
      |> filter(fn: (r) => r["entity_id"] == "boiler_system_pressure" or r["entity_id"] == "auxiliary_water_pressure")
      |> filter(fn: (r) => r["_field"] == "value")
      |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: true)
      |> fill(usePrevious: true)
      |> map(fn: (r) =>  ({
        r with name:
          if r.entity_id == "auxiliary_water_pressure" then "Auxilary water pressure"
          else "Boiler system pressure"
        })
      )
      |> yield(name: "mean")

I really do not like the solution, however it is the only one I could come up with when there are multiple values in the same query.

Make sure to set the field value in Grafana to “${__field.labels.name}” - in order to make sure the name field is used as the label

[doctorneyney]

I’ve got a query that looks like:

from(bucket: "/primary-bucket")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._field == "completed_builds" or r._field == "avg_duration")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> cumulativeSum(columns: ["completed_builds", "avg_duration"])
|> map(fn: (r) => ({ r with avg_build: 
        if not exists r.avg_duration or r.completed_builds == 0.0 then 0.0
        else float(v: r.avg_duration) / float(v: r.completed_builds)
}))

and gives me a graph like this:

Each line is a _measurement. Is anyone familiar with a way to change the legend name to the _measurement it is representing. I tried the grafana name function method above, but no luck.

Thanks in advance!

[oscario]

Hi, anyone? Having the same issue here, using:

from(bucket: "test")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Voltages")
  |> filter(fn: (r) => r["Name"] == "Office")
  |> filter(fn: (r) => r["Device"] == "RPI")
  |> filter(fn: (r) => r["_field"] == "gauge")
  |> group()
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> map(fn: (r) => ({  r with name: r.Device }))
  |> yield(name: "mean")

Also having ${__field.labels.name} as “Display name” in my grafana (v7.5.6).
The legend shows: ${__field.labels.name} in stead of “RPI”

I can map like this:

map(fn: (r) => ({ r with name: “RPI” }))

which works (with using ${__field.labels.name} as "Display name"in grafana)

But I can have multiple devices and want to be flexibel with the legend names (“RPI-01”, “RPI-02”, etc…)

I’m getting the feeling this is not possible at the moment with flux.
Kind regards and thanks in advance too!
Oscar.

[oscario]

Oops, answered my own question:

from(bucket: “test”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == “Voltages”)
|> filter(fn: (r) => r[“Name”] == “Office”)
|> group(columns: [“Device”])
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: “mean”)
Works! (and no “Display name” needed in grafana)

[oscario]

Hi,

Maybe try:

group(columns: [“completed_builds”]) ?

Kind regards,
Oscar.