How to count values based on another column result?

[KalebeRS]

Hello,
I have this dashboard with this 3 fields (ID, A1_Links, A2_Links).
The goal is to have the count of the total of ID's containing links, based on the A1 and A2 Links columns. (How many ID's containing A1 links and how many ID's containing A2 links)

How can I do that?

index="" host= sourcetype=csv source=CW27.csv
| dedup ID
| table ID A1_Links A2_Links

[gcusello]

Hi @KalebeRS,

please try this:

index="your_index" host=your_host sourcetype=csv source=CW27.csv
| stats dc(ID) AS ID_count BY A1_Links A2_Links

Ciao.

Giuseppe