Can I have a dashboard that provides an aggregated view of 2 project areas having same workitem type and workflow in RTC?

3 answers

If this is the case, you have hit an enhancement request :
Support work item queries across project areas (94575)
Looking at it from the other side, if you wanted to use multiple queries for the same dashboard viewlet, I am afraid you have again hit a enhancement :
Combine 2 or more queries from different project areas in different repositories into one viewlet (100689)
But reports could be a good alternative and are discussed in :
https://jazz.net/forum/questions/30147/cross-project-query
hope this helps.
Comments

Yes the need is somewhat same.
For instance : I have project A & B and defects logged in both these project areas.
Now my manager wants to see the overall view of his engagement which has these 2 projects. He wants to know the Total list of defects, break up as per priority, modules etc.
Can i have 1 widget consolidating these 2 projects?

ok, then you could follow either or both the discussions :
Support work item queries across project areas (94575)
Combine 2 or more queries from different project areas in different repositories into one viewlet (100689)
you can add your comments as well if you see its different
once you have a report with the required data set, you can run it through a dashboard widget. One widget would then cover multiple projects...
and like mentioned by Krzysztof above, BIRT is a good solution you can explore.
Some useful link to get started is:
https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20
http://jazz.net/library/video/285
Once you have the report created, you can use a single widget to display the report.

Comments

This Help topic shows how configure a dashboard with widgets from 2 or more project areas: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.jazz.dashboard.doc/topics/t_add_viewlet_xrepos.html&scope=null