The easiest way to resolve this issue is to update to Security Analytics version 7.1.6 or greater. In 7.1.6, the timezone adjustment is ignored.
If you are running versions prior to 7.1.6, you can make the modification manually.
1. Login as root on the sensor and edit the file /gui/dsweb/View/DeepseeReports/index.ctp.
2. Find the line with "var addTz = true;”. It is on line 44 in the lab sensor.
3. Change the true to false.
4. Save the change.
No service restart is necessary.
Test the pivot with the third party application.