Find median values

    Select one of the following methods to calculate the median:

    (Default) An aggregate method that uses a t-digest data structure to compute an accurate 0.5 quantile estimate on large data sources. Output tables consist of a single row containing the calculated median.

    Given the following input table:

    estimate_tdigest returns:

    _value
    1.5

    Given the following input table:

    exact_mean returns:

    _value
    1.5

    A selector method that returns the data point for which at least 50% of points are less than. Output tables consist of a single row containing the calculated median.

    Given the following input table:

    _time_value
    2020-01-01T00:02:00Z1.0

    The examples below use the .

    Use the default method, , to return all rows in a table that contain values in the 50th percentile of data in the table.

    Use the exact_mean method to return a single row per input table containing the average of the two values closest to the mathematical median of data in the table.

    Use the exact_selector method to return a single row per input table containing the value that 50% of values in the table are less than.

    To specify the median calculation method in , use the :