median()

Table of Contents

Definition

median() returns the middle-most value of the table column. You can use it with transform commands that support aggregations.

Examples

You can use median() with timechart or other charting commands. In the following example, the query calculates the middle-most value for elapsed column and groups them by operation column.

%dpl
index=crud earliest=-3y
| spath
| timechart median(elapsed) by operation
example of median() function

Further Reading