It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×11,932
×1,235

question asked: Apr 26 '15, 5:46 a.m.
question was seen: 2,628 times
last updated: Apr 27 '15, 9:00 a.m.

Related questions

FAQ - How this Forum works

How to get count of specific items of the report result in Rational Insight

0
feng chen (7●4●6) | asked Apr 26 '15, 5:46 a.m.
edited Apr 26 '15, 5:52 a.m.
 I'm using Insight to do a report which will filter the defects of a RTC project, the result includes the state of the defects. However, I need to get the total number of specific state like 'Open'. How to make this happen in only 1 query since I want to display both the total number of all the filtered defects and the specific state defects in 1 chart/list? Thanks!

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
feng chen (7●4●6) | answered Apr 27 '15, 9:00 a.m.
 I found a work around in other websites, since the RTC defect is represented as Request in Insight, and the [Request ID], [Request State] is 1-1 mapping. So we can use this:

count(case when [Request State] = 'Closed' then [Request ID]
else NULL end)

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.