Issue:
The customer does not want accuracy higher than whole number values.
Product Line:
ION Enterprise
StruxureWare Power Monitoring (SPM)
Power Monitoring Expert (PME)
Environment:
Vista Data Log Viewer
Web Applications Data Log Viewer
Cause:
Software rounds to the thousandth place.
Resolution:
Confirm that Show Toolbox is checked in Options in the top-left then right-click on the data log viewer that needs to be changed in Vista. Go to the Query tab and click Edit SQL ... Add a ROUND function to the queries, for example
SELECT timestamp
, "Vll ab mean"
, "Vll bc mean"
, "Vll ca mean"
becomes
SELECT timestamp
, ROUND("Vll ab mean", 0) AS "Vll ab mean"
, ROUND("Vll bc mean", 0) AS "Vll bc mean"
, ROUND("Vll ca mean", 0) AS "Vll ca mean"
Save the file. Double-click on the data log viewer and you should see the value is rounded up to the nearest integer.