docs-v2/content/influxdb/clustered/reference/influxql/functions/_index.md

title	description	menu	weight
View InfluxQL functions	Aggregate, select, transform, and predict data with InfluxQL functions.	influxdb_clustered name parent identifier InfluxQL functions influxql-reference influxql-functions	208

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 v3 storage engine. If a function you need is not here, check the InfluxQL feature support page for more information. {{% /note %}}

InfluxQL functions (by type)

• Aggregates
  • COUNT()
  • DISTINCT()
  • MEAN()
  • MEDIAN()
  • 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()