We have two different result set, From which we need to create line chart for(Actual start date of workitem vs Scheduled start date of workitem)showing date captured out of 2 result set.

But currently we are getting only one . Performing the line chart in Jazz Report Builder (RS)

Please find below query:

This is for Scheduled Count

SELECT SUM(TTCOUNT) OVER (ORDER BY VAL) AS CUMULATIVE_CNT, VAL FROM

(

SELECT DISTINCT COUNT(DISTINCT CASE WHEN (T2.VAL IS NOT NULL) THEN T1.REQUEST_ID END) AS TTCOUNT,

       T2.VAL AS VAL

FROM RIDW.VW_REQUEST T1

RIGHT OUTER JOIN RICALM.VW_RQST_TIMESTAMP_EXT T2

ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME= SchedStart

WHERE T1.PROJECT_ID = 13  AND

(  T1.REQUEST_TYPE = 'Work item' AND

   ((T1.REQUEST_CATEGORY_NAME = 'Attributes' OR T1.REQUEST_CATEGORY_NAME LIKE 'Attributes/%') AND (T1.PROJECT_ID = 13))

) AND

(T1.ISSOFTDELETED = 0) AND

(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL) AND

(T2.VAL IS NOT NULL)

GROUP BY T2.VAL ORDER BY T2.VAL ASC

) FSR

  This is for Actual Count

SELECT SUM(TTCOUNT) OVER (ORDER BY VAL) AS CUMULATIVE_CNT, VAL FROM

(

SELECT DISTINCT COUNT(DISTINCT CASE WHEN (T2.VAL IS NOT NULL) THEN T1.REQUEST_ID END) AS TTCOUNT,

       T2.VAL AS VAL

FROM RIDW.VW_REQUEST T1

RIGHT OUTER JOIN RICALM.VW_RQST_TIMESTAMP_EXT T2

ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME='actualstart'

WHERE T1.PROJECT_ID = 13  AND

(  T1.REQUEST_TYPE = 'Work item' AND

   ((T1.REQUEST_CATEGORY_NAME = 'Attributes' OR T1.REQUEST_CATEGORY_NAME LIKE 'Attributes/%') AND (T1.PROJECT_ID = 13))

) AND

(T1.ISSOFTDELETED = 0) AND

(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL) AND

(T2.VAL IS NOT NULL)

GROUP BY T2.VAL ORDER BY T2.VAL ASC

)

Creating graph for single result set.

Kindly help us in plotting data from both the result set.