group by count in expression

[bhaskar_anumand]

Hi,

Pl suggest how to get group by count of Port with IP in Expression.

Example : count(A) =7

ip	name	port
A	C	1
A	C	7
A	C	8
A	C	10
A	C	11
A	C	13
A	C	14
B	C	1
B	C	2
B	C	3
B	C	19
B	C	22

[jubarrosor]

Hi anumandla:

Try an expression like:

     count({<ip={'A'}>}ip)

     sum({<ip={'A'}>} port)

Best Regards,

Juan P.

[sunny_talwar]

IP in expression? Not sure I understand?

[vvira1316]

count({<ip>}port)

I had a duplicated header row in my inline table hence it is showing ip in table line