stdevp()

Table of Contents

Definition

stdevp() returns the population standard deviation in the table column. You can use it with the transform commands that support aggregations.

Examples

The following example returns the population standard deviation for price column and groups the result by a year.

%dpl
index=sales_inventory earliest="01/01/2017:00:00:00"
| rex4j field=_raw "price=(?<price>\d+)"
| eval year=strftime(_time, "%Y")
| stats stdevp(price) by year
example of stdevp() aggregation command

Further Reading