Access to "median" function for table aggregations and analytics?

Product suggestions
1

It doesn’t look like there is a median function in either Table Aggregations or Table analytics…

What I’m trying to accomplish is trying to understand the shape of a distribution by comparing the average to the median. If they differ significantly, that potentially tells me a lot about the distribution.

If the median is much lower than the average, then I know that the average is mostly being driven by old orders.

If the median is much higher than the average, then I know that the average is mostly being driven by new orders.

My current idea is to subtract one from the other (haven’t decided what order) to create an “index” KPI.

If it matters we’re still on LTS8 but should soon be updating to LTS9.

2

Hi @Richard-SNN
You have good timing, we have been discussing this topic internally lately! This is something we would like to add, and hopefully soon. However, we are still working though this in context of some larger changes, so the timeline of adding this is not perfectly clear as of yet.
-Pete-