Jazz Reporting Services (JRS): When do drilldown in graph format from RTC widget, data is not populated
Raj Asthana (1●1●4●9)
| asked Apr 27 '16, 2:53 a.m.
edited Apr 27 '16, 4:38 a.m. by Ralph Schoon (63.6k●3●36●46)
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
|
Be the first one to answer this question!
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.
Comments
Hi,