Median

krish2459 — Sat, 16 Nov 2024 20:34:53 GMT

Hi,

I want to calculate the Median for the my count(sales orders ) over Month.

I tried

median(aggr(count([Sales Order]),[Sales Order]))

but I'm getting only one as median for all months.

Attached is the sample data file.

Thanks..

Re: Median

Frank_Hartmann — Wed, 26 Jun 2019 08:59:32 GMT

try this:

median(aggr(count([Sales Order]),FSD))

or this:

aggr(median(aggr(count([Sales Order]),FSD)),Month)