I have created a view that displays last value all the field values of series.
Works fine, but I want to show just the column name against the value. Right now its showing the series.
PS: I am working with influxDb V2 and flux query language
My query:
from(bucket: “migration_poc”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “yearly_count_1”)
|> filter(fn: (r) => r[“year”] == “Total”)
|> filter(fn: (r) => r[“group_by”] == “siuid”)
|> pivot(rowKey:[“year”,“group_by”], columnKey: [“_field”], valueColumn: “_value”)
This is how the view looks like