I've got a bunch of similar fields in my events. I've got fields named term0-9 and I'd like to create a chart that shows the top terms across all those fields.
For example, if I have an event where term0="First+Term" and term1="Second+Term"
Event # term0 term1 term2
------- ----- ----- -----
1 Bob Mary John
2 Mary Jake Tim
3 Bill Tom Sally
4 Sam Sally Mary
I'd like to output a chart that shows:
Is this possible. If I just combine the fields into one and group based on that, then the order of the search term becomes significant and I don't want it to be.
Anyone have any ideas?
you can achieve your objective using top command and count by command
Care to give a little more details on your suggestion? How do I do this across multiple fields?
I can do
top 20 term0
but I don't know how to have it evaluate multiple fields. Thoughts?