docs-v2/content/shared/influxdb-v2/query-data/influxql/functions/_index.md

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

{{% note %}} To query with InfluxQL, the bucket you query must be mapped to a database and retention policy (DBRP). For more information, see how to Query data with InfluxQL. {{%/ note %}}

InfluxQL functions (by type)

• Aggregates
  • COUNT()
  • DISTINCT()
  • INTEGRAL()
  • MEAN()
  • MEDIAN()
  • MODE()
  • SPREAD()
  • STDDEV()
  • SUM()
• Selectors
  • BOTTOM()
  • FIRST()
  • LAST()
  • MAX()
  • MIN()
  • PERCENTILE()
  • SAMPLE()
  • TOP()
• Transformations
  • ABS()
  • ACOS()
  • ASIN()
  • ATAN()
  • ATAN2()
  • CEIL()
  • COS()
  • CUMULATIVE_SUM()
  • DERIVATIVE()
  • DIFFERENCE()
  • ELAPSED()
  • EXP()
  • FLOOR()
  • HISTOGRAM()
  • LN()
  • LOG()
  • LOG2()
  • LOG10()
  • MOVING_AVERAGE()
  • NON_NEGATIVE_DERIVATIVE()
  • NON_NEGATIVE_DIFFERENCE()
  • POW()
  • ROUND()
  • SIN()
  • SQRT()
  • TAN()
• Technical analysis
  • (Predictive analysis) HOLT_WINTERS()
  • CHANDE_MOMENTUM_OSCILLATOR()
  • EXPONENTIAL_MOVING_AVERAGE()
  • DOUBLE_EXPONENTIAL_MOVING_AVERAGE()
  • KAUFMANS_EFFICIENCY_RATIO()
  • KAUFMANS_ADAPTIVE_MOVING_AVERAGE()
  • TRIPLE_EXPONENTIAL_MOVING_AVERAGE()
  • TRIPLE_EXPONENTIAL_DERIVATIVE()
  • RELATIVE_STRENGTH_INDEX()