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.