How do I calculate the median value for a series?

There are two main possibilities to calculate the median value for a series:

1. Statistics analysis

Add “Median” as a calculation. You can also set the data range over which you want to calculate the median.

2. Formulas

Median(series)

Returns the median value of a series.

Median(series, window)

Returns the median value of a series, on a rolling basis.

 

NOTE: if you want to calculate the median across several time series, you should use the Cross Section analysis.