Filter by hostname(tag) flux query

InfluxDB 2
,
1

Hi
need to filter result in flux with hostname(tag) here e.g: server1 and server2 but won’t work, here is my flux query:

from(bucket: “mybucket”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “mymeasure” )
|> filter(fn: (r) => r[“host”] == "“server1"” or r[“host”] == "“server2"”)

|> group(columns: [“${Interval}”,“_measurement”,“host”])

|> aggregateWindow(every: ${Interval}, fn: count, createEmpty: false)

without this line return result:

|> filter(fn: (r) => r[“host”] == "“server1"” or r[“host”] == "“server2"”)

result:


 table     _measurement       _field  _value    _start                        _stop                      host
 0	       mymeasure	      t1      8	         2023-07-13T10:16:31.518Z	2023-08-12T10:16:31.518Z	"server1"
2

Hello @Indeed_1,
I’m not quite sure I understand your problem.
You can’t filter without a filter function.
I don’t think you need this line though:

|> group(columns: [“${Interval}”,“_measurement”,“host”])

You dont have an interval column in your data so you’ll likely be getting an error with that.