Skip to content

::SMOOTH

Dashboards: browser · CLI · servers Community extension: anofox_render

Scatter + trend line (LOESS; ::SMOOTH_METHOD ‘lm’/‘gam’).

Also spelled: ::TRENDLINE, ::TREND_LINE

The minimal panel below, rendered

One row per observation: ::XAXIS and the measure, both numeric. Draws the points and a LOESS trend ('lm'::SMOOTH_METHOD for a straight line).

SELECT x ::XAXIS, x * 0.5 + sin(x) * 3 ::SMOOTH FROM range(0, 40) r(x);

Edit it in the builder ↗

From Which chart fits which question? — open it in the builder ↗:

SELECT 6::COL; SELECT day::XAXIS, y::SMOOTH, 'Scatter + LOESS trend (::SMOOTH)'::TITLE FROM ts ORDER BY day

::LINECHART · ::LINECHART_PERCENT · ::STEP · ::AREACHART · ::AREACHART_STACKED · ::CANDLESTICK · ::SPARKLINE · ::SPARKBAR