How to remove Remove Zero From Average Calculation ?

[ayarhlaine]

How to override Aggregators for average

Is there any way to remove zero values from average calculation?
I have the data like that: Name, Exam and Score.

But, when I trying to look average calculation for specific user, I don't got my expected average score like that:

Expectation

Average = 90/1 = 90 (removed zero values)

Actual

Average = (90+0+0) / 3 = 30.00

Could I get any reference to override average method?

Code Sandbox Link

https://codesandbox.io/s/competent-thunder-gqe94?file=/src/App.js:363-368

[ayarhlaine]

Already solved by writing own aggregator for average calculation 🔥 🔥 🔥.

import { numberFormat } from "react-pivottable/Utilities";
export function averageAggregator() {
  return function ([attr]) {
    return function () {
      return {
        count: 0,
        total: 0.0,
        push(record) {
          const currentValue = parseFloat(record[attr]);
          if (isNaN(currentValue)) {
            return;
          }
          if (currentValue > 0) {
            this.count += 1;
            this.total += currentValue;
          }
        },
        value() {
          if (this.count === 0 || this.total === 0) {
            return 0;
          }
          return this.total / this.count;
        },
        format: numberFormat(),
        numInputs: typeof attr !== "undefined" ? 0 : 1
      };
    };
  };
}

Also added unit tests for this as well!

[ayarhlaine]

Can close or make open with your choice. Thanks for supporting react-pivottable.