It's all about the answers!

Ask a question

How to query LQE JRS to show time spent in hours


Pankaj Sharma (401170) | asked Jul 14 '17, 10:53 a.m.
edited Jul 14 '17, 10:54 a.m.

I am using JRS 6.0.2 with LQE data source.

I am querying the sum of time-spent per day for current users, it gives data in minutes and obviously its easy to read 6.5 hours than 390 minutes.

I tried converting the time to Hour in sparql query but in that case its hard coding only my ID for the query instead of current user also it looses hyperlink capability.

Is there any workaround.


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.