Hello All,
Am using InfluxDB v2.7.11 for Cisco Telemetery data colletion and have two fieds with two values ( like one is number format and one is in string format) .
Now I want to display both values in table format . How can i do I have tried join function but still not working as mentioned below. any correction in below function or alternative to get requirements. I tried multiple method but still not able to fix it.
a = from(bucket: “telegraf”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“subscription”] == “554”)
|> filter(fn: (r) => r[“_field”] == “total_established”)
|> filter(fn: (r) => r[“source”] == “DC01Leaf01-15”)
|> aggregateWindow(every: v.windowPeriod, fn: sum, createEmpty: false)
|> unique()
|> count(column: “_value” )
|> group()
b= from(bucket: “telegraf”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“subscription”] == “554”)
|> filter(fn: (r) => r[“_field”] == “state”)
|> filter(fn: (r) => r[“source”] == “DC01Leaf01-15”)
|> unique()
|> group()
joined = join(
tables: {a: value, b: value},
on: [“_time”],
method: “inner”
)
result = joined
|> map(fn: (r) => ({
_time: r._time,
combinedValue: r.b + r.b
}))
