Incorrect operation calculations in Pivot table.

Webix JS
1

Hi there

I am noticing that the operation calculations seem to be miscalculating when there is no data available to calculate on. In some cases an array of [0] is passed into the operation when I would assume an array of [] should be passed.

I am using 2 row fields and 1 column field. I am noticing that if I use MIN or MAX operations where no data exists in the combination of Row Field 1, Row Field 2, Column Field 1 then sometimes it displays NaN and other times it displays 0. I would expect NaN (or blank) should be returned in any case where there is no data available.

Any ideas?

Thanks!

2

Hi,

Pivot requires values for all data properties. But we’ve considered the issue and implemented the support for skipped values. The update will be included into the next version.

Please open a ticket in Members’ Area if you need to get the updated pivot libraries ASAP.

3

How long until the next release?

Thanks.

4

There is not a fixed date for the next update (3.1.x). The next official version (3.2) will be ready in February.