Shorter maxspan delivers more results

[cmeerbeek]

We have build a query spanning multiple source types. We try to create a simple transaction with one field.
The results are strange. When we set the maxspan to 6h we get 48 results but when we set it to 1m we get 5k results.
How is this possible? Can someone clarify this?

[somesoni2]

Maxspan properties set a constraint on the maximum duration a transaction can expand. So For example data:

3/14/2013 10:00 ID=1    Status=Success
3/14/2013 10:01 ID=1    Status=Fail
3/14/2013 12:00 ID=1    Status=Success
3/14/2013 12:01 ID=1    Status=Fail
3/14/2013 15:59 ID=1    Status=Success
3/14/2013 16:00 ID=1    Status=Fail

"...| transaction ID maxspan=1m" will return 3 rows as transaction( matching filter criteria) will be considered complete after 1 min duration.
"...| transaction ID maxspan=6h" will return just 1.

[cmeerbeek]

Thanks for the quick reply.

The strange thing is that if the ID is 1 for the first two records and 2 for the second and third record and 3 for the fourth and fifth record I would alway expect 3 as a result right?

That is not happening here. The field used with transaction is alway unique still I get different results if the maxspan is shorter.

Any idea?