Getting average times for user defined categories

[RVDowning]

stats count as #PlanOpen,
count(eval(NumRows < 50)) as SmallPlans ,
count(eval(NumRows>=50 AND NumRows <200)) as MediumPlans,
count(eval(NumRows >=200)) as LargePlans

With a query such as above and a field SecsElapsed in each row, is there a way to get the average of that field for each category, namely SmallPlans, MediumPlans and LargePlans?

[RVDowning]

Have no idea if that is what you meant or not.

[cpeteman]

Can you change this so the code is formatted please? Thanks 🙂

[RVDowning]

Ok, I think I have this. I was just in syntax hell.