Hi - I'm trying to read two different elements within each search record and them show their count so its like
Record 1 - key1, key 2 Record 2 - key1, key 3
Record 3 - key1, key3, key2
The result i'm trying to get is
Key 1 - count of 3
Key 2 - count of 2
key 3 - count of 2
So when i search first i get the raw, look for key 1 and do a stat with count for key 1, then i append a new search query look for key 2 and then do a stat with count for key 2 etc..
The problem is when i append it does not just add the new values as rows but it adds it as columns which is weird, so output is like
key 1 - 3 key2 - 2 key3- 3
I want them vertically one below another and not in this horizontal way...
Pls advise..
... View more