Hello, Let me give you an example. I've got the following table to work with: src_group dest_group count A B 10 B A 21 A C 32 B Z 6 I'd like to have something like this for result: group src_count dest_count A 42 21 B 27 10 C 0 32 Z 0 6 As you can see, I have now only one colomn with the groups, and the count are merged by groups while the direction (src or dest) is now on the counts : we sum the count for each group depending of whether the group was the source or the destination in the first table. Any clue? Edit: to help me, you can use this search that will generate the first table: | stats count | eval src_group="A", dest_group="B", count=10 | append [| stats count | eval src_group="B", dest_group="A", count=21 ] | append [| stats count | eval src_group="A", dest_group="C", count=32 ] | append [| stats count | eval src_group="B", dest_group="Z", count=6 ]
... View more