Convert Field into Tags in the same measurement

[nagashree]

I have Bcm_Modes field in my measurement it has values 0,1,2,3 i wanted to convert BCM_Modes into Tag in the same measurements and how to do it?I have to group the vehicle_speed by this commandmodes. I am new to the Flux completely. Please help me with this

[Anaisdg]

Hello @nagashree,
The best way to do this would be to delete and rewrite your data correctly using the same method you used to write your data the first time.
You can still group by fields.

Or you can follow this:

influxDB: How to convert field to tag in influxDB v2.0

You can remove the field filter to get all your fields. Here you go: myField = from(bucket: "Air sensor sample dataset") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "airSensors") |> filter(fn: (r) => r["_field"] == "co") |> filter(fn: (r) => r["sensor_id"] == "TLM0100") |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false) |> findRecord(fn: (key) => true, idx: 0) data = from(bucket: "Air sensor sample dataset…

But your old data will still exist. So you’re not exactly replacing in this example. You’re just transforming with flux and writing data with flux.