It's all about the answers!

Ask a question

How to convert Milliseconds into hours for "Estimate" attribute value in JRS life query cycle(livedata) which uses Sparql query?


rkRash 123 (11319) | asked Jan 16 '18, 8:03 a.m.

HI i was working on the JRS report usinfg live data having  lifequery cycle  there estimate attribute listing the values in  milli seconds ...Can you help us in converting into hours?

As we are not much familar with sparql queries, Can you help us in converting the below sparql estimate attribute values to hours,

?rtc_merged_Task1_estimate

One answer



permanent link
Kathryn Fryer (503147) | answered Jan 16 '18, 2:23 p.m.

What version are you working in? If you are using 6.0.4, you can add a Custom Expression column on the Format Results page.

Click Custom Expression button (at the bottom of the columns). Set the artifact dropdown to your Work Item/Task, and select your attribute, then click the arrow button to show it in the Custom Expression box at top right. Then append "/3600000"  (without the "") to simply convert ms to hours. Set Show As if desired (integer, test, decimal).
There is a video that shows how to add Custom Expressions; it uses the DW and SQL, but shows you the UI anyways.

If you are using an earlier version, then you will need to edit the SPARQL in the Advanced section, which means you will have to all future work in the SPARQL and might lose formatting and other options. If you do edit the custom SPARQL, here's the statement that I found in the Advanced section after adding the custom expression:

BIND(?rtc_cm_WorkItem1_estimate/3600000 as ?rtc_cm_WorkItem1_estimate_CUSTOM)

You would then include the ?rtc_cm_WorkItem1_estimate_CUSTOM in your SELECT statement.

Your answer


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.