Hello
I think you can use eventstats like:
...| eventstats sum(ColumnB) as Total by ColumnA | ...
Try it and let me know
Regards
The same but with both fields in the by:
...| eventstats sum(ColumnB) as Total by Site, ConfigID | ...
Hi,
I have used for my another column.
there are three columns
Site ConfigID TaskCount
BAN 1 1
2 2
3 4
5 5
MYS 1 1
1 2
3 4
4 5
4 6
I have used your menthod for consolidating with site wise.
Kindly let me know for summing of taskcounts of same configids.