Stats count and average

[rhinomike]

I have a log that more or less looks like:

 timestamp=1422006650  [email protected] [email protected] subject="I love you honey" score=100 
 timestamp=1422007650    [email protected] [email protected] subject="I love you honey" score=100 
 timestamp=1422008650    [email protected] [email protected] subject="I loved him first" score=100
 timestamp=1422009650    [email protected] [email protected] subject="I loved you first" score=50
 timestamp=1422009750    [email protected] [email protected] subject="I loved him  first" score=10

I am now trying to perform a stats like

from                    subject                 count_to    avg_score
[email protected]          I love you honey       2       100
[email protected]          I loved you first      1       50
[email protected]          I loved him first      2       55

If I'm not mistaken, I can use:

stats count by from,to, subject to build the four first columns, however it is not clear to me how to calculate the average for a particular set of values in accordance with the first round of stats.

Is it possible?

[aweitzman · Accepted solution]

This should work:

... | stats count as count_to avg(score) as avg_score by from subject

[rhinomike]

Solved it perfectly. Thanks