I’m trying to apply a format rule for a field with time type and average aggregation.
It works as expected when using max, or count (or any aggregation that doesn’t yield a float number), but with average I can’t truncate the number. This field even transforms the integer value (from json data source) into “HH:mm:ss” format but with decimals number after the seconds (for example, when the result of the average aggregation is 567.13333333333333 he transform into “00:12:23.1333333333”). Same issue when exported to excel.
I tried to init a predefined format (it works fine with number types, even with average aggregation) and using the “Format Cell” window after data loaded.
The Flexmonster PivotTable version is “Version 2.403 (build 11/09/2017 09:44:07) – Edition: CSV/JSON/SQL Unlimited – Pivot Table & Charts Component – Developer’s version“. I tried loading the default language and the “Portuguese” translation JSON. I tried the 2.4 version too.
Thank you for reporting the issue. It was reproduced on our side and it will be fixed in the minor version 2.406 (ETA – Oct 23).
Please let us know if this works for you.
We will wait