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

feng chen

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!

0 votes

1 answer

3,185 views

0 votes

One answer

Permanent link

feng chen

(7●4●6) 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)

0 votes

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

usage

× 12,025

rational-insight

× 1,230

Question asked: Apr 26 '15, 5:46 a.m.

Question was seen: 3,185 times

Last updated: Apr 27 '15, 9:00 a.m.

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

feng chen

1 answer

3,185 views

0 votes

One answer

feng chen

Your answer

Follow this question

Question details

Related questions