Query Generic Time Series Data

Fetches time-bucketed data from a specified table, allowing for dynamic aggregations, filtering, and pivoting.

This powerful and flexible endpoint can be used to generate data for charts and dashboards. It supports a wide range of aggregation functions, including percentiles and histograms.

Key Features:

• Dynamic Metrics & Aggregations: Specify multiple columns and aggregation functions.
• Pivoting: Create pivot-table-like results using the pivot_on parameter.
• Advanced Aggregations: Includes count, sum, avg, min, max, stddev, variance, median, percentiles (p50, p99.9), and histogram.
• Time Bucketing: Group data into intervals (e.g., 1 hour, 1 day). The API ensures a continuous time series by filling gaps with null or 0 values.
• Filtering: Apply standard filters on columns. Supported operators include $eq, $ne, $gt, $gte, $lt, $lte, $like, and $in.
• Result Limiting: The API returns a maximum of 10,000 time buckets per request.