std_dev.asciidoc 785 B

12345678910111213141516171819202122
  1. // This is generated by ESQL's AbstractFunctionTestCase. Do no edit it. See ../README.md for how to regenerate it.
  2. *Examples*
  3. [source.merge.styled,esql]
  4. ----
  5. include::{esql-specs}/stats.csv-spec[tag=stdev]
  6. ----
  7. [%header.monospaced.styled,format=dsv,separator=|]
  8. |===
  9. include::{esql-specs}/stats.csv-spec[tag=stdev-result]
  10. |===
  11. The expression can use inline functions. For example, to calculate the standard deviation of each employee's maximum salary changes, first use `MV_MAX` on each row, and then use `STD_DEV` on the result
  12. [source.merge.styled,esql]
  13. ----
  14. include::{esql-specs}/stats.csv-spec[tag=docsStatsStdDevNestedExpression]
  15. ----
  16. [%header.monospaced.styled,format=dsv,separator=|]
  17. |===
  18. include::{esql-specs}/stats.csv-spec[tag=docsStatsStdDevNestedExpression-result]
  19. |===