Median aggregation fails if null values - inconsistent with other aggregation functions- linked to #4837

[alex314159]

Describe the bug

As per the title, linked to #4837

The culprit is, I think:

 const values = leafRows.map(row => row.getValue(columnId))
  if (!isNumberArray(values)) {
    return
  }
  if (values.length === 1) {
    return values[0]
  }

Your minimal, reproducible example

any table

Steps to reproduce

Any grouped tables with aggregationFn "median" and some null values in the group

Expected behavior

I believe user would like to see the median of the existing values, just like sum / min / max

How often does this bug happen?

Every time

Screenshots or Videos

No response

Platform

any but tested on Windows

react-table version

v8.9.4

TypeScript version

No response

Additional context

No response

Terms & Code of Conduct

• I agree to follow this project's Code of Conduct
• I understand that if my bug cannot be reliable reproduced in a debuggable environment, it will probably not be fixed and this issue may even be closed.