How to achieve average of first 7 vs last 7 records?

[agupta13]

Hi team,

I have 14 records in the table,  I want to find out average of first 7 and average of last 7 records

How can I do that? Here I want avg of first 7 entries and then average of last 7 entries

[ITWhisperer · Accepted solution]

| streamstats count as row
| eval row=if(row<=7,1,2)
| stats avg(count) as average by row