Documentation

InfluxDB Cloud (TSM)

InfluxDB 3

  • InfluxDB 3 Core New
  • InfluxDB 3 Enterprise New
  • InfluxDB Clustered
  • InfluxDB 3 Cloud New
  • InfluxDB Cloud Serverless
  • InfluxDB Cloud Dedicated
  • InfluxDB 3 Explorer New

InfluxDB 2

  • InfluxDB OSS v2
  • InfluxDB Cloud (TSM)
  • Flux

InfluxDB 1

  • InfluxDB OSS v1
  • InfluxDB Enterprise
  • InfluxDB Cloud 1

Telegraf

  • Telegraf
  • Telegraf Controller New
  • Telegraf Enterprise New

Other products

  • Chronograf
  • Kapacitor
  • InfluxDB Cloud
  • Sign up
  • Get started
    • Set up InfluxDB
    • Write data
    • Query data
    • Process data
    • Visualize data
  • Upgrade to Cloud
    • 1.x to Cloud
      • Migrate CQs
    • 2.x to Cloud
  • Develop with the API
    • Quick start
    • Client library tutorials
      • Python
      • JavaScript
    • Client libraries
      • Arduino
      • C#
      • Dart
      • Go
      • Java
      • JavaScript for browsers
      • Kotlin
      • Node.js
        • Install
        • Write
        • Query
      • PHP
      • Python
      • R
      • Ruby
      • Scala
      • Swift
    • Invoke custom scripts
    • v1 compatibility
      • /query
      • /write
      • DBRP mapping
  • Write data
    • Load data source in UI
    • No-code solutions
      • Telegraf (agent)
        • Automatically configure Telegraf
        • Dual write to InfluxDB OSS and InfluxDB Cloud
        • Manually configure Telegraf
        • Use Telegraf plugins
          • HTTP input plugin
      • Third-party technologies
    • Developer tools
      • Third-party developer tools
      • Client libraries
      • Write CSV data
      • Write with line protocol
      • Influx CLI
      • Scrape Prometheus metrics
      • Write API
    • Best practices
      • Schema design
      • Resolve high cardinality
      • Optimize writes to InfluxDB
      • Handle duplicate points
    • Bulk ingest historical data
    • Write from OSS to Cloud
    • Edge data replication
      • Replicate data
    • Migrate data
      • Migrate data from OSS
      • Migrate from Cloud to Cloud
      • Migrate from Cloud to OSS
    • Troubleshoot issues
    • Delete data
  • Query data
    • Get started with Flux
      • Query InfluxDB
      • Transform data
    • Query with Flux
      • Query fields and tags
      • Group
      • Sort and limit
      • Window & aggregate
      • Explore your schema
      • Transform data with math
      • Calculate percentages
      • Cumulative sum
      • Fill
      • First & last
      • Histograms
      • Increase
      • Join
      • Median
      • Moving Average
      • Percentile & quantile
      • Rate
      • Conditional logic
      • Custom functions
        • Custom aggregate functions
      • Exists
      • Extract scalar values
      • Geo-temporal data
        • Shape geo-temporal data
        • Filter by region
        • Group geo-temporal data
      • Monitor states
      • Operate on timestamps
      • Query SQL data sources
      • Regular expressions
      • Flux version
    • Query with InfluxQL
      • Manage DBRP mappings
      • Explore data
        • SELECT statement
        • WHERE clause
        • GROUP BY clause
        • ORDER BY clause
        • LIMIT and SLIMIT clauses
        • OFFSET and SOFFSET clauses
        • Time and timezone
        • Subqueries
        • Regular expressions
      • Explore your schema
      • InfluxQL functions
        • Aggregates
        • Selectors
        • Technical analysis
        • Transformations
      • Manage your data
      • Mathematical operators
    • Execute queries
      • Query with sample data
      • Query with Data Explorer
      • Query with the InfluxDB API
      • Query in the Flux REPL
      • Use the influx CLI
    • Common queries
      • Operate on columns
      • Compare values from different buckets
      • Use multiple fields in a calculation
      • IoT common queries
    • Optimize queries
    • Parameterized queries
  • Process data
    • Get started with tasks
    • Manage tasks
      • Create a task
      • View tasks
      • Run a task
      • View run history
      • Update a task
      • Export a task
      • Delete a task
    • Common tasks
      • Downsample with InfluxDB
      • Downsample with Quix
    • Task options
  • Visualize data
    • Explore metrics
    • Manage dashboards
      • Create a dashboard
      • Control a dashboard
      • Export a dashboard
      • Delete a dashboard
    • Use and manage variables
      • Create a variable
      • Update a variable
      • View variables
      • Export a variable
      • Delete a variable
      • Variable types
      • Common variable queries
    • Manage labels
    • Use annotations
    • Visualization types
      • Band
      • Gauge
      • Graph
      • Graph + Single Stat
      • Heatmap
      • Histogram
      • Mosaic
      • Scatter
      • Single Stat
      • Table
      • Map
  • Monitor & alert
    • Manage checks
      • Create checks
      • View checks
      • Update checks
      • Delete checks
    • Manage notification endpoints
      • Create endpoints
      • View endpoint history
      • Update endpoints
      • Delete endpoints
    • Manage notification rules
      • Create notification rules
      • View notification rules
      • Update notification rules
      • Delete notification rules
    • Monitor with templates
      • Monitor InfluxDB Enterprise
      • Monitor InfluxDB OSS 2.x
      • Monitor infrastructure
        • AWS CloudWatch
        • Raspberry Pi
        • Docker
        • vSphere
        • Windows
      • Monitor networks
        • HAproxy
    • Send alert email
    • Create custom checks
  • Account management
    • Pricing plans
    • Manage billing
    • View data usage
    • Change your password
    • Switch InfluxDB accounts
    • Switch InfluxDB organizations
    • Cancel InfluxDB Cloud
    • Adjustable quotas and limits
  • Tools & integrations
    • Telegraf configurations
      • Create a config
      • Clone a config
      • View configs
      • Update a config
      • Remove a config
    • Notebooks
      • Overview of notebooks
      • Create a notebook
      • Manage notebooks
      • Downsample data
      • Normalize data
      • Troubleshoot notebooks
    • InfluxDB templates
      • Templates in Cloud
      • Use templates
      • Create a template
      • InfluxDB stacks
        • Initialize a stack
        • Update a stack
        • View stacks
        • Remove a stack
    • influx CLI
    • Flux REPL
    • InfluxQL shell
    • Flux LSP with Vim
    • Grafana
    • Chronograf
    • Kapacitor
    • Postman
    • ThingWorx
    • Documentation MCP server
  • Administer InfluxDB Cloud
    • Identify version
    • Manage organizations
      • View organizations
      • Update an organization
      • Delete your organization
      • Manage users
      • Replicate an organization
    • Manage buckets
      • Create a bucket
      • Update a bucket
      • View buckets
      • Delete a bucket
      • Manage explicit bucket schemas
    • Manage tokens
      • Create a token
      • View tokens
      • Update a token
      • Delete a token
      • Use tokens
    • Manage secrets
      • Add secrets
      • View secret keys
      • Update secrets
      • Delete secrets
      • Use secrets
  • Reference
    • Release notes
      • InfluxDB Cloud updates
      • influx CLI
    • Key concepts
      • Data elements
      • Data schema
      • Design principles
    • Command line tools
      • influx
        • influx apply
        • influx auth
          • influx auth active
          • influx auth create
          • influx auth delete
          • influx auth inactive
          • influx auth list
        • influx backup
        • influx bucket
          • influx bucket create
          • influx bucket delete
          • influx bucket list
          • influx bucket update
        • influx bucket-schema
          • influx bucket-schema create
          • influx bucket-schema list
          • influx bucket-schema update
        • influx completion
        • influx config
          • influx config create
          • influx config list
          • influx config rm
          • influx config set
        • influx dashboards
        • influx delete
        • influx export
          • influx export all
          • influx export stack
        • influx help
        • influx org
          • influx org create
          • influx org delete
          • influx org list
          • influx org members
            • influx org members add
            • influx org members list
            • influx org members remove
          • influx org update
        • influx ping
        • influx query
        • influx remote
          • influx remote create
          • influx remote delete
          • influx remote list
          • influx remote update
        • influx replication
          • influx replication create
          • influx replication delete
          • influx replication list
          • influx replication update
        • influx restore
        • influx scripts
          • influx scripts create
          • influx scripts delete
          • influx scripts invoke
          • influx scripts list
          • influx scripts retrieve
          • influx scripts update
        • influx secret
          • influx secret delete
          • influx secret list
          • influx secret update
        • influx setup
        • influx stacks
          • influx stacks init
          • influx stacks remove
          • influx stacks update
        • influx task
          • influx task create
          • influx task delete
          • influx task list
          • influx task log
            • influx task log list
          • influx task retry-failed
          • influx task run
            • influx task run list
            • influx task run retry
          • influx task update
        • influx telegrafs
          • influx telegrafs create
          • influx telegrafs rm
          • influx telegrafs update
        • influx template
          • influx template validate
        • influx user
          • influx user create
          • influx user delete
          • influx user list
          • influx user password
          • influx user update
        • influx v1
          • influx v1 auth
            • influx v1 auth create
            • influx v1 auth delete
            • influx v1 auth list
            • influx v1 auth set-active
            • influx v1 auth set-inactive
            • influx v1 auth set-password
          • influx v1 dbrp
            • influx v1 dbrp create
            • influx v1 dbrp delete
            • influx v1 dbrp list
            • influx v1 dbrp update
          • influx v1 shell
        • influx write
          • influx write dryrun
        • influx version
    • Syntax
      • Flux
        • Flux vs InfluxQL
      • InfluxQL
        • InfluxQL 2.x specification
        • InfluxQL internals
      • Line protocol
      • Annotated CSV
        • Extended annotated CSV
      • Delete predicate
    • InfluxDB Cloud regions
    • InfluxDB Cloud internals
      • Data durability
      • Security
      • System buckets
      • Time To Become Readable
      • Data retention
    • Sample data
    • Prometheus metrics
    • Frequently asked questions
    • Policies & procedures
      • End-of-life procedures
    • Glossary
    • Service notices
      • EOL - Native Collector - MQTT
    • InfluxDB HTTP API
      • Quick start
      • Authentication
      • Common parameters
      • Headers
      • Pagination
      • Response codes
      • Supported operations
      • Authorizations (API tokens)
      • Bucket Schemas
      • Buckets
      • Cells
      • Checks
      • Config
      • Dashboards
      • DBRPs
      • Delete
      • Invokable Scripts
      • Labels
      • Legacy Authorizations
      • Legacy Query
      • Legacy Write
      • Limits
      • NotificationEndpoints
      • NotificationRules
      • Organizations
      • Ping
      • Query data
      • Resources
      • Routes
      • Rules
      • Secrets
      • Security and access endpoints
      • Setup
      • Signin
      • Signout
      • System information endpoints
      • Tasks
      • Telegraf Plugins
      • Telegrafs
      • Templates
      • Usage
      • Users
      • Variables
      • Views
      • Write data
      • All endpoints
  • Flux

  • Flux v0 Documentation
  • Get started with Flux
  • Flux standard library

