And I need to compute the average of all max values per size per Trial ID (for only the ones that have Result=Passed)
This is what I have so far:
index="main" Result=Passed Size=64 | stats max(Value) as max_value by "Trial Id" | stats avg(max_value)
Which does give me the value I am looking for but only for the "Size=64" case. How do I iterate over all the different sizes, while computing the "avg(max_value)" for each of the different sizes? I then plan to chart the average max size over the "size".