# Need help setting alias

**URL:** https://community.influxdata.com/t/need-help-setting-alias/33445
**Category:** Fluxlang
**Created:** [March 5, 2024, 3:37pm UTC](https://community.influxdata.com/t/need-help-setting-alias/33445 "2024-03-05T15:37:58Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![morbiddk](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/morbiddk/32/15202_2.png) [@morbiddk](https://community.influxdata.com/u/morbiddk)
#### Post date: [March 5, 2024, 3:37pm UTC](https://community.influxdata.com/t/need-help-setting-alias/33445/1 "2024-03-05T15:37:58Z")

</div>

I’m upgrading my environment and replacing my old InfluxDB 1.8 with 2.7.3 and am learning there’s a good bit of a learning curve. I’ve got almost everything squared away, but am having an issue with a single field aliasing, all others are working just fine and I suspect its the math in the map function.

```auto
from(bucket: "sensors")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
  |> filter(fn: (r) => r["_field"] == "office_temperature")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> map(fn: (r) => ({ r with _value: float(v: r._value) *9.0/5.0 + 32.0, _field:"Temperature"}))
  |> yield(name: "mean")

```

Trying to simply rename the field variable to read Temperature but with this singular field it only renames a portion.  
 ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/6/6048cb81519d48acbe96b24571e4094000e33ced.png)

Any help would be appreciated.

---

<div class="post-metadata">

### Author: ![morbiddk](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/morbiddk/32/15202_2.png) [@morbiddk](https://community.influxdata.com/u/morbiddk)
#### Post date: [March 11, 2024, 8:30pm UTC](https://community.influxdata.com/t/need-help-setting-alias/33445/2 "2024-03-11T20:30:00Z")

</div>

For the time being I’m using an override, but would be nice if I could directly alias within the query as I’m not a big fan of overrides.

---

<div class="post-metadata">

### Author: ![scott](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/scott/32/16492_2.png) [@scott](https://community.influxdata.com/u/scott)
#### Post date: [March 12, 2024, 4:57pm UTC](https://community.influxdata.com/t/need-help-setting-alias/33445/3 "2024-03-12T16:57:07Z")

</div>

@morbiddk Is this in an InfluxDB dashboard or a Grafana dashboard?
