Hi folks
This should be simple but I have been struggling with the aggregation:
I want to present a simple summary (and eventually a pie chart) of the query data based on the test case status
test case test case status
===== ==========
test A single result
test B no result
test C no result
test D single result
test E more than one result
test F no result
summary should be
test case status count
========== ====
no result 3
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? I am fairly new to Cognos reports!
Cheers