RRDI and RRC - Count links
Hi,
I am hoping someone can give me an idea has to how to do the following. Using RRDI I want to draw a pie chat for all requirement artifact, broken don into artifacts with no links, artifacts with at least one link Is there a simple way yo do this? |
4 answers
Working with a colleague of mine we finally found an answer using a join configured as a "Left Join"
I have stored the details here |
Yes, but looping isn't the answer. You should in theory be able to do:
Query for all requirements of type actor Query for all Trace To requirements (or Requirements related Requirements with Link Type=Link) of type Use Case Diagram Join the two queries and count all requirements of type actor and count those with/without links I've tried this but I can't get the right data and can't work out what to Join on, and the implicit Join as above doesn't quite do it. Comments
ross jones
commented Nov 12 '13, 12:36 p.m.
folks,
|
The count distinct for ID_Count *should* take care of duplicates
Comments
Chris Hardy
commented Mar 04 '13, 9:27 p.m.
Ok, the problem is getting a distinct count of :
|
Hi Chris,
Appears we're both trying to kill the same bird:-) I took a shot at this but my head's done in so I'm hoping someone from the RRDI/RM team can help. Here's what I did so far. For example, all Actors linked/Not Linked to Use Case Diagrams. I've been able to get something working : and the corresponding data : All good so far and I was almost happy. Except I changed the queries to use selectable parameters so the user can choose what type of requirement is linked/not linked to some other type. Then trouble. If I select Actor Linked/Not Linked to Feature I get: with data : Which *seems* correct except that 2 actors are missing ("Financial Business Manager" and "Registered User"). In other words, I would expect that no matter what type of "target" requirements I select, the total number of source requirements remains 13. I've tried all sorts of options but no success. The XML for the report is here. Basically I have a query that has: [Business View].[Requirement].[Requirement ID] [Business View].[Requirement].[Name] [Business View].[Requirement].[Requirement Type] with Filter [Requirement Type] in ?ReqType? [Business View].[Requirement Related Requirements].[Name] [Business View].[Requirement Related Requirements].[Requirement Type] with Filter [Link Type] in ('Link') or [Link Type] is null [Business View].[Requirement Related Requirements].[Link Type] with Filter [Requirement Type2] in ?TargetType? or [Requirement Type2] is null A data item [Linkage] which is A data item ID_Count which isIF ( [Link Type]='Link') THEN( 'Linked' )ELSE('Not Linked' ) The Chart has its measure set to ID_Count and Series set to Linkage.count( distinct [Requirement ID]) Comments
Chris Hardy
commented Mar 04 '13, 6:20 p.m.
Hi Freddie,
|
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.