Assume we have a log file with at least the following fields
timestamp field A field B field C .....
ex:
1316018215 u1 105 a
1316018215 u2 30 a
1316018215 u3 550 c
1316018215 u2 21 a
1316018215 u1 65 b
1316018215 u3 105 a
1316018215 u2 34 b
1316018215 u1 105 c
The question: I would like to ask the following questions of this data
1. Plot for me a graph of Unique C vs. (sum of B for each unique C )
2. Plot for me a graph of Unique C vs. (sum of B for each unique C div count of occurrences).
#1:
<yourbasesearch> | stats sum(B) by C
#2:
<yourbasesearch> | stats avg(B) by C