Related to "Aggregates"

Window and aggregate data with Flux

This guide walks through windowing and aggregating data with Flux and outlines how it shapes your data in the process.

Create custom aggregate functions

Create your own custom aggregate functions in Flux using the reduce() function.

© 2026 InfluxData, Inc.

Select your InfluxDB Cloud region

Select your InfluxDB Cloud region and cluster and we’ll customize code examples for you. Identify your InfluxDB Cloud cluster.

AWS
  • US West (Oregon)

GCP
Azure

For more information, see InfluxDB Cloud regions.

Thank you for your feedback!

Let us know what we can do better:

Thank you!

No thanks

InfluxDB OSS 2.9.0: API tokens are hashed by default

Stronger token security in InfluxDB OSS 2.9.0 — tokens are hashed on disk by default. Existing tokens are hashed on first startup and can’t be recovered afterward. Capture any plaintext tokens you still need before you upgrade.

View InfluxDB OSS 2.9.0 release notes

Hashed tokens authenticate exactly like unhashed tokens — clients and integrations keep working.

Also new in 2.9.0:

  • Configurable backup compression
  • Restore support for backups containing hashed tokens
  • Tighter Edge Data Replication queue validation
  • Flux upgrade
  • Compaction reliability improvements

Key enhancements in Explorer 1.9

