View InfluxQL functions

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

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.

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()