Index

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()
  <!-- - [INTEGRAL()](/influxdb/version/reference/influxql/functions/aggregates/#integral) -->
• Selectors
  • BOTTOM()
  • FIRST()
  • LAST()
  • MAX()
  • MIN()
  • PERCENTILE()
  • TOP()
  <!-- - [SAMPLE()](/influxdb/version/reference/influxql/functions/selectors/#sample) -->
• 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()
  <!-- - [ELAPSED()](/influxdb/version/reference/influxql/functions/transformations/#elapsed) -->
• Date and time
  • now()
  • time()
• Miscellaneous
  • fill()

<!-- - [Technical analysis](/influxdb/version/reference/influxql/functions/technical-analysis/) --> <!-- - (Predictive analysis) [HOLT_WINTERS()](/influxdb/version/reference/influxql/functions/technical-analysis/#holt_winters) --> <!-- - [CHANDE_MOMENTUM_OSCILLATOR()](/influxdb/version/reference/influxql/functions/technical-analysis/#chande_momentum_oscillator) --> <!-- - [DOUBLE_EXPONENTIAL_MOVING_AVERAGE()](/influxdb/version/reference/influxql/functions/technical-analysis/#double_exponential_moving_average) --> <!-- - [EXPONENTIAL_MOVING_AVERAGE()](/influxdb/version/reference/influxql/functions/technical-analysis/#exponential_moving_average) --> <!-- - [KAUFMANS_EFFICIENCY_RATIO()](/influxdb/version/reference/influxql/functions/technical-analysis/#kaufmans_adaptive_moving_average) --> <!-- - [KAUFMANS_ADAPTIVE_MOVING_AVERAGE()](/influxdb/version/reference/influxql/functions/technical-analysis/#kaufmans_adaptive_moving_average) --> <!-- - [RELATIVE_STRENGTH_INDEX()](/influxdb/version/reference/influxql/functions/technical-analysis/#relative_strength_index) --> <!-- - [TRIPLE_EXPONENTIAL_MOVING_AVERAGE()](/influxdb/version/reference/influxql/functions/technical-analysis/#triple_exponential_moving_average) --> <!-- - [TRIPLE_EXPONENTIAL_DERIVATIVE()](/influxdb/version/reference/influxql/functions/technical-analysis/#triple_exponential_derivative) -->