I have a request to provide summaries of events by nodes. The summary is just a count. I can get a report that shows event name in one column, the node name in the next and event time in the third column. The third column is aggregated with aggregation = "count". But my user wants an x by y table. Is this possible?
What I have:
1.2.3.4 A 4
1.2.3.4 B 2
2.3.4.5 A 1
2.3.4.5 B 8
What I want:
A B
1.2.3.4 4 2
2.3.4.5 1 9