It's all about the answers!

Ask a question

Jazz Reporting Services (JRS): When do drilldown in graph format from RTC widget, data is not populated


Raj Asthana (1149) | asked Apr 27 '16, 2:53 a.m.
edited Apr 27 '16, 4:38 a.m. by Ralph Schoon (63.6k33646)
 Hi,
I am using RTC v6,0 and creating the report through JRS. I have customize the query in Advance option while creating the report and using the group by clause. (SEE the below query)
SELECT  
       CONCAT(CONCAT(
      CASE MONTH(T2.VAL)
      WHEN 1 THEN 'Jan' 
      WHEN 2 THEN 'Feb'
      WHEN 3 THEN 'Mar'
      WHEN 4 THEN 'Apr'
      WHEN 5 THEN 'May'
      WHEN 6 THEN 'Jun'
      WHEN 7 THEN 'Jul'
      WHEN 8 THEN 'Aug'
      WHEN 9 THEN 'Sep'
      WHEN 10 THEN 'Oct'
      WHEN 11 THEN 'Nov'
      WHEN 12 THEN 'Dec'
      END       
      ,' - '),YEAR(T2.VAL)) AS VAL5,
    COUNT( DISTINCT T1.REFERENCE_ID) AS REFERENCE_ID1,
    COUNT(DISTINCT CASE WHEN (days(T3.VAL) - days(T2.VAL) <= 28)  THEN T1.REQUEST_ID END ) AS VAL2,
CAST(COUNT(DISTINCT CASE WHEN (days(T3.VAL) - days(T2.VAL) <= 28)  THEN T1.REQUEST_ID END ) AS DECIMAL) / CAST(COUNT( DISTINCT T1.REFERENCE_ID) AS DECIMAL) AS VAL1

    --CAST(COUNT(DISTINCT CASE WHEN (days(T2.VAL) - days(T3.VAL) >= 10)  THEN T1.REQUEST_ID END ) AS DECIMAL) / CAST(COUNT( DISTINCT T1.REQUEST_ID) AS DECIMAL) AS VAL1
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RICALM.VW_RQST_TIMESTAMP_EXT T2 ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME='com.ibm.team.workitem.attribute.rcnscheduledate'
LEFT OUTER JOIN RICALM.VW_RQST_TIMESTAMP_EXT T3 ON T3.REQUEST_ID=T1.REQUEST_ID AND T3.NAME='com.ibm.team.workitem.attribute.BetaReleaseDate'
WHERE 
T1.PROJECT_ID = 33  
AND (  T1.REQUEST_TYPE = 'RCN' ) 
AND (T1.ISSOFTDELETED = 0) 
AND (T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)
GROUP BY CONCAT(CONCAT(
      CASE MONTH(T2.VAL)
      WHEN 1 THEN 'Jan' 
      WHEN 2 THEN 'Feb'
      WHEN 3 THEN 'Mar'
      WHEN 4 THEN 'Apr'
      WHEN 5 THEN 'May'
      WHEN 6 THEN 'Jun'
      WHEN 7 THEN 'Jul'
      WHEN 8 THEN 'Aug'
      WHEN 9 THEN 'Sep'
      WHEN 10 THEN 'Oct'
      WHEN 11 THEN 'Nov'
      WHEN 12 THEN 'Dec'
      END       
       ,' - '),YEAR(T2.VAL)),
       YEAR(T2.VAL),MONTH(T2.VAL)
ORDER BY YEAR(T2.VAL), MONTH(T2.VAL)

Data has fetched correctly and graph is also plotted but when add this report on RTC widget. It was added and showing the graph format and table format both. When I drill down on the graph option it is not displaying any data and showing only "Loading, Please wait....", seems to be infinite process.
Please see the attachment for reference.

Thanks for your kind help and suggestion.

Regards,
Raj

Comments
Raj Asthana commented May 02 '16, 6:45 a.m.

 Hi,

Could you please guide me on the requested question?

Thanks

Regards,
Raj

Be the first one to answer this question!


Register or to post 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.