BIRT Report Design with Time Difference

Virgil Dodson
Virgil Dodson E admin
edited July 28, 2021 in Analytics #1
This design uses a calculated field to get the difference between two time fields in minutes and then shows those minute aggregrated within a table group.<br />
<br />
The computed column looks like below where I had to divide by 1000 to get from milleseconds to seconds, and then divide by 60 again to get the number of minutes elapsed.
(row&#91;"stop"].getTime() - row&#91;"start"].getTime())/1000/60
<br />
This example was created with BIRT 2.3.0
Warning No formatter is installed for the format ipb