AnsweredAssumed Answered

Jaspersoft Report Question

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

Hi 

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.

 

Example

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.

 

regards

Outcomes