Download Free Trial

Format rule does not work for type: "time" fields

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.
Elizeu Madeira

2 answers

Iryna Kulchytska Flexmonster September 28, 2017

Hi Elizeu,
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.
Kind regards,

Madeira September 29, 2017

Thank you!
We will wait

Please login or Register to Submit Answer