docs-v2/content/shared/influxql-v3-reference/functions/_index.md

Use InfluxQL functions to aggregate, select, transform, analyze, and predict data.

[!Note]

Missing InfluxQL functions

Some InfluxQL functions are in the process of being rearchitected to work with the InfluxDB 3 storage engine. If a function you need is not here, check the InfluxQL feature support page for more information.

InfluxQL functions (by type)

• Aggregates
  • COUNT()
  • DISTINCT()
  • MEAN()
  • MEDIAN()
  • MODE()
  • SPREAD()
  • STDDEV()
  • SUM()
• Selectors
  • BOTTOM()
  • FIRST()
  • LAST()
  • MAX()
  • MIN()
  • PERCENTILE()
  • TOP()
• Transformations
  • ABS()
  • ACOS()
  • ASIN()
  • ATAN()
  • ATAN2()
  • CEIL()
  • COS()
  • CUMULATIVE_SUM()
  • DERIVATIVE()
  • DIFFERENCE()
  • EXP()
  • FLOOR()
  • HISTOGRAM()
  • LN()
  • LOG()
  • LOG2()
  • LOG10()
  • MOVING_AVERAGE()
  • NON_NEGATIVE_DERIVATIVE()
  • NON_NEGATIVE_DIFFERENCE()
  • POW()
  • ROUND()
  • SIN()
  • SQRT()
  • TAN()
• Date and time
  • now()
  • time()
• Miscellaneous
  • fill()