Switches, Hubs, and Modems
1753515 Members
5395 Online
108795 Solutions
New Discussion

Need help with Portlets- Tests by Execution status and Total tests

 
van100
Advisor

Need help with Portlets- Tests by Execution status and Total tests

Hello,
I have created a Line graph portlet which uses Tests by execution status KPI. This Portlet shows all the execution status results over date. I also have another line graph portlet for Total tests over date. I would like to combine these two portlets so that I get the "Total tests" line graph along with the "Execution status" in the same graph. How to modify the queries or how to do union of the portlets ?

Tests by execution status:
The query is
SELECT ?Tests.Execution_Status?,count(*) as value
FROM ?Tests?
GROUP BY ?Tests.Execution_Status?

Total Tests:
SELECT count(*) as value
FROM ?Tests?

If I try to do Union of these two portlets, I am not getting what I want. Please help.