Explorer 1.9 is now available with InfluxQL support, an AI-assisted Flux to SQL converter (beta), and new live sample data simulators.

View Explorer 1.9 release notes

Explorer 1.9 includes new features and improvements that make it easier to query, visualize, and manage data.

Highlights:

  • Flux to SQL converter (beta): Convert Flux queries to SQL with an AI-assisted converter.
  • InfluxQL support: Query data with InfluxQL in the Data Explorer and dashboards, and save and load InfluxQL queries.
  • InfluxQL visualizations: Render line and bar charts from InfluxQL results with per-tag series grouping.
  • Query error history: Review a history of query errors in the query tool.
  • Live sample data simulators: Generate continuous live sample data with new bird data and signal generator simulators.

For more details, see Explorer 1.9 release notes

InfluxDB 3.10 is now available

InfluxDB 3 Core 3.10 adds an automatic catalog format upgrade, a configurable query-concurrency limit, and processing engine improvements.

Key updates in InfluxDB 3 Core 3.10:

  • Catalog format upgrade: the on-disk catalog automatically upgrades from format v2 to v3 on first 3.10 startup. Migration is one-way—back up your catalog before upgrading.
  • --max-concurrent-queries: limit concurrent queries (adjustable at runtime).
  • GET /ready endpoint for readiness probes.
  • Processing engine: cross-database queries and trigger lockdown flags.

