How to find the history of testcases?

[andy]

Hi folks,

If I have set of tests and they are run at different points in time and some of them are rerun several times how can I find the status of the whole test set at different dates?

Data looks like this:

Product Testcase        ExecDate     verdict

A             TC1               2011-08-01      Fail

A             TC1               2011-08-15      Fail

A             TC1               2011-09-01      Pass

A               TC2               2011-08-09      Pass

A               TC2               2011-08-19      Pass

A               TC2               2011-09-01      Pass

B             TC1               2011-08-03      Blocked

B             TC1               2011-08-18      Fail

B             TC1               2011-09-31      Pass

Now if I select Product A and 2011-08-20 I should se that TC1=Fail and TC2=Pass, 50% passrate...

The status of today is 100% passrate since allt testcases has Pass as their latest verdict.

I've been thinking of different approaches including set analysis and making a date island and treating it like a saldo table

Any suggestions?

/Andy

[swuehl · Accepted solution]

Andy,

you probably need some kind of master calendar or data island to create a range of dates the user can select from to set the point in time for the report.

Then you just need a chart with dimensions Product and Testcase and as expression

=FirstSortedValue({<ExecDate={"<=$(=max(Date))"}>} verdict, -ExecDate)

See also attached.

Hope this helps,

Stefan