AnsweredAssumed Answered

Jaspersoft Report Question

Question asked by arimu02 Employee on Feb 19, 2019
Latest reply on Feb 20, 2019 by camja06


I  created a report who calculate the time of incident from Open to Resolve.


the report is working fine but now the customer have a below queries which need to be address:


1- Report should calculate business hours only.

2- weekend time should not be calculated in report.



If Incident open on Thursday@ 10:00 AM (Last working day) and close on Sunday(First Working day) 10:00 AM

then the report should show the total time 9 hours instead of 64 hours.


any idea how can we create the query.