Re: one for the SQL experts - dare I say TRICKY SQL!

paulspratley_at_yahoo.co.uk wrote:
> There are 2 occassions when the user count is 1 at the start of
> Threadid 1 and when the last thread 4 is kicked off. Threadid has 2 *
> 10 (measurements) = 20 and Threadid 4 has 2 * 40 (measurements).
> Therefore 100 measurements in total. Two threads therefore average =
> 50.

Then the column name in your sample report is misleading: Expected Results

Count of Users Avg Rsp Time

1       50 
2       30 
3       40