Hi I got this query:
from(bucket: "chieam_new")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == "tracker_alarms")
|> group(columns: ["_field"])
|> sort(columns: ["_time"])
|> difference(columns: ["_value"], keepFirst: true)
|> filter(fn: (r) => r._value != 0)
|> map(fn: (r) => ({
_time: r._time,
_field: r._field,
event: if r._value > 0 then "start" else "end"
}))
|> group(columns: ["_field"])
|> pivot(rowKey: ["_field"], columnKey: ["event"], valueColumn: "_time")
|> rename(columns: {start: "Event Start Time", end: "Event End Time"})
|> sort(columns: ["Event Start Time"], desc: true)
|> yield(name: "events")
That in influx displays correctly when a filed start to have a value ==1 and when this ends.
if i use the same query in Grafana with table-view i have a completely different view and i’m really puzzled in how to solve it as it only shows one event and not i the way i want to, any help is wellcome.
