How can I create a column that counts how many Field Bs there are per Field A?

[christopheryu]

Have this:

search... | stats values(interfaces) AS Interfaces by circuit

Thank you in advance!

[gcusello · Accepted solution]

Hi christopheryu,
di you tryed

your_search 
| stats dc(interfaces) AS count values(interfaces) AS Interfaces by circuit

Bye.
Giuseppe

[christopheryu]

Thank you!