I have the following returned from a query
test a : result 1
test a : result 2
test a: no result
test b: no result
test c: no result
test c: result 4
and I want to generate a table showing tests which have AT LEAST 1 result
so
test a: has result
test b: has no result
test c: has result
I am very confused by the summary and aggregation documentation - is there a way to do this?
Thanks very much
try this
create count _calculation as
if (UPPER([Tes_Result_Column])contains 'TEST RESULT') then
(1)
else
(0)
then create another calculation as
if (total (count _calculation ) >=1) then
('Has result')
else
('Has No Result')
Thanks very much for your help
This worked
Hi again
One last piece in the puzzle
I want to present a simple summary of the query data
test case test case status
test 1 single result
test 2 no result
test 3 no result
test 4 single result
test 5 more than one result
summary should be
no result 2
single result 2
more than one result 1
This is driving me crazy as I thought I could just use the count distinct on the test case name (as I have in other reports to produce pie charts), but this always returns just one test case status ("more than one result")
Is there a standard way to do this?
Thanks again