For more information, see the InfluxDB 3 Core release notes.

InfluxDB 3.10 is now available

InfluxDB 3 Enterprise 3.10 adds automated backup and restore, row-level deletions, and user management, with an automatic catalog format upgrade and performance preview improvements.

Key updates in InfluxDB 3 Enterprise 3.10:

  • Catalog format upgrade: the on-disk catalog automatically upgrades from format v2 to v3 on first 3.10 startup. Migration is one-way—back up your catalog before upgrading.
  • Automated backup and restore (beta)
  • Row-level deletions
  • User management (authentication and RBAC) — preview
  • Performance preview improvements

Backup and restore, row-level deletions, and the performance preview require the Enterprise storage engine upgrade (opt-in beta). Beta and preview features are subject to breaking changes and aren’t recommended for production use.

For more information, see the InfluxDB 3 Enterprise release notes

Telegraf Enterprise is now generally available

Telegraf Enterprise is now generally available, along with Telegraf Controller v1.0.

Telegraf Enterprise combines Telegraf Controller, a centralized management console for Telegraf, with official support from InfluxData. Manage configurations, monitor fleet health, and operate tens of thousands of Telegraf agents from a single system.

  • Read the announcement
  • Documentation
  • Download and install Telegraf Controller

InfluxDB Docker latest tag changing to InfluxDB 3 Core

On September 15, 2026, the latest tag for InfluxDB Docker images will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments.

If using Docker to install and run InfluxDB, the latest tag will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments. For example, if using Docker to run InfluxDB v2, replace the latest version tag with a specific version tag in your Docker pull command–for example:

docker pull influxdb:2
Ask AI

InfluxDB Cloud powered by TSM

You are currently viewing documentation specific to InfluxDB Cloud powered by the TSM storage engine, which offers different functionality than InfluxDB Cloud Serverless powered by the v3 storage engine.

Are you using InfluxDB Cloud powered by TSM? How to find out?

Visit your organization's homepage and find the following at the bottom of the right column:

InfluxDB Cloud powered by TSM Storage Engine Version 2
Yes – I'm using InfluxDB Cloud (TSM) No – I'm using InfluxDB Cloud Serverless