hi to all,
I have a query that produces a chart of hosts, speeds and connection types,
index=*
| table host, speed, connection_type
| chart eval(round(avg(speed),2)) OVER host by connection_type
Where my events show that connection_type can be either: T1, T2 or T3
However, I am looking someway to tag (found_all ) or remove rows that don't have all the categories. Is that possible?
my objective is :
1. identify that host4 and host5 don't have all the connection types (remove them from the table if possible) and do an general average for (host1,2,3,6,7)
Thanks in advance
... View more