We have reference doc for each function, but also background info.

Reference

One line for each function + links.

Foundation

Explains concepts like discrete, continuous, and interpolation.

Tips & Tricks

Fine tune queries, perform aggregation, and more.

QL Recipes

Sample queries for common tasks.

Pages labeled with .

List of all functions (and some links to get you started).

TitleSummary
after Function Reference to the after() function
closed Function Reference to the closed() function
first and last Functions Reference to the first() and last() functions
firstEnding and lastEnding Functions Reference to the firstEnding() and lastEnding() functions
ongoing Function Reference to the ongoing() function
since Function Reference to the since() function
timespan Function Reference to the timespan() function
until Function Reference to the until() function
align Function Reference to the align() function
alignedSummary Function Reference to the alignedSummary() function
hs Function Reference to the hs() function
median Function Reference to the median() function
merge Function Reference to the merge() function
summary Function Reference to the summary() function
abs Function Reference to the abs() function
aliasMetric Function Reference to the aliasMetric() function
aliasSource Function Reference to the aliasSource() function
align Function Reference to the align() function
all Function Reference to the all() function
anomalous Function Reference to the anomalous() function
any Function Reference to the any() function
at Function Reference to the at() function
atEpoch Function Reference to the atEpoch() function
avg Function Reference to the avg() function
bestEffort Function Reference to the bestEffort() function
between Function Reference to the between() function
bottom Function Reference to the bottom() function
bottomk Function Reference to the bottomk() function
ceil Function Reference to the ceil() function
charAt Function Reference to the charAt string manipulation function
collect Function Reference to the collect() function
concat Function Reference to the concat string manipulation function
contains Function Reference to the contains() string manipulation functions
count Function Reference to the count() function
counter_sum Function Reference to the counter_sum() function
day Function Reference to the day() function
dayOfYear Function Reference to the dayOfYear() function
default Function Reference to the default() function
deriv Function Reference to the deriv() function
downsample Function Reference to the downsample() function
equals, equalsIgnoreCase, and matches Functions Reference to the equals(), equalsIgnoreCase(), and matches() string manipulation functions
exists Function Reference to the exists() function
exp Function Reference to the exp() function
filter Function Reference to the filter() function
flapping Function Reference to the flapping() function
floor Function Reference to the floor() function
ts Function Reference to the ts() function
haversine Function Reference to the haversine() function
hideAfter Function Reference to the hideAfter() function
hideBefore Function Reference to the hideBefore() function
highpass Function Reference to the highpass() function
hour Function Reference to the hour() function
hw Function Reference to the hw() function
if Function Reference to the if() function
indexOf and lastIndexOf Functions Reference to the indexOf() and lastIndexOf() string manipulation functions
integral Function Reference to the integral() function
integrate Function Reference to the integrate() moving time window function
interpolate Function Reference to the interpolate() function
isToday Function Reference to the isToday() function
isBlank and isEmpty Functions Reference to the isBlank() and isEmpty() string manipulation functions
lag Function Reference to the lag() function
last Function Reference to the last() function
lead Function Reference to the lead() function
length Function Reference to the length() string manipulation function
limit Function Reference to the limit() function
log Function Reference to the log() function
log10 Function Reference to the log10() function
lowpass Function Reference to the lowpass() function
mavg Function Reference to the mavg() function
max Function Reference to the max() function
mcorr Function Reference to the mcorr() function
mcount Function Reference to the mcount() function
mdiff Function Reference to the mdiff() function
min Function Reference to the min() function
mmax Function Reference to the mmax() function
mmedian Function Reference to the mmedian() function
mmin Function Reference to the mmin() function
month Function Reference to the month() function
mpercentile Function Reference to the mpercentile() function
mseriescount Function Reference to the mseriescount() function
msum Function Reference to the msum() function
mvar Function Reference to the mvar() function
next Function Reference to the next() function
nnforecast Function Reference to the nnforecast() function
normalize Function Reference to the normalize() function
percentile Function Reference to the percentile() function
pow Function Reference to the pow() function
random Function Reference to the random() function
rate Function Reference to the rate() function
ratediff Function Reference to the ratediff() function
rawavg Function Reference to the rawavg() function
rawcount Function Reference to the rawcount() function
rawmax Function Reference to the rawmax() function
rawmin Function Reference to the rawmin() function
rawpercentile Function Reference to the rawpercentile() function
rawsum Function Reference to the rawsum() function
rawvariance Function Reference to the rawvariance() function
removeSeries Function Reference to the removeSeries() function
repeat Function Reference to the repeat string manipulation function
retainSeries Function Reference to the retainSeries() function
round Function Reference to the round() function
sample Function Reference to the sample() function
sqrt Function Reference to the sqrt() function
startsWith and endsWith Functions Reference to the startsWith() and endsWith() string manipulation functions
substring Function Reference to the substring string manipulation function
sum Function Reference to the sum() function
time Function Reference to the time() function
timestamp Function Reference to the timestamp() function
toLowerCase and toUpperCase Functions Reference to the toLowerCase() and toUpperCase() string manipulation functions
top Function Reference to the top() function
topk Function Reference to the topk() function
Trigonometric Functions Reference to the trigonometric functions
Trigonometric Utility Functions Reference to the trigonometric utility functions
trim, strip, stripLeading, and stripTrailing Functions Reference to the trim, strip, stripLeading, and stripTrailing string manipulation function
variance Function Reference to the variance() function
weekday Function Reference to the weekday() function
year Function Reference to the year() function