• v7.3.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Operations reference
NEXT
Average (avg)

Searching data / Building a query / Operations reference / Aggregation operations

Download as PDF

Aggregation operations

  • Average (avg)
  • Count (count)
  • First (first)
  • First not null (nnfirst)
  • HyperLogLog++ (hllpp)
  • HyperLogLog++ Count Estimation (hllppcount)
  • Last (last)
  • Last not null (nnlast)
  • Maximum (max)
  • Median / 2nd quartile / Percentile 50 (median)
  • Minimum (min)
  • Non-null average (nnavg)
  • Non-null standard deviation (biased) (nnstddev)
  • Non-null standard deviation (unbiased) (nnustddev)
  • Non-null variance (biased) (nnvar)
  • Non-null variance (unbiased) (nnuvar)
  • Percentile 10 (percentile10)
  • Percentile 25 / 1st quartile (percentile25)
  • Percentile 5 (percentile5)
  • Percentile 75 / 3rd quartile (percentile75)
  • Percentile 90 (percentile90)
  • Percentile 95 (percentile95)
  • Standard deviation (biased) (stddev)
  • Standard deviation (unbiased) (ustddev)
  • Sum (sum)
  • Sum Square (sum2)
  • Variance (biased) (var)
  • Variance (unbiased) (uvar)

Download as PDF

PREVIOUS
Operations reference
NEXT
Average (avg)

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.3.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport