I’m struggling in creating a chart showing traceability (requirement coverage) status using EA v15.0 (Dynamic Charts not available in this version).
I have my SQL queries to get the list of covered/uncovered requirements as ModelView elements, but I would like to summarize this in a single Chart, showing the number of covered/uncovered requirements
I am using eapx file (ms access like database)

In the ModelView element I use IN / NOT IN in the WHERE statement to get the covered / uncovered requirements.

SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name AS [Requirement], t_package.Name AS Package, t_object.Status, t_object.Stereotype 
FROM t_package 
INNER JOIN t_object ON t_package.Package_ID=t_object.Package_ID 
WHERE t_object.Object_ID IN 
(
    SELECT t_connector.End_Object_ID 
    FROM t_connector 
    INNER JOIN t_object on t_connector.Start_Object_ID = t_object.Object_ID
    WHERE t_connector.connector_Type='Realisation'
    AND t_object.Stereotype = 'Software Requirement'
) 
AND t_object.Stereotype='Customer Requirement' 

Then I don’t understand how to use these queries to get a chart (shall be somehow transformed in the form SELECT xyz AS Series FROM …)