This function returns the median value of all the values in each group, the median being the middle value. If the number of values for any group is an even value, the average of the two middle values is returned. Otherwise, the middle value is returned. When dragging a Median element into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Time Series > Median
A Column or other non-aggregate expression can be moved over the (empty-Value Expression) branch of the tree.
The option to compute the median over distinct values only is provided, resulting in the generation of MEDIAN(DISTINCT expression). This option is enabled through the Properties panel. Double-click on Median, or highlight it and click Properties.
Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Time Series > Median Properties